Bug #35309 | Strange behaviour using non ascii code as à, é, é, ì, ò, ù | ||
---|---|---|---|
Submitted: | 15 Mar 2008 12:28 | Modified: | 18 May 2008 13:34 |
Reporter: | francesco peretti | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: General | Severity: | S3 (Non-critical) |
Version: | 5.0.51a | OS: | Windows |
Assigned to: | Susanne Ebrecht | CPU Architecture: | Any |
Tags: | gui tools, stored procedure, utf8 |
[15 Mar 2008 12:28]
francesco peretti
[17 Mar 2008 15:59]
Sveta Smirnova
Thank you for the report. Please provide your ODBC connect options (see http://dev.mysql.com/doc/refman/5.0/en/myodbc-configuration-dsn-windows.html how to find them). Also please turn on general query log, then try to create procedure using Access and provide general query log to us. I believe this is most likely wrong configured client character set.
[17 Apr 2008 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[6 May 2008 16:47]
Susanne Ebrecht
Many thanks for writing bug report. How the files look like depends on the code page your Windows is using. For a German Windows, which uses code page 850 it is correct that: td_attività will get into td_attività .MYD. Italian, French, German and some other Western European languages have not so different signs so that you often can find one character set for all these languages. That's why I don't expect a great difference here between an Italian and a German Windows. The tools use UTF8 and your way was correct. It should also work, when you used: SET NAMES UTF8;
[18 May 2008 13:34]
francesco peretti
Thank you for your answer but, unfortunately, only today I read your e-mails. After the bug I created, I worked with MySQL 5.1.24RC and I noted that the anomaly reported isn't there. Since the release of MySQL 5.1 was/is imminent, and "my bug" is not crtical, I suspended further investigation. I intend to resume testing with the official release of MySql and to notify you with the result. best regards Francesco