[Owncloud] Can someone with knowledge of file saving loading have a look at this?

[Victor Dubiniuk]

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 <thomas at tanghus.net> 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
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/owncloud/attachments/20120619/ef2d9786/attachment.html>