Bug #70076 | CSV engine does not honour CHARSET specification | ||
---|---|---|---|
Submitted: | 18 Aug 2013 18:59 | Modified: | 4 Jul 2014 16:53 |
Reporter: | Peter Laursen (Basic Quality Contributor) | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Charsets | Severity: | S3 (Non-critical) |
Version: | 5.6+ | OS: | Windows |
Assigned to: | CPU Architecture: | Any |
[18 Aug 2013 18:59]
Peter Laursen
[18 Aug 2013 19:43]
Peter Laursen
Also see http://bugs.mysql.com/bug.php?id=70077
[19 Aug 2013 8:09]
Peter Laursen
Actually I think the best category here is CSV engine and not charset. You can change as you want. And probably reproducible since 5.1. Consider this: CREATE TABLE .. ENGINE CSV CHARSET big5; .. I really doubt that any system capable of running MySQL can create a file with such encoding. And: CREATE TABLE .. ENGINE CSV CHARSET latin2; -- on a Western system makes no sense So CHARSET probably makes little sense for CSV tables at all. CHARSET (encoding) is handled by the underlying OS and filesystem. But still on Windows (at least) it should in principle be posible to specify 3 different unicode charsets (utf8, utf16 and utf16le) as Windows handles all 3. But if I am right that the storage format for CSV tables was changed between 5.1 and 5.6, it raises the questions: * when? * why? * have the usability of the CSV files outside a MySQL context decreased? * where is it documented? * how does it affect upgrading users having user data in CSV tables?
[4 Jun 2014 16:53]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat with 5.6.19 running on Windows 7 Ultimate 64-bits English with locale Brazilian Portuguese. Please check with 5.6.19. Thanks.
[5 Jul 2014 1: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".