Re: Oracle use Big5 or Unicode and why?

From: Yong Huang <yong321_at_yahoo.com>
Date: 28 Apr 2003 14:24:07 -0700
Message-ID: <b3cb12d6.0304281324.506ee06@posting.google.com>

marcowcl_at_hotmail.com (Marco) wrote in message news:<56e6376d.0304280205.51a3004b_at_posting.google.com>...
> My company wants to use Oracle as the database to store Chinese. I am
> evaulating this product. Would you please advise why Oracle require
> Unicode as the code standard to store Chinese instead of Big5.

Why do you think it requires that?

SQL> select * from v$nls_valid_values where value like '%BIG5%' or value like 'UTF%' order by 2;

PARAMETER VALUE
--------------- ---------------
CHARACTERSET UTF8
CHARACTERSET UTFE
CHARACTERSET ZHT16BIG5
CHARACTERSET ZHT16BIG5FIXED You see. You have choices.

Yong Huang Received on Mon Apr 28 2003 - 16:24:07 CDT