Re: [gentoo-user] I'm going crazy ;-)
On 4/28/06, Sergio Polini [EMAIL PROTECTED] wrote: What's happening about locales/languages? I've tried to install PHP-Nuke and Xoops, but one of them (I don't remember which one, now ;-)) doesn't like utf8 encoding, because it creates too long primary keys for MySQL. So I remerged MySQL and replaced utf8 with latin1 in /etc/mysql/my.conf. I've emerged Mediawiki (thanks Ric!) with the math USE flag, but when I try to save a page containing a formula I get the error message: 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost) Yes! My wikidb database was created with latin1_swedish_ci collation!!! And phpmyadmin says to me that MySQL charset is utf8!!! Who has set those collation values??? I didn't... Sergio That's exactly the reason we still use mysql 4.0 in our production environment. The mysql charset thingy is basically a whole load of mess. A brief search on mysql's bug database shows some of the encoding bugs and unicode key length not correctly calculated are still not properly fixed yet they pushed their production version to 5.0. We might be switching to postgres, at least it supports views, triggers and handles encoding properly. The only thing preventing us from doing so is that we use Mantisbt, which only works with mysql. -- Joe -- There are 3 kinds of people in the world: Those who can count, and those who can't. -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] I'm going crazy ;-)
Qian Qiao: That's exactly the reason we still use mysql 4.0 in our production environment. The mysql charset thingy is basically a whole load of mess. A brief search on mysql's bug database shows some of the encoding bugs and unicode key length not correctly calculated are still not properly fixed yet they pushed their production version to 5.0. Thanks. I've unmerged mysql 4.1.14, and emerged 4.0.25. Now I'm revdep-rebuilding. This is why I love Gentoo ;-) Sergio -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] I'm going crazy ;-)
On Sat, 2006-04-29 at 08:18 +0100, Qian Qiao wrote: That's exactly the reason we still use mysql 4.0 in our production environment. The mysql charset thingy is basically a whole load of mess. A brief search on mysql's bug database shows some of the encoding bugs and unicode key length not correctly calculated are still not properly fixed yet they pushed their production version to 5.0. We might be switching to postgres, at least it supports views, triggers and handles encoding properly. The only thing preventing us from doing so is that we use Mantisbt, which only works with mysql. Are you sure it is not an Gentoo thing? I noticed this as well. Gentoo has utf8 in /etc/mysql/my.cnf. I personally don't need/want utf8. Some things I noticed with the Gentoo mysql install. MySQL sucks up a bunch of memory just sitting there. Looking in my.cnf the Gentoo defaults are pretty big. Lowering all the values got mysql down from 100+ MB to about 30MB. Why is it using utf8? Does mysql 5.x require that? Couldn't the Gentoo ebuild make it an option? When I tried to replace the Gentoo my.cnf with the example my-small.cnf, things wouldn't work. Maybe have the ebuild configure the three example files so that they all work and then a user can just symlink to the one they want? I am not running a production MySQL at home, just a development MySQL so I want it to have the smallest memory footprint possible. I would like to stay with MySQL 5.x for the new features. Switching to PostgreSQL doesn't really seem like an option (yet). A lot of the open source apps out there only target MySQL. This is especially true with PHP 4.x apps since PHP Data Objects (PDO) was not available and PHP 4.x required a slow DB wrapper class/script to target multiple databases and a lot of code duplications with mysql_*(), PGSQL_*(), etc. Once/If all those great PHP-based apps get ported to PHP 5.x and PDO, then PostgreSQL would be a true option. Have you tried to just download the MySQL binary and install it in /opt and see how that works? I might give that a go. Jim =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= There's no place like 127.0.0.1 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= JimD Central FL, USA, Earth, Sol -- gentoo-user@gentoo.org mailing list
[gentoo-user] I'm going crazy ;-)
What's happening about locales/languages? I've tried to install PHP-Nuke and Xoops, but one of them (I don't remember which one, now ;-)) doesn't like utf8 encoding, because it creates too long primary keys for MySQL. So I remerged MySQL and replaced utf8 with latin1 in /etc/mysql/my.conf. I've emerged Mediawiki (thanks Ric!) with the math USE flag, but when I try to save a page containing a formula I get the error message: 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost) Yes! My wikidb database was created with latin1_swedish_ci collation!!! And phpmyadmin says to me that MySQL charset is utf8!!! Who has set those collation values??? I didn't... Sergio -- gentoo-user@gentoo.org mailing list