disable Unicode mode in VB6
399766Jan 19 2004 — edited Feb 2 2004My 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.