I have MSSQL Server 2005 and MySQL Server as a linked server.
I want to save certain data from MSSQL to MySQL.
And I have a huge encoding issue.
MS SQL
select SERVERPROPERTY ('collation')
Result: Cyrillic_General_CI_AS
MySQL
mysql> SHOW VARIABLES LIKE 'character \ _set \ _%';
+ -------------------------- + -------- +
| Variable_name | Value |
+ -------------------------- + -------- +
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
+ -------------------------- + -------- +
MySQL MySQL
,
- "???????????????"
UTF-8, ?
?
MySQL CP-1251, .