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
Converting to UTF-8 ...
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Converting to UTF-8 ...
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
-
Lux
- Regular
- Posts: 764
- Joined: Fri Aug 12, 2005 4:36 pm
- Location: Grüt, Zürich, Switzerland
- Contact:
Re: Converting to UTF-8 ...
Hi Garvin,
Converting every text and varchar fields is far bigger as I expected.
Ok, might be converting the whole db dump helps.
Dirk
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.garvinhicking wrote:You need to change all tables and all VARCHAR or TEXT fields that have collations.
Converting every text and varchar fields is far bigger as I expected.
Ok, might be converting the whole db dump helps.
5.0.22 is the version.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.
Dirk