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.
581 PHP ssh2_scp_send fails to send files as intended
610 GDB gets version error when attempting to debug with the Presense SDK (IDE)
617 Uncaught (inpromise) Error on Electron: An object could not be cloned
914 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error
572 rails db:create error: Could not find mysql2-0.5.4 in any of the sources
© 2024 OneMinuteCode. All rights reserved.