Non-Latin Thai Characters

[markbrum]

Hi,

I have an Access DB which contains some names which are written in Thai non-latin characters. When I open the table in Access it looks OK. When I either output it as a text file or try to link to MS Word as a mail merge the non-latin characters are replaced by question marks. I've tried changing text encoding on a CSV after output but I can't get the characters back. Is there a setting in Access I can change to output these characters correctly.

Thanks for looking.

Best regards,
Mark.

 

[MakeItSo]

Hi Mark,

what encoding have you tried? Access works with Unicode internally, so Thai should not be a problem. Exporting into UTF-8 encoded TXT or CSV should work nicely.

Be advised however, that if you wish to open this e.g. in Excel, Excel will by nature assume CSV to be ASCII encoded. You then have to open via "Data->Import external data" and specify the encoding of the CSV during import.

Does that solve it?
;-)

Cheers,
MakeItSo

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell