Hello! A customer of ours has a problem with retrieving UCS data from Microsoft's SQL Server 2000 using ADO.
The data is stored correctly in the database. In trying to reproduce his problem, I jotted down a minimal Python script to retrieve the data -- and, indeed, no problem whatsoever to retrieve the data using ADO over COM from Python 2.2. Everything as expected, given that COM is based on Unicode. However, transposing the minimal script to Visual Basic 6, our customer's programming language, I experience the same issue that he gets, namely that VB converts the data to CP 1252. Some characters simply get converted to what VB obviously considers a standard fall-back (e.g. C with caron is returned as a C), others, e.g. Cyrillic letters, are returned as question marks. Since I normally use other programming languages, I don't know how to instruct VB to refrain from applying any conversions. Any ideas anybody? Thanks in advance, Marc
