Anonymous | Login | Signup for a new account | 12-09-2024 14:35 PST |
Main | My View | View Issues | Change Log | Docs |
Viewing Issue Simple Details [ Jump to Notes ] | [ View Advanced ] [ Issue History ] [ Print ] | |||||||||||
ID | 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 | |||||||||
Status | new | Product Version | 4.0.7 | |||||||||
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. |
|||||||||||
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 |
|||||||||||
|
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 [^] |
Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
34 total queries executed. 27 unique queries executed. |