Problem with VB reading Chinese/Korean International Language
Posted on 2003-10-29
I have read about Internationalization and need some help. I developed a client/server application in VB6. The application handles customer registration and a queston/answer survey. The label captions for the form and the questions and answers for the survey are all stored in an Access (Office XP) database. The original application was developed for English and Spanish and since both languages are Western Latin characters, there was no problem with the language difference. However, now the client wants the application to work in China and Korea. I have read several Q/A in experts-exchange as well as MSDN regarding working with Internationalization. I have added the Traditional Chinese, Simplified Chinese and Korean in the Control Panel/Regional and Languages Settings and installed the languages in MS Office. Now the problem I have is VB will not read the language. Like I have mentioned, the data is stored in the MS Access and the language is read and maintained in the database, but when I try to extract the data from the database, it either returns ???? or characters which do not closely resemble the Chinese characters in the database. I have tried using a resource file, but get the same issue when pasting the data into the resource file. I have even tried hard coding the data in the app, but again getting the same results. I do not have a Chinese character keyboard, but do have the text saved in the database. Any help you can provide to assisting me getting through this would be greatly appreciated.