Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access XP: Can not get unicode string from recordset

Posted on 2004-09-15
3
Medium Priority
?
491 Views
Last Modified: 2008-02-26
I have a table with chineese names. I have chineese fonts installed and I can see chineese names when opening table from the database window.
When I open recordset on this table, in debug window I see all chineese names like "???".
If I save the recordset field in file using Put statement, I see the same question marks in the file.
I tried DAO recordset and ADO recordset with same result.
0
Comment
Question by:shvetsov
3 Comments
 
LVL 51

Accepted Solution

by:
Steve Bink earned 500 total points
ID: 12065369
Please see this link for the official Microsoft explanation:

http://support.microsoft.com/default.aspx?scid=kb;en-us;145727

It basically tells you that while Access handles unicode just fine, VB assumes all strings are ANSI.  Accordingly, any unicode strings that are handled by VB are either a) converted to ANSI, or b) assumed to be ANSI.

This link provides information on how to export a table from Access with the unicode intact.  Good luck to you!

http://support.microsoft.com/default.aspx?scid=kb;en-us;234201
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question