The tables were created etirely by WordPress (clean WP2.1alpha3 install).
I'm using MySQL 4.1.13a-nt and now that you noticed, I checked
global DB variables and there's a default "latin1" for "character set
connection" :)
I suppose that causes the problem, as it uses latin1 for connections unless
told to use utf8.
Nevertheless, I think WP should define the 'set names' parameter to whatever
charset is used blog-wide (bloginfo('charset'); 'UTF8' in most cases), as
many of
default mysql installations will be using 'latin1' by default.-- </Chionsas> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Westwood Sent: Sunday, November 26, 2006 1:53 PM To: [email protected] Subject: Re: [wp-testers] UTF-8 problem -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Rimas Abromavičius wrote: > Hello, > > I'm using WP2.1alpha3 and I'm having problems with some > specific character display (while writing in Lithuanian, > particularly character č [U+010D - latin c with caron]). > The problem lies in WP using latin1 connection for chatting > with DB. I don't notice this problem with WP2.05 somehow > and that is quite strange, because it should exhibit the > exact same behavior, as I don't see any 'set names utf8' there ;) > > When I put: > $this->query('SET NAMES UTF8'); > in line 57 of wp-includes/wp-db.php, it fixes the problem > because the DB connection then uses UTF-8 not just for storing, > but also for transferring the data. I'm not a MySQL nor PHP > guru, but I suppose this is a bug and should be fixed using > 'set names' or some other method. > I think this is more likely a mysql configuration issue. Are the tables in the database latin1 or utf8? westi - -- Peter Westwood http://blog.ftwr.co.uk -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFaYA4VPRdzag0AcURAhE8AJ9lYDkeDKEpSLrjYad1F4ttNLzSZwCeMMxg VIerFHbpoh4eYtDBdKOXF5k= =lDmy -----END PGP SIGNATURE----- _______________________________________________ wp-testers mailing list [email protected] http://lists.automattic.com/mailman/listinfo/wp-testers _______________________________________________ wp-testers mailing list [email protected] http://lists.automattic.com/mailman/listinfo/wp-testers
