RelationalDBDesign 




Extended DB Features   «Prev  Next»
Lesson 1

Introduction to National Language Support and Oracle's mechanism for supporting national Languages

For much of the computing world, the standard language is English. However, many other languages are used throughout the world, and Oracle provides a mechanism to support many of them. This module will cover ways in which Oracle implements this support.
This module discusses
  1. How Oracle supports other languages
  2. How to use the NLS_LANG parameter
  3. How to use character sets
  4. How to specify national character sets
  5. How to convert between national language sets
With these skills in hand, you will be able to support virtually the entire world and its population, regardless of the languages your users can read.
In the next lesson, we will discuss how Oracle implements national language support.


National Language Support

Oracle does not have to use English characters; it can represent data in any language through its implementation of National Language Support and its NCHAR and NVARCHAR2 datatypes. By using characters made up of longer pieces of information than ordinary characters, Oracle can represent Japanese and other such strings. In addition to the SUBSTR function, Oracle supports SUBSTRB (using bytes instead of characters), SUBSTRC (using Unicode complete characters), SUBSTR2 (using UCS2 codepoints), and SUBSTR4 (using UCS4 codepoints).