MSSQL 和 MySQL 作为链接服务器

发布于 2024-10-05 10:38:25 字数 930 浏览 0 评论 0原文

我有一个 MSSQL Server 2005 和 MySQL Server 作为链接服务器。
我想将特定数据从 MSSQL 保存到 MySQL。
我有一个与编码相关的大问题。

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 编码？

或者我应该更改一些设置？我不想改变 CP-1251 上 MySQL 服务器的编码，这对我来说不方便。

原文

I have a MSSQL Server 2005 and MySQL Server as linked server.
I want to save particular data from MSSQL to MySQL.
And I have a huge problem related with encoding.

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   |
+--------------------------+--------+

When I'm trying to retrive data from MySQL or to insert ones to MySQL
I have a wrong character set in text field,
something like that "???????????????"

How can I convert text data to UTF-8 encoding before inserting the data to linked server?

Or should I change some settings?
I don't want to change encoding of MySQL server on CP-1251, it's not convenient for me.

分享到QQ

分享到微博