background image

<< Contents 3 | Contents 5 >>

<< Contents 3 | Contents 5 >>

Contents 4

vi

6 Working in a Global Environment

Overview of Globalization

..................................................................................................................... 6-1

Globalization Support Features ....................................................................................................... 6-2
Viewing the Current NLS Parameter Values ................................................................................. 6-2

Using NLS Parameter Values in the SQL Developer Environment

............................................... 6-4

Changing NLS Parameter Values for All Sessions........................................................................ 6-6

Establishing a Globalization Support Environment

......................................................................... 6-7

Choosing a Locale with the NLS_LANG Parameter..................................................................... 6-8
Setting NLS Parameters..................................................................................................................... 6-8
Setting Language and Territory Parameters .................................................................................. 6-9

Using the NLS_LANGUAGE Parameter................................................................................. 6-9
Using the NLS_TERRITORY Parameter............................................................................... 6-10

Setting Date and Time Parameters ............................................................................................... 6-12

Using Date Formats ................................................................................................................. 6-12
Using Time Formats ................................................................................................................ 6-14

Setting Calendar Definitions ......................................................................................................... 6-15

Overview of Calendar Formats.............................................................................................. 6-15
Using the NLS_CALENDAR Parameter .............................................................................. 6-16

Using Numeric Formats ................................................................................................................. 6-17

Using the NLS_NUMERIC_CHARACTERS Parameter .................................................... 6-18

Using Monetary Parameters .......................................................................................................... 6-19

Overview of Currency Formats ............................................................................................. 6-19
Using the NLS_CURRENCY Parameter............................................................................... 6-19
Using the NLS_ISO_CURRENCY Parameter ...................................................................... 6-20
Using the NLS_DUAL_CURRENCY Parameter ................................................................. 6-21

Using Linguistic Sort and Search.................................................................................................. 6-22

Using the NLS_SORT Parameter ........................................................................................... 6-22
Using the NLS_COMP Parameter ......................................................................................... 6-23
Using Case-Insensitive and Accent-Insensitive Search ...................................................... 6-25

Using Length Semantics................................................................................................................. 6-25

Using the NLS_LENGTH_SEMANTICS Parameter........................................................... 6-26

Developing Globalized Applications

............................................................................................... 6-27

Overview of Unicode...................................................................................................................... 6-27
Using SQL Character Data Types ................................................................................................. 6-28

Using the NCHAR Data Type................................................................................................ 6-28
Using the NVARCHAR2 Data Type ..................................................................................... 6-29

Using Unicode String Literals ....................................................................................................... 6-29
NCHAR Literal Replacement ........................................................................................................ 6-30

Using Locale-Dependent Functions with NLS Parameters

........................................................... 6-30

Specifying NLS Parameters in SQL Functions............................................................................ 6-31
Unacceptable NLS Parameters in SQL Functions ...................................................................... 6-33

7 Deploying a Database Application

Overview of Deployment

....................................................................................................................... 7-1

Deployment Environments

.................................................................................................................... 7-1

Planning for Deployment

....................................................................................................................... 7-2

Exporting the Database Objects

............................................................................................................ 7-3