oracle 链接 Mysql 乱码问题请教
oracle10g 中文字符集
Mysql
mysql> show variables like '%collation%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
mysql> show variables like '%charac%';
+--------------------------+-------------
-----+
| Variable_name | Value
|
+--------------------------+-------------
-----+
| character_set_client | latin1
|
| character_set_connection | latin1
|
| character_set_database | latin1
|
| character_set_filesystem | binary
|
| character_set_results | latin1
|
| character_set_server | latin1
|
| character_set_system | utf8
问题:
有两个库 A(utf8) mysql query browser 显示正常,但是oracle(select * from t_table@daoan)乱码
B(latin1) mysql query browser 显示乱码,但是oracle(select * from t_area@daoan)正常
怎么更改配置使得A达到B的效果
我的尝试:source *.sql恢复不行,在命令行中insert数据可以,但是表太大复制黏贴在命令行执行不太现实