I have set php-mysql-apache to work on latin1 but when doing back-ups my character-set client is still utf8

Yes, I know what you think, but for the moment we decided to go for latin1.

This is the mySQL config: • mysql> SHOW VARIABLES LIKE 'character_set_%';

• +--------------------------+--------+

• | Variable_name | Value |

• +--------------------------+--------+

• | character_set_client | latin1 |

• | character_set_connection | latin1 |

• | character_set_database | latin1 |

• | character_set_results | latin1 |

• | cha开发者_开发技巧racter_set_server | latin1 |

• | character_set_system | utf8 |> This is impossible to change since it is a default system parameter.

For php we use the following commands at php.ini:

mssql.charset = "ISO-8859-1"

For apache the usual:

AddDefaultCharset ISO-8859-1

With all this everytime we do back up we get the following added to each table:

/*!40101 SET @saved_cs_client = @@character_set_client /;

/!40101 SET character_set_client = utf8 */;

Why the character_set_client is still in utf8 for connections between apache/php and mysql?

---

mysqldump doesn't look at your php or apache settings. You'll need to add the --default-character-set flag when using mysqldump.

From the manual:

--default-character-set=charset_name

Use charset_name as the default character set. See Section 9.5, “Character Set Configuration”. If no character set is specified, mysqldump uses utf8, and earlier versions use latin1.

---

if you notice carefully the directive in the php.ini you have set:

mssql.charset = "ISO-8859-1"

refers to Microsoft SQL Server! connections and not to MySQL Server.

jackman