To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62780 Issue #:|62780 Summary:|MySQL (JDBC) connector's charset settings do not work Component:|Database access Version:|OOo 2.0.2 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|putte_xvi
------- Additional comments from [EMAIL PROTECTED] Sat Mar 4 14:45:00 -0800 2006 ------- When connecting to a MySQL database via JDBC, the "Character set" setting of the "MySQL (JDBC)" database type does not seem to do anything (at least not with UTF-8). I have a database full of Unicode text (Japanese and Swedish). Everything works perfectly if I create a JDBC connection and specify "mysql://myhost:3306/mydatabase?characterEncoding=UTF-8" as data source (and com.mysql.jdbc.Driver as the driver). However, if I create a connection of the type "MySQL (JDBC)" instead, and specify equivalent values in the appropriate boxes, including "Unicode (UTF-8)" in "Character set", everything is sent as ISO 8859-1. I have verified this with tcpdump. The data coming from the server is still UTF-8, and displayed correctly in OOo Base, but when Base saves a form, it gets sent as ISO 8859-1, and all Japanese characters are replaced with question marks. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
