0004479: mysql connection collation is not honored (wordpress)

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0004479

[Quercus]

major

always

04-05-11 11:17

04-07-11 02:53

Reporter

chiefgeek

View Status

public

Assigned To

Priority

normal

Resolution

open

Platform

Status

new

Projection

none

OS Version

ETA

none

Fixed in Version

Product Version

4.0.7

Product Build

Summary

0004479: mysql connection collation is not honored (wordpress)

Description

I have a db with tables that were created with utf8 as default and data populated as utf8 character set. When viewing the data from the db via quercus the data is corrupt.

I have added a set names utf8 after the mysql_connect call and it appears to have no affect.

I have tried adding '?characterEncoding=utf8' on the jdbc url but the startup fails when that option is in place.

Steps To Reproduce

Additional Information

resin-web.xml
<web-app xmlns="http://caucho.com/ns/resin" [^]
        xmlns:resin="urn:java:com.caucho.resin">
    <database>
        <jndi-name>jdbc/mysql</jndi-name>
        <driver type="com.mysql.jdbc.Driver">
            <url>jdbc:mysql://db001.stg:3306/wp_cms</url> [^]
            <user></user>
            <password></password>
        </driver>
        <prepared-statement-cache-size>8</prepared-statement-cache-size>
        <max-connections>20</max-connections>
        <max-idle-time>30s</max-idle-time>
        <spy />
    </database>

    <servlet servlet-name="quercus" servlet-class="com.caucho.quercus.servlet.QuercusServlet">
        <init>
            <compile>false</compile>
            <script-encoding>iso-8859-1</script-encoding>
<database>java:comp/env/jdbc/mysql</database>
            <ini-file>WEB-INF/php.ini</ini-file>
        </init>
    </servlet>

Attached Files

Screen shot 2011-04-05 at 1.10.55 PM.png [^] (42,326 bytes) 04-05-11 11:17

Screen shot 2011-04-05 at 1.53.17 PM.png [^] (43,696 bytes) 04-05-11 11:53

Relationships

Notes
(0005153) chiefgeek 04-05-11 11:54	The second screen shot is the same wordpress db running under apache + php5

(0005175) kdecherf 04-07-11 02:53	This issue exists because all Quercus source code is not Unicode compliant. You can find a solution here : https://github.com/CleverCloud/Quercus/tree/unicode [^]

Issue History
Date Modified	Username	Field	Change
04-05-11 11:17	chiefgeek	New Issue
04-05-11 11:17	chiefgeek	File Added: Screen shot 2011-04-05 at 1.10.55 PM.png
04-05-11 11:53	chiefgeek	File Added: Screen shot 2011-04-05 at 1.53.17 PM.png
04-05-11 11:54	chiefgeek	Note Added: 0005153
04-07-11 02:53	kdecherf	Note Added: 0005175
04-07-11 08:57	kdecherf	Issue Monitored: kdecherf

Mantis 1.0.0rc3[^]

34 total queries executed.
27 unique queries executed.