Mantis Bugtracker
  

Viewing Issue Advanced Details Jump to Notes ] View Simple ] 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 Platform
Status closed   OS
Projection none   OS Version
ETA none Fixed in Version 4.0.36 Product Version 4.0.2
  Product Build
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
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