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