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.