Detecting Codepage

[Guus2005]

I need to import a text file and instead of Günther it shows G?nther. (this is just an example)
Opening the file in Ultraedit the hexadecimal value is 90.

I usually work with UTF-8 and also Windows 1252 doesn't give me any problems.

What i want to see is the name G?nther shown in every possible codepage.
Is that even possible?

Thanks!

 

[strive4peace]

hi Guus2005,

VBA can't show the extended characters. The way to get them in is to use the ChrW function. Chr is for regular ASCII. ChrW is Wide ASCII.

ü = ChrW (252)

Fields CAN store and show the characters, just not VBA or the debug window. If you want to read or write a text file with Unicode, use an ADO Stream

 

[strive4peace]

ps, Guus (is that your name?)

I looked that up by pasting ü into the upper left textbox on my Unicode CharMap form, which also displays whatever character you click on and shows you the decimal code, which the ChrW function uses.

You can download this tool here:

Unicode Character Map
http://msaccessgurus.com/tool/UnicodeCharMap.htm