hi,
check mysql server settings, default character set, database charset,
table charet, client connection charset. if not ,set all to utf8.
after modifying mysql server settings, reinitialize database
use --default-character-set option when using mysql client to be
sure how data are loaded (l
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 clien
Hello!
I'm working on a bit weird base with wide usage of keywords as tables
names. I know it's bad practice but 'we cannot redevelop tables
structure', so I have to quote table names.
MySQL allows it, using backticks; does DBIx::Class allow more or less
easy handling of it, including automa
Hello Alex,
Check
http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Setting_quoting_for_the_generated_SQL
Have fun,
Nuba
On Tue, 6 Jul 2010, Alex Povolotsky wrote:
Date: Tue, 06 Jul 2010 14:17:29 +0400
From: Alex Povolotsky
Reply-To: "DBIx::Class user and developer
Hi Jesse,
Check:
http://blog.hno3.org/2010/04/22/fixing-double-encoded-utf-8-data-in-mysql/
or search for
mysql double encoding
with Google and you'll find more step by step instructions.
I also had that problem and I dumped a few tables with mysqldump (because not
all the tables were containi