Display unicode chars.

[aks_1610]

Hi,

i want to create an application in which user can choose any language(eg. Japnese, chinese etc). Based on that selecting user cna get required information in that particular language. This information in kept in access database. I have made a sample database in which i have inserted data in these languages. But in am unable to retieve this data as i am only getting ? (question marks) instead of those chars.

ny idea(s)..

[a00]

what database r u using ?

[aks_1610]

MS Access

[aks_1610]

[randem]

aks_1610


I do not know how much you know about Unicode characters, so I will start with each Unicode character is two bytes in length. You can read UniCode characters from Access, but this depends on how you place the data into the database. Once read you will have to use the correct code page to get the characters.

[aks_1610]

thanks for replying,
i know that unicode character is two bytes in length. My database is storing correct data. But when i try to display it, the result is ???. I tried to save the recordset in XML format, there it is showing correct values, but when i try to display it, i get junk result. What i feel is there is some problem with the recordset.


ny idea(s)..

[randem]

aks_1610


Are you using the code page for Japanese or whatever language you used?