Re: How to Insert Chinese into Mysql database with ASP
Chetan,
Let's see if it the server side configuration is OK before testing from ASP. Make sure that the values of character set are like below, before you create the table and insert the data.
mysql> show variables like 'char%';
+--------------------------+-----------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------+
| character_set_client | big5 |
| character_set_connection | big5 |
| character_set_database | big5 |
| character_set_results | big5 |
| character_set_server | big5 |
| character_set_system | utf8 |
| character_sets_dir | C:\mysql\share\charsets\ |
+--------------------------+-----------------------------+
Above all, your client terminal (MS-DOS I guess?) have to support big5 encoding to display the character correctly.
Subject
Views
Written By
Posted
10068
May 24, 2005 01:59PM
Re: How to Insert Chinese into Mysql database with ASP
4486
May 25, 2005 11:31AM
4308
May 25, 2005 11:33AM
3140
May 25, 2005 11:36AM
3042
September 19, 2005 02:13PM
5617
September 21, 2005 03:05AM
4469
September 22, 2005 07:58AM
3021
September 28, 2005 03:34PM
2930
September 28, 2005 03:42PM
6411
September 29, 2005 08:42PM
2982
November 24, 2005 08:36AM
2923
December 01, 2005 06:35AM
2853
October 13, 2006 09:50AM
2962
January 26, 2006 01:34AM
4185
January 26, 2006 01:50AM
5267
February 23, 2006 08:22AM
5667
June 14, 2006 01:05PM
3064
August 09, 2006 07:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.