Encoding Error with item_db.sql

Originally posted by [b]shazeya[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=4445

The revision number found to have encoding problem is 14408 but other revisions, especially later, could be affected. The problem is a change from UTF8 to Latin1 (Windows MySQL default character set). MySQL GUI Tools (Query Browser) on Windows XP did not detect the problem, thus not affected, whereas the Linux version (Debian and Ubuntu tested) did. MySQL Workbench on Windows 7 detected the problem but automatically switch it to Latin1.

The use of Latin1 will be an issue with Linux GUI applications which automatically use the system default of UTF8. It is less likely an issue with CLI but can be when the locale is set to UTF-8.

Some screen shots follow.

[img]http://img543.imageshack.us/img543/9985/u313.jpg[/img]
Query Browser on Ubuntu 10

[img]http://img508.imageshack.us/img508/2307/w594.jpg[/img]
MySQL Workbench on Windows 7


MySQL Workbench also detected an error (Code 1064) for item 7862 Marshmallow. I have not checked the script (have none on my Nix at the moment) but suspect it to be escape character related.

[img]http://img801.imageshack.us/img801/135/w596.jpg[/img]
MySQL Workbench on Windows 7