• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

Access XP: Can not get unicode string from recordset

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.
1 Solution
Steve BinkCommented:
Please see this link for the official Microsoft explanation:


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!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now