Thanks a lot for your help and time Emmanuel. I updated all the tickets, CF and templates that look corrupted. Next time i'll make sure I do the updates on a test server :)
Thanks again Emmanuel Lacour wrote: > > On Tue, Sep 02, 2008 at 07:39:14AM -0700, F350 wrote: >> >> Exactly. >> I run the show variables like 'character_set%'; command, here is the >> output: >> +--------------------------+----------------------------+ >> | Variable_name | Value | >> +--------------------------+----------------------------+ >> | character_set_client | latin1 | >> | character_set_connection | latin1 | >> | character_set_database | latin1 | >> | character_set_filesystem | binary | >> | character_set_results | latin1 | >> | character_set_server | latin1 | >> | character_set_system | utf8 | >> | character_sets_dir | /usr/share/mysql/charsets/ | >> +--------------------------+----------------------------+ >> >> I did execute the script again, same problem. > > Maybe not a good idea :( I hope it didn't did wrong things. > >> New tickets however are OK and scrambled custom field attributes and > > Theoritically you should be in a situation where: > > - datas inserted before 3.8.1 were converted from latin1 to utf-8 and > should appears right > - datas inserted after 3.8.1, before 4.0-4.1 script may be inserted as > utf-8, but tables may be defined as latin1 so may be garbled > - datas inserted after 4.0-4.1 scrip should be ok > >> templates can be modified and updated. Is it secure to update everything >> and >> forget about this problem ? >> > > The only risk I see (but I may be missing something) is that corrupted > tickets will continue to display badly, new tickets will be ok, every RT > configuration thinks that may contains non-ascii chars (queue names, > templates, scrips names, users names, group names, ...) should be > checked and updated manually if needed to look correctly on the UI. > > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > -- View this message in context: http://www.nabble.com/Charset-issues-after-upgrade-to-3.8.1-tp19267620p19272127.html Sent from the Request Tracker - User mailing list archive at Nabble.com. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
