2003 9
... 3 Oracle Database 10g... 3... 3... 4 Unicode... 6 Unicode... 6... 7... 8... 8... 9... 9... 10... 10... 10... 11... 11 US7ASCII... 13... 14... 14 Export/Import... 14 CSALTER... 15 Export Import CSALTER... 15 Oracle Migration... 16... 16... 16... 16... 16... 17 1) US7ASCII... 17 2) WE8ISO8859P1 WE8ISO8859P15... 18 3) AL32UTF8... 18 4) /... 19... 19 2 Oracle Corporation Character Set Migration Best Practices
Oracle9i Database Character Set Migration in Oracle9i Oracle Unicode Unicode Oracle Database 10g CSALTER DBA Character Set Scanner Utilities ALTER DATABASE CHARACTER SET CSALTER CSALTER 1 2 3 ASCII 7 8 3 Oracle Corporation Character Set Migration Best Practices
Unicode Java World Wide Web ASCII C ~ 1252 Windows 1 1 2 Windows Windows Oracle Database 4 Oracle Corporation Character Set Migration Best Practices
A B B A A B A B WE8MSWIN1252 WE8ISO8859P1 WE8MSWIN1252 WE8ISO8859P1 Oracle B ä a a 1) 2) 3) 5 Oracle Corporation Character Set Migration Best Practices
Unicode Unicode Unicode Unicode Unicode Unicode 1 Unicode Unicode Unicode Unicode Oracle Oracle Database 10g Unicode 10% SQL Unicode Unicode 1) Oracle Unicode http://otn.oracle.co.jp/products/database/oracle10g/index.html Unicode Unicode SQL NCHAR Unicode NCHAR Oracle9i Unicode Unicode National Character Set UTF-16 1 UTF-8 1) AL16UTF16 2) UTF8 1 Oracle UTF8 Unicode 3.0 UTF-8 CESU-8 6 Oracle Corporation Character Set Migration Best Practices
SQL NCHAR ALTER TABLE MODIFY COLUMN SQL CHAR SQL NCHAR : ALTER TABLE emp MODIFY (ename NVARCHAR2(10)); SQL NCHAR 1) NCHAR Unicode 2) UCS-2 UTF-16 3) SQL NCHAR Unicode SQL NCHAR NCHAR NCHAR NCHAR CHAR Oracle NCHAR DATE NUMBER ROWID RAW CLOB NCHAR CHAR Oracle TO_NCHAR(), TO_CHAR(), TO_CLOB(), TO_NCLOB(), TO_NUMBER(), TO_DATE() UNISTR(), ASCIISTR(), ROWIDTONCHAR(), CHARTOROWID() 1) / Unicode http://otn.oracle.co.jp/products/database/oracle10g/index.html IT 1) 7 Oracle Corporation Character Set Migration Best Practices
2) 3) Database Character Set Scanner 4 A 16 41 A 16 41 A Oracle Database 10g CSALTER A 16 41 A 16 90 8 Oracle Corporation Character Set Migration Best Practices
Unicode 1 2 C WE8MSWIN1252 16 80 WE8ISO8859P1 Latin 1 Database Character Set Scanner Scanner 30 Export Import VARCHAR (1) 1 1 Unicode UTF-8 1 1 4 UTF-8 UTF-8 UTF-8 2 2 UTF-8 3 English [ ] (1%) European [ä ß ñ] (10%) Export/Import 9 Oracle Corporation Character Set Migration Best Practices
A B B A B A B? ä a a 3 1) PASS-THRU PASS-THRU 2) 3) Database Character Set Scanner 1 8859-1 CHAR(1)UTF-8 10 Oracle Corporation Character Set Migration Best Practices
1 CHAR(4) Oracle9i UTF-8 1 8 Unicode AL32UTF8 VARCHAR2 NLS_LENGTH_SEMANTICS NCHAR NCHAR CHAR BYTE NLS_LANG NLS_LANG Windows 1252 Oracle WE8MSWIN1252 NLS_LANG NLS_LANG 2 1) 1 NLS_LANG OPERATING SYSTEM 11 Oracle Corporation Character Set Migration Best Practices
NLS_LANG NLS_LANG A 16 61 NLS_LANG 061 % A % 1 1 2) 2 NLS_LANG OPERATING SYSTEM NLS_LANG OPERATING SYSTEM NLS_LANG Oracle PASS-THRU NLS_LANG 12 Oracle Corporation Character Set Migration Best Practices
PASS-THRU 2 US7ASCII US7ASCII 8 / Oracle9i ALTER DATABASE CHARACTER SET Oracle Database 10g CSALTER US7ASCII ASCII US7ASCII 2 1) 1 PASS-THRU NLS_LANG US7ASCII 8 Oracle Migration NLS_LANG 8 13 Oracle Corporation Character Set Migration Best Practices
7 1 2) 2 NLS_LANG NLS_LANG Oracle US7ASCII 7 7 8 7 7 a 8 ä Oracle Character Set Migration Utility Export/Import Export/Import Oracle Database Oracle Database Export Export Export Oracle Import Import Export Oracle Database Oracle9i Export Unicode Oracle8i Export Export NLS_LANG Import Import Import Export Import Oracle Database Oracle Streams Export Import Oracle Streams 14 Oracle Corporation Character Set Migration Best Practices
CSALTER CSALTER DBA Character Set Scanner Utilities CSALTER 1) 2) US7ASCII CSALTER CSALTER CLOB Oracle Sample Schema CLOB Oracle9i Sample Schema CLOB CLOB CLOB UCS-2 CLOB CSALTER Oracle Sample Schema CLOB CSALTER CLOB Export Import CSALTER CSALTER Oracle Sample Schema CLOB 1 CSALTER Export Import CSALTER Import 3 CSALTER Oracle Database 15 Oracle Corporation Character Set Migration Best Practices
Oracle Migration 1 2 1 3 Oracle Migration Database Character Set Scanner 1 :2 UTF-8 ASCII 1 2 3 4 Import 16 Oracle Corporation Character Set Migration Best Practices
Database Character Set Scanner 1) US7ASCII US7ASCII NLS_LANG AMERICAN_AMERICA.US7ASCII PASS-THRU Windows ASCII US7ASCII AL32UTF8 Database Character Set Scanner 8 ä a CSALTER 8 Windows 8 Latin 1 WE8ISO8859P1 WE8MSWIN1252 Microsoft WE8MSWIN1252 8 WE8MSWIN1252 8 WE8ISO8859P1 AL32UTF8 UTF-8 2 Export Import US7ASCII 2 WE8MSWIN1252 WE8ISO8859P1 UTF-8 17 Oracle Corporation Character Set Migration Best Practices
2) WE8ISO8859P1 WE8ISO8859P15 WE8ISO8859P1 Latin 1 WE8ISO8859P15 Latin 9 WE8ISO8859P1 WE8ISO8859P15 {¼, ½, ¾,, } WE8ISO8859P1 WE8ISO8859P15 CSALTER CSALTER / CSALTER WE8ISO8859P15 Oracle Locale Builder WE8ISO8859P1 Export Import 3) AL32UTF8 ASCII ASCII CSALTER Export Import ASCII UTF-8 2 Euro 2 3 Export Import CSALTER Oracles Migration Services CSALTER ASCII AL32UTF8 18 Oracle Corporation Character Set Migration Best Practices
WE8ISO8859P1 Latin 1 AL32UTF8 UTF-8 WE8ISO8859P1 AL32UTF8 Database Character Set Scanner PASS-THRU Export Import WE8ISO8859P1 Export AL32UTF8 Import 4) / ZHS16GBK Unicode Oracle Database 10g 94,140 AL32UTF8 Export Import 1 2 ZHS16GBK 3 AL32UTF8 Oracle 19 Oracle Corporation Character Set Migration Best Practices
2003 9 : : Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. : : +1.650.506.7000 : +1.650.506.7200 www.oracle.com Oracle Copyright 2004 Oracle Corporation All rights reserved.