Salut!
Check the console and locale settings as well as the content of the table
(using mysql command-line client).
Alexey Wasilyev <[EMAIL PROTECTED]> wrote:
> Hello!
>
> redhat 2.3 as
> DBD-mysql-2.9004
> perl 5.8.0
> MySQL-server-4.1.7-0.i386.rpm from mysql.org
>
> [EMAIL PROTECTED] start]# cat /etc/my.cnf
> [client]
> default-character-set=3Dkoi8r
>
> [mysqld]
> default-character-set=3Dkoi8r
>
> [mysql]
> default-character-set =3D koi8r
>
> From=20mysql command line all select's work ok, russian character's
> returned in koi8. But from perl:
>
> [EMAIL PROTECTED] start]# cat ./test.pl
> #!/usr/bin/perl
> use DBI;
> my ($dsn) =3D "DBI:mysql:partn_db:localhost";my ($user_name) =3D 'test';my =
> ($password) =3D 'test';my ($dbh, $sth);my (@ary);
> $dbh =3D DBI->connect ($dsn, $user_name, $password);
> $sth =3D $dbh->prepare ("SELECT name_rus FROM anket_deti_tbl;");
> $sth -> execute();
> while (@ary=3D$sth->fetchrow_array()) { print (join ("::",@ary));}
> $sth->finish();$dbh->disconnect();
>
> [EMAIL PROTECTED] start]# ./test.pl
> 123????? [EMAIL PROTECTED] start]#
>
> only "????" returned. what's wrong?
>
>
> sorry for my terrible english :)
>
> ---------------------------------------------------------------------------=
> ---
> Alexey A. Wasilyev | GazPriborAvtomatikaService | Web: www.gpas.ru
> (845-2) 45-85-12 | Chief of IT Department | EMail: [EMAIL
> PROTECTED]
> =20
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
