Senin, 05 Desember 2016

[MS_AccessPros] Re: filename changes when imported into msaccess

 

Hi Onno (or is it Knol?)


You are correct, it has something to do with codepages and charactersets, and Unicode...

What you are seeing is the fact that although Windows is (mostly) Unicode aware and Access is (mostly) Unicode aware, there are some, quite a few actually, "got ya"s involved.

The situation was worse in Visual Basic, Access and VBA are better. VBA does support unicode strings, however, the VBA editor only allows VBA files to be encoded in the 8-bit codepage Windows-1252.

If you are lucky the only thing that will be wrong is that when you display the variable contents is that the font being used won't display the extended characters properly and you end up seeing a '?' for each character which the (non-unicode parts) cannot convert.

Depending on how you picked up the filename from the filesystem, the variable *should* hold the correct characters, even if the display on screen looks wrong.

Yours, Andrew

__._,_.___

Posted by: yahoo@craven.de
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar