SQLyog Configuring SQL Assitant

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