Informix GLS Queries...
Posted in 2004
Dear All,
I have created my database setting both DB & CLIENT Locales to utf8. I have a
few queries on it -
1. Does the actual data in japanese/chinese language get inserted in the
database, how can i view them through dbaccess
2. 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.
Please advice. Thanks in advance.
Best Regards,
Lloyd