UTF Unicode (Urdu language Database)

[manzerehsan]

hi
i am new user.
i download urdu keyboard from web. that keyboard name is "Phonatic" for Windows XP. With the help of that keyboad we will type urdu in Word Excel.

i am facing problem,that there is a database in excel (urdu),

i copy data into notepad, and save as Encoding =UTF-8.
then Interst Richtext box in vb6 exe application, load txt file into it. every thing is ok. file open and show all data correctly

then i copy all the data (including urdu fileds) into Access, the urdu filed looks fine in MS Access.

But when i try to read that data through Recordset or processing throgh VB normal string functions i did not get proper results, when ever i try to read the data i find ? ? ? ? instead of data.

Please any one now how to read utf data through recordset or any way to process in vb6.

Regards
Manzer