Storing Unicode character in Oracle 
Author Message
 Storing Unicode character in Oracle


I have to store different Asian character sets (Japanese, Chinese, etc)
into the same database. I learnt that the NLS_CHARACTER_SET for the
database has to be set up as UTF-8. Each column size definition like
CHAR(n) means n bytes instead of n characters.

Is there really no UCS-2 supported by Oracle?
Do I have to change each column definition from CHAR(n) to CHAR(3*n)
where n is the number of characters?
Does this mean one column can store 30 European character but only 10
Asian Character.

Thanks for your help,

Sent via http://www.***.com/
Before you buy.

Wed, 18 Jun 1902 08:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Unicode import with apparently mixed ANSI and Unicode characters

2. Unicode characters in Stored Procedure

3. Using ADO to access a national character set=Unicode Oracle 8 database

4. UNICODE character set on Oracle 7.3

5. Unicode characters in Oracle 7.3.4

6. Inserting unicode character into Oracle

7. Help with converting Windows Unicode (UCS-2) to Oracle Unicode (UTF-8) via ADO

8. Help with converting Windows Unicode (UCS-2) to Oracle Unicode (UTF-8) via ADO

9. Storing Unicode(chinese) in Oracle using JDBC

10. VB - Unicode and Oracle Stored Procedures........Help

11. storing unicode data in Oracle

12. How to store Unicode data in personal Oracle

Powered by phpBB® Forum Software