MDB files and unicode
-
hi there I used access2000 to create my database, and it has some field(text,memo...) that contains other languages, when i connect to database with ado (in vb or vc) it fills "?" mark instead of any character . I can't understand what is my problem!!!!!
-
hi there I used access2000 to create my database, and it has some field(text,memo...) that contains other languages, when i connect to database with ado (in vb or vc) it fills "?" mark instead of any character . I can't understand what is my problem!!!!!
Unicode is used in MS apps now by default (at least I think thats true of all of them). So, provided your Windows language extentions are present displaying other languages in Word/Excell/Access is automatic, except in code. Different functions are used for Unicode in some situations, for example Chr( charcode ) char code is actually a 'long' rather than a 'byte' or 'short' as you might expect. But Chr will only work within the normal ASCII range. ChrW function returns a String containing the Unicode character except on platforms where Unicode is not supported, in which case, the behavior is identical to the Chr function. See StrConv functions for help with unicode within your code. Also remember that if you have written a string to a field through your code, you will of needed to treat it as Unicode. As I said much of this is done for you, but you have to be aware of functions that do not handle Wide character formats. We do it for the joy of seeing the users struggle.