Hi, AFAIK, it's not a straightforward operation for MySQL. It doesn't convert the existing data If data are stored in latin.
In short, it requires export, processing with iconv and import for the tables affected: http://khelll.com/blog/mysql/changing-database-encoding-from-latin-to-utf8/ --- Victor Dubiniuk On Tue, Jun 19, 2012 at 5:58 PM, Thomas Tanghus <[email protected]> wrote: > On Tuesday 19 June 2012 15:01 Klaas Freitag wrote: > > On 19.06.2012 14:41, Thomas Tanghus wrote: > > > Some weird character encoding error I can't reproduce: > > > > > > "I tried two different owncloud server configurations, while trying to > > > rule > > > out if this is a server problem or not. > > > > > > First Setup: Cent OS 6.2 Server, apache/MySQL Second Setup: Windows > 2003 > > > R2 > > > Server, apache/MySQL (Regional options -> all Greek) > > > > > > Both servers had exactly the same problem - files with filenames in > Greek > > > are shown in the web interface properly and they also sync and > download, > > > but they are saved with a strange filename in the server's file system. > > > > 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. > > > 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 > > https://gitorious.org/owncloud/owncloud/merge_requests/120 > > > http://bugs.owncloud.org/thebuggenie/owncloud/issues/oc-1017 > > > > -- > Med venlig hilsen / Best Regards > > Thomas Tanghus > _______________________________________________ > Owncloud mailing list > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud >
_______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
