clear transaction log
>dump transaction master with truncate_only
>dump transaction master with no_log
character set
- the character set of server
exec sp_helpsort
- the character set of client
select @@client_csname
- all character set installed on the server
select * from syscharsets
- change character set(e.g. change character set to UTF-8)
1. install character set if not exesits in syscharsets;
CMD> C:sybaseASE-12_5incharset.exe -U[username] -P[password] binary.srt UTF8
2. Get the ID of the new character set;
Run SQL: select * from syscharsets, find the ID of UTF-8 in the result set;
3. set character set
sp_configure 'default character set id', ID
4. restart sybase server;