Probléma: Ha a FlySpray telepítése előtt létrehozott adatbázist elfelejtettük alapértelmezetten UTF-8 karakterkódolásra állítani, akkor a legelső latin-2 inkompatibilis karakternél kiakad és vagy badarságot ír be az adatbázisba vagy jobb esetben hibás lesz a lekérdezés.
Megoldás: Állítsuk UTF-8 karakterkódolásúra az adatbázisunkat. Az itt kiadott parancsok egyúttal konvertálnak is, tehát ha már van némi adatod, semmi gond, rendben lesznek. De a művelet előtt mindenképp csinálj biztonsági másolatot, ha fontosak az adataid!
USE <adatbázisnév>; ALTER TABLE flyspray_admin_requests CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_assigned CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_attachments CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_cache CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_comments CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_dependencies CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_effort CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_groups CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_history CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_links CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_list_os CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_list_category CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_list_resolution CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_list_status CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_list_tag CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_list_tasktype CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_list_version CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_notification_messages CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_notification_recipients CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_notifications CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_prefs CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_projects CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_registrations CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_related CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_reminders CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_searches CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_tasks CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_tags CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_task_tag CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_user_emails CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_users CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_users_in_groups CONVERT TO CHARACTER SET utf8; ALTER TABLE flyspray_votes CONVERT TO CHARACTER SET utf8;