Re: [Catalyst] Using mysql_enable_utf8

2009-04-30 Thread Malloy
I set init_connect=utf8 in my.cnf. 2009/4/29 Octavian Rasnita orasn...@gmail.com Hi, I need to use C::M::DBI for a fulltext index with MySQL, and the tables contain UTF-8 data. I found that I can use mysql_enable_utf8 but I couldn't find how to use this option. I've tried to use it in

Re: [Catalyst] Using mysql_enable_utf8

2009-04-30 Thread Joakim Lagerqvist
2009/4/29 J. Shirley jshir...@gmail.com: On Wed, Apr 29, 2009 at 8:30 PM, Octavian Rasnita orasn...@gmail.com wrote: I don't know why it didn't work for the first time... Because MySQL is evil. Just the other day I had some strange issues with MySQL and unicode. In some rare cases it cut

Re: [Catalyst] Using mysql_enable_utf8

2009-04-30 Thread J. Shirley
On Fri, May 1, 2009 at 1:08 AM, Joakim Lagerqvist joakim.lagerqv...@gmail.com wrote: Just the other day I had some strange issues with MySQL and unicode. In some rare cases it cut of strings in Lao language. It was not an issue with the field length, rather a certain combinations of

[Catalyst] Using mysql_enable_utf8

2009-04-29 Thread Octavian Rasnita
Hi, I need to use C::M::DBI for a fulltext index with MySQL, and the tables contain UTF-8 data. I found that I can use mysql_enable_utf8 but I couldn't find how to use this option. I've tried to use it in the model in 2 places as: __PACKAGE__-config( dsn =

Re: [Catalyst] Using mysql_enable_utf8

2009-04-29 Thread J. Shirley
2009/4/29 Octavian Rasnita orasn...@gmail.com Hi, I need to use C::M::DBI for a fulltext index with MySQL, and the tables contain UTF-8 data. I found that I can use mysql_enable_utf8 but I couldn't find how to use this option. I've tried to use it in the model in 2 places as:

Re: [Catalyst] Using mysql_enable_utf8

2009-04-29 Thread J. Shirley
On Wed, Apr 29, 2009 at 8:30 PM, Octavian Rasnita orasn...@gmail.comwrote: I don't know why it didn't work for the first time... Because MySQL is evil. (I use MySQL. Grudgingly) ___ List: Catalyst@lists.scsys.co.uk Listinfo:

Re: [Catalyst] Using mysql_enable_utf8

2009-04-29 Thread Octavian Râsnita
From: J. Shirley I don't know why it didn't work for the first time... Because MySQL is evil. (I use MySQL. Grudgingly) Well, now that Oracle bought MySQL, maybe it is the time to have some more courage and start using PostgreSQL... :-) Octavian