SQLyog Configuring SQL Assitant

Source: Internet
Author: User
Tags documentation mysql query

In the previous post, "MySQL Configuration SQL Assistant hint", I introduced the configuration SQL Assitant comes with SQL Editor connection MySQL database configuration, but after two days of trial found that SQL editor does not support Chinese query results, Chinese will become? String that is stored in Chinese in the "name" column, as follows:

To view the character encoding of the column, set the UFT8, with navicate query result set normal, it seems that the problem of SQL Editor, to Baidu, Bing find related content, have not found, finally had to email to SQL Assitant Technical support, and finally get the following reply:
the Editor doesn ' t currently support display of a Unicode characters in native language, that's why you see Questi On marks in place of each character. Sincerely,
Technical support at Softtree Technologies, Inc.
Depressed, engaged in a half-day SQL editor temporarily does not support the Chinese result set query, how to do? See someone on the Internet using SQL Assitant, but there is no sqlyog option when installing, only the official MySQL Workbench and MySQL Query browser, is SQL Assitant support custom extensions SQLyog? Check the official documentation and really find a chapter that describes the relevant configuration-"Registering and configuring Targets for SQL assitance".        According to the above introduction, the final configuration is successful, finally can efficiently write SQL, hey ... The configuration of the way is outlined below (note: Before configuring the SQLyog, be sure to follow my previous article "MySQL Configuration SQL Assistant Tips" in the introduction, the MySQL configuration first set up a good) 1. First install the SQLyog 32-bit software (SQL Assitant currently does not support 64-bit software), open the SQL Assistant software and SQLyog, click on the SQLyog form, determine the focus of the mouse is on the SQLyog, press the shortcut key Ctrl+shift+f5, The SQL Assistant configuration form will pop up, such as: 2. Configure it as follows and click "OK" to confirm 3. Now you can see the effect in SQLyog, the menu bar has added the SQL Assistant menu, the input hints appear, the final result, the Chinese string is not garbled reference document: SQL Assitant official documentation

SQLyog Configuring SQL Assitant

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.