Friday, July 15, 2011

[SYBASE] ASE 12.5 with UTF-8

This PDF describes to setup your ASE 12.5 with a default UTF-8 charset: http://www.sybase.com/content/1026310/unicode_support_wp.pdf

To fix the "text" fields check out this page: http://manuals.sybase.com/onlinebooks/group-asarc/srv10024/sag/@Generic__BookTextView/49306;pt=49154

Quote:

Changing to a multibyte character set makes the internal management of text data more complicated. Since a text value can be large enough to cover several pages, SQL Server must be able to handle characters that may span across page boundaries. To do so, the server requires additional information on each of the text pages.
To see the names of all tables that contain text data, use this query:
select sysobjects.name
from sysobjects, syscolumns
where syscolumns.type = 35
and sysobjects.id = syscolumns.id
The System Administrator or table owner must run dbcc fix_text to calculate the new values needed.