Re: utf8 and mysql

2013-08-01 Thread Tim Bunce
On Thu, Aug 01, 2013 at 10:28:41AM +0300, Gabor Szabo wrote: > On Wed, Jul 31, 2013 at 7:39 PM, Meir Guttman wrote: > > Dear Gabor, > > You must include «mysql_enable_utf8 => 1» hash record in the connection > > attributes used when you create the DBI handle > > my %conn_attrs = (RaiseError=>

Re: utf8 and mysql

2013-08-01 Thread Gabor Szabo
On Wed, Jul 31, 2013 at 7:39 PM, Meir Guttman wrote: > Dear Gabor, > You must include «mysql_enable_utf8 => 1» hash record in the connection > attributes used when you create the DBI handle > my %conn_attrs = (RaiseError=> $RaiseError, > PrintError=> $PrintError, >

RE: utf8 and mysql

2013-07-31 Thread Meir Guttman
$AutoCommit, mysql_enable_utf8 => 1); my $dbh = DBI->connect ($dsn, $user_name, $password, \%conn_attrs); Meir -Original Message- From: szab...@gmail.com [mailto:szab...@gmail.com] On Behalf Of Gabor Szabo Sent: יום ד 31 יולי 2013 19:09 To: dbi-users@perl.org Subject: utf8 an

utf8 and mysql

2013-07-31 Thread Gabor Szabo
Hi, I am quite lost at this utf8 issue: I have a file that I opened with open(my $KEYWORDS, "<:encoding(UTF-8)", $keywords_file) as I read the rows I can print them to a log file (that was opened using open(my $fh, '>>:encoding(UTF-8)', $log_name) and it looks ok. I insert it into the 'text' fiel