[Catalyst] UTF-8 strings getting stragely converted to latin1 when coming from MySQL DB
Matt S Trout
dbix-class at trout.me.uk
Thu Mar 2 16:50:59 CET 2006
On Thu, Mar 02, 2006 at 04:35:37PM +0100, Michele Beltrame wrote:
> I'm experiencing a problem with a Catalyst 5.65 installation under
> Ubuntu Linux 5.10. All the tables on the MySQL database are marked
> UTF-8, and the collation is utf8_general (as I always set it).
> I'm using DBIx::Class, and I loaded the Unicode plugin in Catalyst.
> However, when I read something from the SQL database, the string gets
> converted to latin1, so the accents (widely used in the Italian
> language) are not readable anymore - well, unless I switch the pages to
> latin1, but I'd like to use UTF-8.
A prototype of a DBIx::Class::UTF8Columns component was posted to the
dbix-class list today.
Matt S Trout Offering custom development, consultancy and support
Technical Director contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information
+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +
More information about the Catalyst