UTF-8 read and write back to Oracle DB from VB application corrupts the data[if-non-english char] to unreadable format
-
I have Oracle DB Table with one of its column (VARCHAR). I read and write to this data [non-english or English] using VC application then everything works fine. But if I use a VB application to read the data[non-english] and write it back to the same palce the content is corrupted. Any help is appreciated
-
I have Oracle DB Table with one of its column (VARCHAR). I read and write to this data [non-english or English] using VC application then everything works fine. But if I use a VB application to read the data[non-english] and write it back to the same palce the content is corrupted. Any help is appreciated
The problem is solved. It was due to the difference in the way, the Unicode characters are handled by "Oracle Provider for OLE DB" (OraOLEDB.DLL) and "Microsoft OLE DB Provider for Oracle" (msdaora.dll). Refer : http://support.microsoft.com/kb/q244661/ My vb application was using msdaora.dll while VC++ was using OraOledb.dll ! Suhredayan