hi i remember a script charset-convert.pl
as far as i know, you must dump the database and convert the dump and then restore it hth florian Am 27.12.2012 um 10:32 schrieb Coert Waagmeester <[email protected]>: > Hello all, > > I have successfully and carefully upgraded OTRS from 2.3 on a Centos 2.5 box > to 3.1 on a new Centos 6.3 box. > > So far everything seems to be working. > > According to Admin > Support Assessment, > > I have to set the database to use utf8 instead of latin1. > > Googled till I am blue in the face, and found the following: > > > My otrs DB: > mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S > WHERE schema_name='otrs'; > +----------------------------+ > | default_character_set_name | > +----------------------------+ > | latin1 | > +----------------------------+ > 1 row in set (0.00 sec) > > > This DB went through all the correct upgrade steps. > I started by installing otrs 2.3 and restoring the data. > Upgraded to 2.4, 3.0, and 3.1, and for each upgrade ran the appropriate > DBUpdate sql files and perl scripts. > > Is there a way to change the existing DB from latin1 to UTF8? > > according to google I have to for loop through each table? > > Any help would be greatly appreciated! > > Kind regards, > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
