Limitations

Due to the lack of a Unicode-based language parser in Adaptive Server 12.5, a restriction was imposed on the use of the new Unicode datatypes. To use the new datatypes, the server required its default character set to be configured as UTF-8. This restriction has been removed in Adaptive Server version 12.5.1. Unicode datatypes can be used regardless of the server’s default character set.

There is presently no implementation of the datatype unitext, the analog of the text datatype. With the relaxation of the stringent 255-byte column width (a feature of Adaptive Server 12.5), the need for a large Unicode datatype is somewhat reduced. The unitext datatype may be implemented in a future version of Adaptive Server. In the meantime, a temporary workaround is possible. With suitable care, the image datatype may be used to store large blocks of Unicode data.