Wednesday, March 09, 2005

ACCESS -> MySQL

Use MySQL ODBC connector to do this. Very smooth. But one problem.

If I create the MySQL database as utf8, then each Chinese character being takes 4-bytes space. UTF8 use 3-bytes for Chinese character, that is weird. But if the MySQL database is created using default (latin1). Then each Chinese character takes 2 bytes. in both cases, they are correctly displayed in mysql client tool.

Finally I found the problem is because myodbc-3.51 doesn't support Unicode yet.

0 Comments:

Post a Comment

<< Home