freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Ilya Storozhilov" <storozhilov AT newmail.ru>
- To: freetds AT franklin.oit.unc.edu
- Subject: International characters & FreeTDS
- Date: Mon, 4 Dec 2000 03:04:36 -0500
I use DBD::Sybase 0.91 working via FreeTDS library on FreeBSD 4.0. It
works good, but I have a big problem with international (Russian for
example) characters. Here is configuration & example:
1. FreeBSD 4.0 Stable, FreeTDS 0.51, Perl 500503, DBI 1.14, DBD::Sybase
0.91
2. WinNT 4.0 Server sp6, MS SQL 7.0 sp2
---------------------------------------------------------
USE Northwind
CREATE TABLE CLIENTS (CLIENTS_NAME VARCHAR(250))
CREATE PROCEDURE up_InsertClient @ClientName VARCHAR(250)
AS INSERT INTO CLIENTS VALUES (@ClientName)
---------------------------------------------------------
#!/usr/bin/perl
use DBI;
my $DBHandle = DBI->connect("DBI:Sybase:server=192.168.1.1", "sa",
"1234567890");
my $SQLText = "EXEC up_InsertClient \@ClientName = 'Some international
(Russian for example) characters'";
$DBHandle->do($SQLText);
$BDHandle->disconnect;
---------------------------------------------------------
Uncorrect symbols was writed to table CLIENTS after running this
Perl-script instead of normal Russian letters. It seems like loosing of
8-th bit in binary symbol's code. I have tried this code:
DBI->connect("DBI:Sybase:server=192.168.1.1;charset=cp1251;language=russian",
"sa", "1234567890");
and situation was repeated. Using DBD::FreeTDS script works correct, but
this module has too many another bugs and I can't use this.
Please help with this problem! Thanx!
Ilya Storozhilov.
- International characters & FreeTDS, Ilya Storozhilov, 12/04/2000
Archive powered by MHonArc 2.6.24.