Ticket #12119

unicode problem mysql
Eröffnet am: 2008-03-21 23:25 Letztes Update: 2008-03-24 22:33

Auswertung:
Verantwortlicher:
(Keine)
Status:
Offen
Komponente:
(Keine)
Meilenstein:
(Keine)
Priorität:
5 - Mittel
Schweregrad:
5 - Mittel
Lösung:
Keine
Datei:
2

Details

when inserting to the Mysql base utf-8 encoding
strings, values are inserted incorrectly, but if select
form the same table, values inserted with another tool
(MySQL Administrator) are displayed correctly. it seems
there is some problem on insert. I attached a screenshot.

hope to see this bug fixed in the next version.

There is no such problem with sqlite db.
unfortunately I can't test it with oracle right now but
I'll do it later and will report the result here.

Thanks

Ticket-Verlauf (3/3 Historien)

2008-03-21 23:25 Aktualisiert von: gozala
  • File 2249: screen.png is attached
2008-03-24 22:29 Aktualisiert von: zigen
  • File 2255: mysql.gif is attached
Kommentar
Logged In: YES
user_id=31258

this is no bug.

When use utf8, please setting charset 'utf8' by database
define dialog.

1)setting of charset is 'utf8' (mysql.gif)

or

2)modify connection string
ex. jdbc:mysql://localhost:3306/utf8db?
useUnicode=true&characterEncoding=utf8

2008-03-24 22:33 Aktualisiert von: zigen
Kommentar
Logged In: YES
user_id=31258

The utf8's data that has already been registered
Please try after it deletes it once.

Dateianhangliste

Bearbeiten

Please login to add comment to this ticket » Anmelden