insert arabic to mysql from perl

Question

When trying to insert arabic into mysql from Perl, the arabic content is displayed in the database like أ™إ أکآ³أکآ´أ™إ but when I retrieve the value from the database it will display like ÙØ³Ø´Ù in the web page.

note that my database and table charset is utf8 and the COLLATE is utf8_general_ci.

First, you need to establish what went wrong: putting it in the database, getting it from the database, or displaying it in the web page. — ikegami
Please provide the output of local $Data::Dumper::Useqq = 1; print(Dumper($str)); before you placed it in the database and after you fetched it from the database. — ikegami
Additionally, if you have phpMyAdmin, does the text look right using it? — ikegami

user4035 user4035 · Accepted Answer · 2013-11-29T03:24:32

Try using SET NAMES 'UTF8' after connecting to MySQL:

my $dsn = "DBI:mysql:$base_name:$mysql_host_url";
my $dbh = DBI->connect($dsn, $user_db, $password_db) or die $DBI::errstr;
$dbh->do(qq{SET NAMES "utf8"});

As the manual says:

SET NAMES indicates what character set the client will use to send SQL statements to the server... It also specifies the character set that the server should use for sending results back to the client.

insert arabic to mysql from perl

2 Answers