Retrieving text values after changing character sets

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.