I think you need to use NVARCHAR2(100) ........ but I could be totally wrong
here ... I would suggest reading
up on NVARCHAR2, NCHAR etc
"SG" <sajnish_gupta_at_yahoo.com> wrote in message
news:3bf2904e$0$18076$724ebb72_at_reader2.ash.ops.us.uu.net...
> We have some customer in America and some in Japan, running the databases
in
> UTF8 characterset. The schema creation script for English customers looks
> like:
>
> TABLE_ENGLISH
> COL_1 VARCHAR2(100)
> COL_2 NUMBER
>
> My question is, how will the script change (if it does) for Japanese
> customers. The Japanese customers enter both English and Kanji characters
> into the database. Do I have to increase the VARCHAR2 field 3 X ?
>
>
> TABLE_JAPANESE
> COL_1 VARCHAR2(300)
> COL_2 NUMBER
>
> thanks for your help
> SG
>
>
>
Received on Sun Nov 25 2001 - 08:34:53 CST
