Development

#3017 (Creole fail to set up the Mysqli Connection charset encoding [WITH)

You must first sign up to be able to contribute.

Ticket #3017 (closed defect: fixed)

Opened 5 months ago

Last modified 4 weeks ago

Creole fail to set up the Mysqli Connection charset encoding [WITH

Reported by: jug Assigned to: fabien
Priority: major Milestone: 1.0.17
Component: other Version: 1.0.11
Keywords: lib vendor Creole MySQLIConnection.php Cc:
Qualification: Design decision

Description

While using this of database dns in both propel.ini and database.yml : 

mysqli://user:pwd@host/dbnamer?encoding=UTF8

Connection to mysql server isn't set with UTF-8 encoding... But stay at the default charset (configured somewhere in my.conf I guess)

Here is the way to fix it :

File : %sf_symfony_lib_dir%/lib/vendor/creole/drivers/mysqli/MySQLIConnection.php

Line : 118

Replace : $this->executeUpdate("SET NAMES " . $encoding);

By : $this->dblink->set_charset( $encoding );

Sincerely,

Change History

05/07/08 08:55:15 changed by FabianLange

  • qualification changed from Unreviewed to Design decision.

confirmed. Ill report this to creole bugtracker. fabien, do we fix this ourselves?

05/08/08 08:50:16 changed by FabianLange

opened ticket on creole trac, will be addressed in 1.2 http://creole.phpdb.org/trac/ticket/86

05/28/08 15:13:26 changed by FabianLange

this has been fixed upstream.

06/23/08 03:01:16 changed by dwhittle

  • milestone set to 1.0.17.

We should upgrade to latest creole / propel stable version and this is resolved.

06/24/08 13:07:25 changed by FabianLange

  • status changed from new to closed.
  • resolution set to fixed.

(In [9829]) 1.0: backported encoding fix for MySQLiConnection from creole trac. fixes #3017

06/24/08 13:08:26 changed by FabianLange

(In [9830]) 1.1: backported encoding fix for MySQLiConnection from creole trac. refs #3017