unicode problem mysql

• 回報者: gozala
• 負責人: (無)
• 類型: 特色請求
• 狀態: 開啟
• 元件: (無)
• 里程碑: (無)
• 優先權: 5 - 中
• 嚴重程度: 5 - 中
• 處理結果: 無
• 檔案: 2

細節

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 History (3/3 Histories)

2008-03-21 23:25 Updated by: gozala

• File 2249: screen.png is attached

2008-03-24 22:29 Updated by: zigen

• File 2255: mysql.gif is attached

評語

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 Updated by: zigen

評語

Logged In: YES
user_id=31258

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