Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

disable Unicode mode in VB6

399766Jan 19 2004 — edited Feb 2 2004
My Database characterset is AL32UTF8. In VB6, I have to use controls with some Vietnames fonts to display text. When I use MS Provider for Oracle, because it doesn't support Unicode, so if I set NLS_LANG to VN8VN3, the conversion always happens and I can happily do things like:
Text1.Font="Some Vietnamese Font"
Text1.Text= rs1.Fields("Name").Value
When I move on to OraOLEDB (to use LOB and advanced things Oracle provides), I found out that it will use Unicode mode in my case (because VN8VN3 is not a superset of AL32UTF8), so the rs1.Fields("Name").Value is encoded in UCS16 and I can't get it displayed in text boxes.
I found that I can use Oracle ODBC driver through MS Provider for ODBC, and unset "Force SQL_WCHAR for Varchar2 columnms" , but it seems to have some limits.
Any one can help me out?
Thank you very much.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2004
Added on Jan 19 2004
1 comment
1,230 views