PHP: Converting UTF-8 string to Ansi?

Question

I build a csv string from values I have in my DB. The final string is stored in my $csv variable.

Now I offer this string for download, like this:

header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=whatever.csv");
header("Pragma: no-cache");
header("Expires: 0");

echo $csv;

When I open this in Notepad++ for example, it says Ansi as UTF-8. How can I chnage that to Ansi only?

I tried:

$csv = iconv("ISO-8859-1", "WINDOWS-1252", $csv);

That did not change anything.

Thanks!

Solution: $csv = iconv("UTF-8", "WINDOWS-1252", $csv);

Elephant

possible duplicate of What is "ANSI as UTF-8" and how can I make fputcsv() generate UTF-8 w/BOM? – Tenancy

Look at the mbstring section of the PHP manual – Am

The source data is UTF-8 but you are converting from ISO-8859-1! – Hoofbound

@Álvaro G. Vicario: Yeah, thats the solution :D – Elephant

@Elephant - The proper way to provide a solution is the "Your Answer" text box. Fab already did so. – Hoofbound

Sorry for the late accept ... – Elephant

Answer 1

Try:

$csv = iconv("UTF-8", "Windows-1252", $csv);

But you will eventually lose data because ANSI can only encode a small subset of UTF-8. If you don't have a very strong reason against it, serve your files UTF-8 encoded.

Latea

microsoft is that reason. as always. – Explanation

Answer 2

Since there is a misunderstanding about ISO-8859-1, Windows-1252 & ANSI in your question an important thing to note here is that:

The so-called Windows character set (WinLatin1, or Windows code page 1252, to be exact) uses some of those positions for printable characters. Thus, the Windows character set is NOT identical with ISO 8859-1. The Windows character set is often called "ANSI character set", but this is SERIOUSLY MISLEADING. It has NOT been approved by ANSI.

Historical background: Microsoft based the design of the set on a draft for an ANSI standard. A glossary by Microsoft explicitly admits this.

Some more resources: here and here.

So just FYI for other people that end up in this question.

Here's MS's exact explanation on this:

The term “ANSI” as used to signify Windows code pages is a historical reference, but is nowadays a misnomer that continues to persist in the Windows community. The source of this comes from the fact that the Windows code page 1252 was originally based on an ANSI draft—which became International Organization for Standardization (ISO) Standard 8859-1. “ANSI applications” are usually a reference to non-Unicode or code page–based applications.

Oxyacetylene

Answer 3

To avoid data loss when converting special characters:

setlocale(LC_CTYPE, "fr_FR.UTF-8"); //set your own locale
$csv = iconv("UTF-8", "WINDOWS-1252//TRANSLIT//IGNORE", $csv);

Deloisedelong