Mantis - Quercus
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
3849 minor always 01-14-10 13:36 03-11-13 18:22
Reporter: nam Platform:  
Assigned To: nam OS:  
Priority: normal OS Version:  
Status: closed Product Version: 4.0.2  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: 4.0.36  
Summary: 0003849: mysql utf-8 inserts are viewable in MySQL GUI browsers
Description: (rep by Ocean)

Inserts into a UTF-8 database are not viewable in UTF-8 format in any MySQL GUI browser. Queries done within PHP gives back the correct values.

This is a PHP bug because PHP uses ISO-8859-1 for the connection encoding.
Steps To Reproduce:
Additional Information:
Relationships
Attached Files:

Notes
(0004386)
ferg   
01-14-10 20:51   
This looks like it needs our implementation of the Mysql JDBC driver.
(0005237)
dicr   
05-11-11 15:27   
Yes, using iso-8859-1 for utf-8 data in mysql driver is the main quercus problem !
(0005238)
dicr   
05-11-11 15:29   
ferg, why normal servlets working with standard mysql driver without problems, but quercus translate php to servlets, which can't work with standard connector/J ? Consider disable forcing characterEncoding=iso-8859-1 and set names latin1 will solve your problems.
(0005239)
dicr   
05-11-11 15:31   
Using characterSetResult=utf8 against characterEncoding
and "/*!40101 set names utf8 */" instead of "set names utf8"
in PHP is currently workaround agains quercus forcing iso-8859-1.
(0006214)
nam   
03-11-13 18:22   
The MySQL encoding problem is fixed:

http://forum.caucho.com/showthread.php?p=36255#post36255 [^]