[wp-testers] UTF-8 problem

[Rimas Abromavičius]

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: wp-testers-bounces at lists.automattic.com
[mailto:wp-testers-bounces at lists.automattic.com] On Behalf Of Peter Westwood
Sent: Sunday, November 26, 2006 1:53 PM
To: wp-testers at lists.automattic.com
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
wp-testers at lists.automattic.com
http://lists.automattic.com/mailman/listinfo/wp-testers