Arabic Data from SQL Server 2008

Hi
I am using an application developed in VB6 , back end is SQL Server 2008.
I need to pull the data stored in Arabic in sql table and display in VB text box, I tried both text box and rich text box but result is same,
if data is saved in arabic language in sql table in vb record set it appear as ???????, and if i save it in machine language from VB using N' it appears correct in VB but at table level it is saved as garbage.
can anyone help me out to get data as it is in VB rich text box as saved in arabic language in sql table

thanks & regards,
Imran

You need controls which are capable of showing and/or inputting unicode text.

Have a look at this project by Krool:
http://www.vbforums.com/showthread.p...mmon-controls)

Or this project by DrUnicode:
http://www.cyberactivex.com/UniSuiteFree.htm

You can use an InkEdit control.

This is a Unicode-aware wrapper around the Win32 RichEdit control. For a purpose like this you can use it in "inkless" mode by assigning .InkMode = IEM_Disabled if you don't want pen input and handwriting recognition.

InkEdit has been included as part of Windows since Windows Vista.