Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Whats difference between Character set and National Character set 1
- Thread starter parbhani
- Start date
-
1
- #2
You can have two character sets per database. The first one supports your normal data types like CHAR, VARCHAR2, and CLOB. The second one supports globalized datatypes like NCHAR, NVARCHAR2, NCLOB.
Many databases have one character set such as WE8ISO8859P1 for both. Does not make sense to me, but I guess if you don't use the N data types it doesn't matter.
I have heard the N data types were originally implemented by Oracle (ten years ago?) to satisfy a requirement from a collection of Japanese companies. Japan was the only country at that time with a multi-byte character set who wanted to buy a large quantity of licenses, so Oracle implemented a solution just for them. Over time it was enhanced to support everyone. Not sure if true, but sounds interesting.
Cheers,
9i OCP
Many databases have one character set such as WE8ISO8859P1 for both. Does not make sense to me, but I guess if you don't use the N data types it doesn't matter.
I have heard the N data types were originally implemented by Oracle (ten years ago?) to satisfy a requirement from a collection of Japanese companies. Japan was the only country at that time with a multi-byte character set who wanted to buy a large quantity of licenses, so Oracle implemented a solution just for them. Over time it was enhanced to support everyone. Not sure if true, but sounds interesting.
Cheers,
9i OCP
- Status
Similar threads
- Locked
- Question
- Locked
- Question