Re: Charset SESSION vs GLOBAL

[Cédric Michel]

-------------------------------------------------------
Have you considered switching to mysqli_* (instead of mysql_*) API in PHP? It may have the issues solved.
-------------------------------------------------------

Not for old sites... as I said, "On recent projects, we use SET NAMES (latin1 or utf8) and it works fine."

For old projects, we've got the problem because of the connection: utf8 instead of latin1. If we had to work on these, i would just have to add SET NAMES latin1 (tested) to solve the problem.

So I just try to understand WHY... why the connection is in UTF8 instead of latin1 (cf. my.cnf, php.ini). It is more for my personal knowledge than for a real need.

And thank you for the link! I have not yet taken time to read everything, but that seems very interesting.