If you attempt to retrieve text values after changing to a multibyte character set, and you have not run dbcc fix_text, the command fails with this error message:
Adaptive Server is now running a multi-byte character set, and this TEXT column’s character counts have not been recalculated using this character set. Use dbcc fix_text before running this query again.
If you have changed the sort order or character set
and errors occurred, see “How to Manually Change Sort Order
or Default Character Set” in the Adaptive Server
Enterprise Troubleshooting and Error Messages Guide.
