unicode problem mysql

• 报告人: gozala
• 属主: (无)
• 类型: Feature Requests
• 状态: 开启
• 组件: (无)
• 里程碑: (无)
• 优先: 5 - Medium
• 严重性: 5 - Medium
• 处理结果: 无
• 文件: 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

任务单历史 (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.