Skip to Content.
Sympa Menu

freetds - International characters & FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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.

Top of Page