Page 1 of 1
Converting to UTF-8 ...
Posted: Sat Mar 01, 2008 2:24 pm
by Lux
Hi,
I think, I mixed it up.
To get a clean and proper encoding, I want to convert everything in my blog to utf8.
Can you please tell me, which tables and which fields therein I have to change?
Thanks for your support
Dirk
Re: Converting to UTF-8 ...
Posted: Sun Mar 02, 2008 12:12 pm
by garvinhicking
Hi!
You need to change all tables and all VARCHAR or TEXT fields that have collations.
Depending on your MySQL version, you might not need to change any table/field collations at all, because serendipity emits the "SET NAMES" query, and MySQL uses that to transcode content instead of using native collations.
Regards
Garvin
Re: Converting to UTF-8 ...
Posted: Sun Mar 02, 2008 12:19 pm
by Lux
Hi Garvin,
garvinhicking wrote:You need to change all tables and all VARCHAR or TEXT fields that have collations.
that is bad. I thought about a handful of fields like heading of articles, entries, extended entries, categories, comments and others I don't know.
Converting every text and varchar fields is far bigger as I expected.
Ok, might be converting the whole db dump helps.
garvinhicking wrote:Depending on your MySQL version, you might not need to change any table/field collations at all, because serendipity emits the "SET NAMES" query, and MySQL uses that to transcode content instead of using native collations.
5.0.22 is the version.
Dirk