Using OEM characters in tables using Advantage OLE DB

Connection string

This Advantage OLE DB Provider connection string can be used for connections to Sybase Advantage.

Provider=Advantage OLE DB Provider;User ID=adssys;
Data Source
=MyDataDictionaryPath;
Advantage Server Type=ADS_REMOTE_SERVER;
CharType
=ADS_OEM;

If not specifying the CharType value the default value of "ADS_ANSI" will be used.