Re: Oracle use Big5 or Unicode and why?

From: John Luongs <johnluongs_at_hotmail.com>
Date: Thu, 01 May 2003 21:26:48 +0800
Message-ID: <3EB12098.5E4AEA09@hotmail.com>

What're pros and cons? Thanks.

Yong Huang wrote:

> 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 Thu May 01 2003 - 08:26:48 CDT