How does Oracle support unicode text?
-
From what I read, you need to encode the unicode text in UTF8 format and then save it into a regular CHAR or VARCHAR field, and you need to decode the UTF8 text when you want to use the data later (like, convert it to UTF16 format). Is that true? Is there a NCHAR or NVARCHAR type in Oracle that corresponds to the same type in SQL Server? Thanks.[
My articles and software tools
-
From what I read, you need to encode the unicode text in UTF8 format and then save it into a regular CHAR or VARCHAR field, and you need to decode the UTF8 text when you want to use the data later (like, convert it to UTF16 format). Is that true? Is there a NCHAR or NVARCHAR type in Oracle that corresponds to the same type in SQL Server? Thanks.[
My articles and software tools
There are unicode types in Oracle, nchar and nvarchar2 are there. You should create database with a unicode - characterset (i.e. AL32UTF8) for better performance and sorting. see also http://www.oracle.com/technology/tech/globalization/index.html
-
There are unicode types in Oracle, nchar and nvarchar2 are there. You should create database with a unicode - characterset (i.e. AL32UTF8) for better performance and sorting. see also http://www.oracle.com/technology/tech/globalization/index.html
Thanks. Is the nchar or nvarchar2 type 16 bit characters?[
My articles and software tools