The field type for NVARCHAR2 (30) types of
DUMP (addr, 1016), the return value is Typ=96 Len=6 CharacterSet=AL32UTF8:74,24,6 e, 61 d, 63
Use vba query the adodb library field
Dim cn As New ADODB. Connection
Dim the rs As New ADODB. You
Rs. Open the "select addr from the table," cn
Rs (" addr ") assigned to the cell, it shows the code: 2100 G? D? LL? , K? r? Si Csoma
But if I copy and paste directly into the cell from a toad can display properly, that is to say the excel is in support of these characters,
How to handle to make vba cell showed normal assignment?
CodePudding user response:
Font problem?A character encoding problem?
Control does not support Unicode problem?
For computer no noise, only the binary bytes; To the human brain is gibberish, GBK: 0 xb0 0 xa1, Unicode - 16 LE: 0 x4a 0 x55, Unicode - 16 BE: 0 x55 0 x4a, utf-8 8-0 x95 xE5 0 0 x8a
CodePudding user response:
Try under the German system of Windows,CodePudding user response:
Should be the problem of character set, field in oracle is UTF8 (CharacterSet=AL32UTF8), can have three bytes of characters, but the default just out here on the VB support unicode data, also does not support the VB6 string variable UTF8 (haven't this, 98), so the data after turn VB in UTF8 information lost, fill again to support in the application of UTF8 encoding has been wrong,