Cannot get a multi-byte character from database ta
I am using the MS ODBC for Oracle driver to connect to an Oracle database.
I have a SQL statement that gets a single multi-byte Chinese character from the DB table.
The Chinese character is 3 bytes.
After creating the connection, I do this:
Set rs = oConn.Execute(sql)
Environment("V1") = rs.Fields(0).Value
I am expecting the value to be this: &#21608; (pretend this is a Chinese char)
Instead I get this: ¿
Does anyone know how to properly get a multi-byte character from a database?
P.S. I attached a file which may display the chinese char.
Re: Cannot get a multi-byte character from database ta
Looks like the attachment did not make it ... sorry.