キャラクタ・セットの移行に関するベスト・プラクティス

Size: px

Start display at page:

Download "キャラクタ・セットの移行に関するベスト・プラクティス"

るるみうなだ
4 years ago
Views:

1 2003 9

2 ... 3 Oracle Database 10g Unicode... 6 Unicode US7ASCII Export/Import CSALTER Export Import CSALTER Oracle Migration ) US7ASCII ) WE8ISO8859P1 WE8ISO8859P ) AL32UTF ) / Oracle Corporation Character Set Migration Best Practices

3 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 ASCII Oracle Corporation Character Set Migration Best Practices

4 Unicode Java World Wide Web ASCII C ~ 1252 Windows Windows Windows Oracle Database 4 Oracle Corporation Character Set Migration Best Practices

5 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

6 Unicode Unicode Unicode Unicode Unicode Unicode 1 Unicode Unicode Unicode Unicode Oracle Oracle Database 10g Unicode 10% SQL Unicode Unicode 1) Oracle Unicode 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

7 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 IT 1) 7 Oracle Corporation Character Set Migration Best Practices

8 2) 3) Database Character Set Scanner 4 A A A Oracle Database 10g CSALTER A A Oracle Corporation Character Set Migration Best Practices

9 Unicode 1 2 C WE8MSWIN WE8ISO8859P1 Latin 1 Database Character Set Scanner Scanner 30 Export Import VARCHAR (1) 1 1 Unicode UTF UTF-8 UTF-8 UTF UTF-8 3 English [ ] (1%) European [ä ß ñ] (10%) Export/Import 9 Oracle Corporation Character Set Migration Best Practices

10 A B B A B A B? ä a a 3 1) PASS-THRU PASS-THRU 2) 3) Database Character Set Scanner CHAR(1)UTF-8 10 Oracle Corporation Character Set Migration Best Practices

11 1 CHAR(4) Oracle9i UTF 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

12 NLS_LANG NLS_LANG A 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

13 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

14 7 1 2) 2 NLS_LANG NLS_LANG Oracle US7ASCII 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

15 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

16 Oracle Migration Oracle Migration Database Character Set Scanner 1 :2 UTF-8 ASCII Import 16 Oracle Corporation Character Set Migration Best Practices

17 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 WE8MSWIN WE8MSWIN WE8ISO8859P1 AL32UTF8 UTF-8 2 Export Import US7ASCII 2 WE8MSWIN1252 WE8ISO8859P1 UTF-8 17 Oracle Corporation Character Set Migration Best Practices

18 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

19 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

Oracle Database 10gのOracle Data Guard

Oracle Database 10gのOracle Data Guard Oracle Database 10g Oracle Data Guard 2004 Oracle Data Guard... 3... 3... 3 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 5 Oracle Data Guard... 6 Oracle Data