You are trying to export from Access DB to MySQL using MySQL ODBC.
Select the table in MS Access, export → ODBC database, and
When you run it,
ODBC - The call failed.
Incorrect string value....
appears and cannot be exported.
I think there is something wrong with the character code specification, but I can't find the cause.
The DB character code for Access is SJIS.
MySQL character code is also SJIS. My.ini has the following settings.
[mysql]
default-character-set=sjis
[mysqld]
default-character-set=sjis
Could you please let me know where to fix it?
That's all. Thank you for your cooperation.
mysql ms-access
MySQL sjis does not contain the so-called model-dependent characters (such as 」 and 」), which are often used in Windows, so I think it would be better to use cp932 instead of sjis.
© 2024 OneMinuteCode. All rights reserved.