Hi
We are running ASE 16.0 on Solaris with character set iso_1. We need to add
a new column to one of the existing table to store name in Chinese characters.
We don't need to change the datatype of any of the existing columns in the database.
can we get the things done by just performing the following tasks ?
1. Install UTF-8 as additional character set.
charset -Usa -P binary.srt utf8
2. Make UTF-8 as default character set
sp_configure 'default character set id',190
restart ASE
3. alter table customer add cname univarchar(255) null
Do we still need to bcp out/in all the existing tables after making
utf8 as default character set for the database server in order to avoid any data
corruption? Please help.
thanks
chan