Dear all,
            I have selected a unicode string from database. In SQL
server query analyzer, I can see
the field descripion is VARISTOR® where circle R is unicode. But when
I type the recordset value in VB  like ? RST("description"), it
becomes VARISTORR where the circle R is replaced by
R. How to solved that. I want to keep the original unicode data to
show in VB. How can I do that?

Thanks

Hi Peter,

It might just be VB6's output window. Most of VB6 Ui stuff is ANSI, you have
to go 3rd party to try to get unicode.
Make sure the string is still unicode, by checking the ASCW value of the
relevant part, eg
For i = 1 To Len(s)
  Debug.Print Hex(AscW(Mid(s, i, 1)))
Next i







            I have selected a unicode string from database. In SQL
server query analyzer, I can see
the field descripion is VARISTOR® where circle R is unicode. But when
I type the recordset value in VB  like ? RST("description"), it
becomes VARISTORR where the circle R is replaced by
R. How to solved that. I want to keep the original unicode data to
show in VB. How can I do that?

Thanks

Help with a bit of maths
OT: The bloated get bloatier
MBF to IEEE (Beg. Q)
Create Icon File From Resource
Changing a property on a control
Toolbar Dilema
How do I stop opportunistic record locking from causing massive de
calling (and deleting) a string from an unmanaged dll
Vista and AutoRedraw
Phone system integrated in vb app