Mantis Bugtracker
  

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0003849 [Quercus] minor always 01-14-10 13:36 03-11-13 18:22
Reporter nam View Status public  
Assigned To nam
Priority normal Resolution fixed  
Status closed   Product Version 4.0.2
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.
Additional Information
Attached Files

- Relationships

- 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 [^]
 

- Issue History
Date Modified Username Field Change
01-14-10 13:36 nam New Issue
01-14-10 13:51 whr Issue Monitored: whr
01-14-10 20:51 ferg Note Added: 0004386
05-11-11 15:27 dicr Note Added: 0005237
05-11-11 15:29 dicr Note Added: 0005238
05-11-11 15:31 dicr Note Added: 0005239
05-11-11 15:32 dicr Issue Monitored: dicr
03-11-13 16:51 nam Status new => assigned
03-11-13 16:51 nam Assigned To  => nam
03-11-13 18:22 nam Status assigned => closed
03-11-13 18:22 nam Note Added: 0006214
03-11-13 18:22 nam Resolution open => fixed
03-11-13 18:22 nam Fixed in Version  => 4.0.36


Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
41 total queries executed.
32 unique queries executed.
Powered by Mantis Bugtracker