| Anonymous | Login | Signup for a new account | 12-17-2024 11:51 PST |
| Main | My View | View Issues | Change Log | Docs |
| 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. |  |
