Database connector don't use charset of the app

[laurentj]

The charset used in database connection is the one indicated in the client configuration (mysql configuration for example), and not the one indicated in a jelix application configuration. So datas returned by a query may be not in the correct charset.

For mysql for example, a query like "SET CHARACTER SET 'utf8'" should be executed after the connection.

The problem appears with mysql driver, pdo and probably postgresql driver.

[sylvain261]

Dans la doc Mysql on a :
A SET NAMES 'x' statement is equivalent to these three statements:
SET character_set_client = x;
SET character_set_results = x;
SET character_set_connection = x;

Setting character_set_connection to x also sets collation_connection to the default collation for x.

SET CHARACTER SET is similar to SET NAMES but sets the connection character set and collation to be those of the default database. A SET CHARACTER SET x statement is equivalent to these three statements:
SET character_set_client = x;
SET character_set_results = x;
SET collation_connection = @@collation_database;


Pour faire propre et ne pas dépendre la la collation de la base par défaut de mysql il convient donc de faire un SET NAMES et non pas un SET CHARACTER SET. J'attache le patch correspondant de ce pas.

[sylvain261]

SET NAMES à la place de SET CHARACTER SET

[laurentj]

à commiter sur le trunk et la branche 1.0.x.

La prochaine fois, créer un nouveau ticket, et ne réouvre pas comme ça de vieux tickets, qui n'ont finalement pas grand chose à voir. (je ne réouvre pas le ticket sur la creation de jforms à chaque fois que je vais faire une évolution ou une correction sur jforms).

[laurentj]

landed in the trunk.