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
Re: Arabic Data from SQL Server 2008
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
Re: Arabic Data from SQL Server 2008
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.