Re: How to Insert Chinese into Mysql database with ASP

[Michael L Joseph]

Hi Chetan,

To be able to see the chinese data in MySQL Query Browser, you have to change the default font in the Query Browser's settings. This can easily be done by you go to the main menu and select TOOLS, then the on the sub-menu select OPTIONS... a pop-up menu will apear with a category menu consisting of options such as BROWSER, GENERAL OPTIONS, CONNECTIONS, EDITORS. Select GENERAL OPTIONS. In order to see the chinese characters in the Query browser, you have to change the default font from 'Times New Romans' to a font which can display chinese characters i.e. MS Arial Unicode, MS Mincho or MS SimSun. If you want to display Korean choose MS Batang. Change the Default, Data and Code fonts to the appropriate font so that you can enter the chinese characters in the appropriate font in the browser sql box like when you insert new data, also, the sql resultsets will have the data displayed in chinese characters using the font set in options.

Personally, I would advise people to use utf8 as the character set column type for the data's column format and use MS Arial Unicode set as the default font in options.
This way you can store multiple characters in diferent languages.