Skip to Content
0
Jan 23, 2023 at 12:23 PM

ASE 16 - install additional character set utf8

315 Views

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