On 07/10/2011 10:21, jul....@gmail.com wrote:
I have installed and ran successfully the AutoCRUD plugin, I set up a
mysql database tables to use UT8 charset, the charset in the ajax
requests is utf-8, everything seems correct, except the data in the
grids are double encoded, that means é instead of é.
After some investigation and poking around in documentation I found that
the following is essential to using Unicode in Catalyst apps:
1) tell your database connection to use unicode (this will be a flag in
the connect options, alongside your username, password, etc).
2) load the Catalyst::Plugin::Unicode::Encoding plugin.
These ensure that data is flagged correctly when moving in both
directions between the database and the user interface.
Acknowledgment must go the author(s) of the following pages:
http://wiki.catalystframework.org/wiki/tutorialsandhowtos/using_unicode
https://metacpan.org/module/DBIx::Class::Manual::Cookbook#Using-Unicode
The wiki page tells you the flag to use for each of the popular database
engines (I only tested with SQLite).
I hope this helps you Julien, and also the list archives!
regards,
oliver.
_______________________________________________
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/