Printable View
Hi All
I'm basically a Java developer. I'm running English version of Windows OS. I ahve to fetch Japanese data from the DB. This data appears as ? when i fetch using VBA. I'm now forced to convert each literal into its ASCII eq . Is there any way out?
Jhakda
You mean the data appears as ? when looking at it in break mode? I would think that would have to do with the font that the IDE uses not supporting the characters you want to look at. I'm not 100% on how vba handles unicode and kanji. Good luck.
Hi
When i run the code in debug mode, i check what data i'm getting. It shows as ?. If i pass it as it is, i inserts ? in the DB. Thats where the problem lies.
I read somewhere that VBA doesn't support unicode by default. We need some add ons which MS doesn't supply, need to get from third party (its paid service (:). Thats why i'm forced to convert to unicode myseld. But its a slow process.
Thanks
Jhakda