Hi Piotr > check mysql server [...] client connection charset. if not ,set all to utf8.
True, but note that changing whatsoever configuration on the database side won't help unless you set mysql_enable_utf8 to a true value when calling 'connect()' on the Perl side. DBD::mysql will set the client connection to 'latin1' otherwise. You can check dbdimp.c at lines 1760 ff. to see how it's done. Another helpful hint is to create new schemas like this: CREATE SCHEMA IF NOT EXISTS `my_new_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; With that you don't need to be explicit about the character set when adding new tables (or columns) to that schema. Regards Matias E. Fernandez _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
