chinese/japanese Language support

[sojankurian]

1. I have IDS 9.3 under sun solaris 8. On unix i set
the env. variable DB_LOCALE & CLIENT_LOCALE to
en_us.utf8. Then i created my database & tables.
I use winsql (third party tool) to insert data from
windows. I can insert data in all languages. Except
for chinese / japanese where they are stored as junk(sort of hexa chars).
Also since they are multi-byte i can store only 3 or 4
chars. One eg. would be i got a column with size 20
chars. I can insert 20 eng chars. When i try to
insert chinese or japanese data i can insert only 3-4
chars, the rest gets truncated.

2 Does the actual data in japanese/chinese language
get inserted in the database, in my DB they are stored
in a different format. how can i view them through
dbaccess, i can view french, german data thru
dbaccess.

In order to view japanese data i do a select from by
database copy the contents to a notepad and save the
file as html in utf8 format. Then i open the file in
Internet explorer, this way i can see the data. But
not in dbaccess

3. Will the current width be enough to hold the data
in japanese/chinese languages, for eg. i have a name
column which stores 20 chars, so when i have to store
japanese data will it be able to hold 20 chars or i
will have to increase the size of my column.
3. How do i do sorting on a column which has data
inserted in many languages, for eg.i have rows in
french, spanish, japanese & chinese. How do i select
sorting fora particular language, is there an env.
variable for it.

regards
sojan