[Lazarus] Windows and german Umlauts: why do i have to PWideChar(UTF8Decode(String)) and not UTF8ToAnsi(String)

Jürgen Hestermann juergen.hestermann at gmx.de
Tue Oct 18 11:51:11 CEST 2016


Am 2016-10-18 um 11:31 schrieb Mattias Gaertner via Lazarus:
 > Did you start the csv file with the UTF8 BOM, so that Excel knows that
 > the file is UTF-8 encoded?
 > UTF8BOM = #$EF#$BB#$BF

In

https://en.wikipedia.org/wiki/Comma-separated_values

it says:

"Also, many regional versions of Excel will not be able to deal with Unicode in CSV."

and

"One simple solution when encountering such difficulties
is to change the filename extension from .csv to .txt;
then opening the file from an already running Excel instance
with the "Open" command, where the user can manually specify
the delimiters, encoding, format of columns, etc."



More information about the Lazarus mailing list