I have an application that merges a Unicode text file with an Access 2000 database, creating a Unicode text file. My Access database (and my Unicode text files) contain Chinese characters.
My problem is in getting the data out of my database directly into my VB application without losing the Chinese. I can read the rows/fields from the database, but all of my Chinese characters are converted to '?'.
However, I do import the database into my VB application into a DataGrid and the Chinese characters are displayed. So far my attempt to get data either from the DataGrid or from the database using ADODB.Recordset have resulted in the translation to question marks.