Hello Billy Ng, You wrote:
> I have a pretty similar question. I am trying to export a Access database > with Japanese into MySQL in a Linux box. I installed the ODBC and export > all tables to MySQL. However, When I SELECT the records, I notice the > Japanese in fields are not the same as in Access. Any idea? The encoding for files from Access is likely to be shift-JIS or Unicode UTF-16. Have you checked that? Have you read through the information section 4.6.1, "Character Set Used for Data and Sorting", and are you setting the --default-charset, --with-charset and/or --with-extra-charset options appropriately? You need to make sure MySQL and Access are talking the same encoding, probably shift-JIS. (If Access can export euc-JIS, that might even be better.) If that's not your problem, I can't think of anything off-hand. Maybe someone else on the list can. I'll this to the list and BCC you, hope you don't mind. (BCCing you means you'll have to watch the list for answers.) Thanks for making me look up the charset options for MySQL again. Now maybe I'll get my machine set up right. ;-) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
