[Catalyst] utf8 in mysql

2007-11-28 Thread Angel Kolev
Hi all. I have problem when fetch data from mysql. All data is in utf8 and in my phpmyadmin i can see all chars correctly. I dont know how to tell to my model to fetch data in utf8. With standart DBI module i can do it with : $dbh-do(set character set utf8); $dbh-do(set names utf8); Can u

Re: [Catalyst] utf8 in mysql

2007-11-28 Thread Tobias Kremer
Quoting Angel Kolev [EMAIL PROTECTED]: Hi all. I have problem when fetch data from mysql. All data is in utf8 and in my phpmyadmin i can see all chars correctly. I dont know how to tell to my model to fetch data in utf8. With standart DBI module i can do it with : $dbh-do(set character set

Re: [Catalyst] utf8 in mysql

2007-11-28 Thread Angel Kolev
Thank you very much! It works, but whitout mysql_enable_utf8 = 1, ([error] Caught exception in engine Wide character in syswrite at /usr/local/share/perl/5.8.8/Catalyst/Engine.pm line 626.) Tobias Kremer wrote: Quoting Angel Kolev [EMAIL PROTECTED]: Hi all. I have problem when fetch

Re: [Catalyst] utf8 in mysql

2007-11-28 Thread Jonathan Rockway
On Wed, 2007-11-28 at 18:02 +0200, Angel Kolev wrote: Thank you very much! It works, but whitout mysql_enable_utf8 = 1, ([error] Caught exception in engine Wide character in syswrite at /usr/local/share/perl/5.8.8/Catalyst/Engine.pm line 626.) Actually, this error message means that mysql

Re: [Catalyst] utf8 in mysql

2007-11-28 Thread Pedro Melo
Hi, On Nov 28, 2007, at 4:32 PM, Angel Kolev wrote: When i use mysql_enable_utf8 = 1 the page in my browser is blank. It works for me only without this option. Thank you for the link. hmms.. Going out on a limb here, but are you using DBIx::Class::UTF8Columns? I *think* mysql_enable_utf8

Re: [Catalyst] utf8 in mysql

2007-11-28 Thread Jonathan Rockway
On Wed, 2007-11-28 at 17:49 +, Pedro Melo wrote: Hi, On Nov 28, 2007, at 4:32 PM, Angel Kolev wrote: When i use mysql_enable_utf8 = 1 the page in my browser is blank. It works for me only without this option. Thank you for the link. hmms.. Going out on a limb here, but are

Re: [Catalyst] utf8 in mysql

2007-11-28 Thread Jonathan Rockway
On Wed, 2007-11-28 at 11:54 -0600, Jonathan Rockway wrote: With old projects, before mysql_enable_utf8 was supported, I used the set names on on_connect and the UTF8Columns plugin and everything worked ok, so maybe that is what you have. It wasn't actually working, it just appeared

Re: [Catalyst] utf8 in mysql

2007-11-28 Thread Angel Kolev
Jonathan Rockway wrote: It wasn't actually working, it just appeared to. The OP is getting a blank screen because he hasn't loaded Catalyst::Plugin::Unicode into his app yet. Regards, Jonathan Rockway Thank you very much. The page isnt blank now with: use Catalyst qw/-Debug

Re: [Catalyst] Re: CMS Revisited

2007-11-28 Thread Matt S Trout
On Tue, Nov 27, 2007 at 07:38:25PM -0800, Dennis Daupert wrote: Tony Losey: I am interested in contributing to this. I have been working on a lot of small use catalyst apps and was gearing up to get to something like this. I will be looking for the download when it's ready.