Unicode support was introduced in Sybase version 12.5. A number of improvements to Unicode support were implemented in Sybase 12.5.1. For more on this, see http://www.sybase.com/detail?id=1026310
In order to use Unicode in your database, you need to
You should ask your Sybase DBA for both of these tasks.
In order to use Unicode literals in AQT, you need to specify that your Sybase client uses Unicode encoding. This done by setting the following environment variable:
This is done through the Windows Control Panel > Advanced > Environment Variables.
Unicode strings are held in columns with the following data types: unichar, univarchar.
The use of Unicode literals in your SQL statements is supported in Sybase 12.5.1, but not in Sybase 12.5.0. If you are running Sybase 12.5.0 you can use Unicode literals in your SQL by selecting Options > Unicode Options > For Sybase, use TO_UNICHAR for Unicode strings. When this is option is checked, AQT will scan all SQL being processed; if it finds any unicode string values, it will replace them with to_unichar functions.
if you run the following from the SQL window:
Select * from dbo.unicode_test where col1 ='ald'
AQT will actually run:
Select * from dbo.unicode_test where col1 = to_unichar(945) || to_unichar(955) || to_unichar(948)
This makes it very easy to use unicode literals in a Sybase 12.5.0 database.
These comments are for Sybase 12.5.0.