Oracle多语言支持

Yong Huang

If your database has a small amount of multi-byte characters (small like less than 1%), nchar and nvarchar2 work fine. But what about the future? Almost all businesses are going more global, instead of less so.

If you test the storage before and after going to AL32UTF8, please let us know your test result. Thanks.

By the way, I never like char (or nchar). The only advantage of it over varchar2 is you type 4 less characters ("char" has 4, "varchar2" has 8). Unless you know for sure the number of characters stored in it is fixed, such as 1 for the column sex (storing values 'M', 'F'), there's no point using char.

Jenifer90

Yong Huang 发表于 2016-11-30 01:26
If your database has a small amount of multi-byte characters (small like less than 1%), nchar and nv ...

Now our database character set is ZHS16GBK, if we do the migration and test the storage, I will send you an email to let your know.
Thanks.

alfah

utf8而已
理论上编码长度为1-6字节
实际一般1-4字节