文档介绍:2 Copyright ? 2004, Oracle. All rights reserved. Using Globalization Support 2-2 Copyright ? 2004, Oracle. All rights reserved. Objectives pleting this lesson, you should be able to: ? Customize language-dependent behavior for the database and individual sessions ? Specify different linguistic sorts for queries ? Retrieve data that matches a search string ignoring case or accent differences ? Obtain Globalization support configuration information 2-3 Copyright ? 2004, Oracle. All rights reserved. Globalization Support Features ? Language support ? Territory support ? Character set support ? Linguistic sorting ? Message support ? Date and time formats ? Numeric formats ? ary formats 2-4 Copyright ? 2004, Oracle. All rights reserved. Encoding Schemes Oracle Database supports different classes of character encoding schemes: ? Single-byte character sets – 7-bit – 8-bit ? Fixed-width multibyte character sets ? Varying-width multibyte character sets ? Universal character sets, such as Unicode 2-5 Copyright ? 2004, Oracle. All rights reserved. 2-6 Copyright ? 2004, Oracle. All rights reserved. 2-7 Copyright ? 2004, Oracle. All rights reserved. Database Character Sets and National Character Sets Can store Unicode using either AL16UTF16 or UTF8 Can store varying-width character sets Store data columns of type NCHAR , NVARCHAR2 , NCLOB Store data columns of type CHAR , VARCHAR2 , CLOB , LONG Can be exchanged Cannot be changed without re-creation, few exceptions Defined at creation time Defined at creation time National Character Sets Database Character Sets 2-8 Copyright ? 2004, Oracle. All rights reserved. Database Character Sets and National Character Sets 2-9 Copyright ? 2004, Oracle. All rights reserved. Datetimes with Timezones TIMESTAMP '2004-01-31 09:26: +02:00' Valid value in V$TIMEZONE_NAMES TIMEZONE_REGION 00 to 59 TIMEZONE_MINUTE -12 to 14 TIMEZONE_HOUR 00 to (N) -- N indicates precision SECOND 00 to 59 MINU