On Tuesday 19 June 2012 17:09 Klaas Freitag wrote: > On 19.06.2012 16:58, Thomas Tanghus wrote: > > Hi, > > >> Hmm, as I see in the bug below, you already checked the system encodings. > >> Maybe the MySQL database is NOT set the UTF-8? It seems that the MySQL > > > >> database is not UTF-8 by default but has to be created like this: > > I asked them to change the collation manually in comment #1 to rule that > > out. > But did they change all the existing tables and data? See below...
Well I didn't look over their shoulders, but that was what I told them to do ;-) > >> CREATE DATABASE `Sample_DB` DEFAULT CHARACTER SET utf8 COLLATE > >> utf8_general_ci; > > > > I did try to merge the request below, but it apparently failed because of > > sql syntax error. I don't know how to make sure existing tables are > > updated to using utf-8, and to be honest I don't want to mess with the db > > setup code :-P > Thats good, as its tricky. See here: > http://yoonkit.blogspot.de/2006/03/mysql-charset-from-latin1-to-utf8.html Yeah, I did it the hard way :-P Isn't there any way we can change the charset on upgrade? -- Med venlig hilsen / Best Regards Thomas Tanghus _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
