Oracle配置UTF-8字符集详述(原创)_解决各种影响乱码的场景_NLS_LANG设置utf8

Oracle

UTF-8

3星 · 超过75%的资源需积分: 50 147 浏览量更新于2023-03-03 评论收藏 1.73MB DOC 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

How to Setup Oracle Database in Charset UTF-8

Table of Contents
 Document Control...........................................................................................................................................2
 Revision History 2
 Document Approval and Distribution 2
Introduction...................................................................................................................................................4
How to create an UTF-8DB..........................................................................................................................4
1  Run DBCA to new create a Database 4
2  Oracle Character Set Concept 6
Verify charset for DB dump file...................................................................................................................7
1  Split DB dump file to get useful information 7
2  Get the hex information in Ultra-Edit 8
3  Get charset ID of the DB dump file 8
4  Check whether the dump file Char Set is UTF88
Import the dump file.....................................................................................................................................9
1  Create a user 9
2  Grant 9
3  Get exporting schema 9
4  In client side, set consistency NLS_LANG with DB 9
5  Verify real Char Set in the imported DB 10
Configuration Character Set in Client Side and Terminator......................................................................10
1  Character Sets in DB Server, Client Side, Terminator 10
2  Configuration for Client Side SQLPlus 11
2.1  Inconsistency Character Set solution A,..............................................................................12
2.2  Inconsistency Character Set solution B...............................................................................15
3  Configuration for Client Side PL/SQL Developer 16
3.1  Configuration for PL/SQL Developer7.0............................................................................16
3.2  Configuration for Client Side PL/SQL Developer 8.0.........................................................16
4  Configuration for Client Side TOAD 18
5  Configuration for iSQL*Plus18
6  Client Side in Java 19
6.1  Java Character encoding......................................................................................................19
6.2  Oracle JDBC Thin Driver and Character encoding.............................................................19
Export DB dump.........................................................................................................................................20
1  Inconsistency Char Set, Client NLS_LANG=GBK 20
2  Consistency Char Set Client NLS_LANG=UTF8 21
3