PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: How To Send String in UTF-8 Format to Sybase
Date: Mar 9 2001 5:42PM

Gary Chen writes:
 > I wrote a test program which reads in text string and
 > translates it into UTF8 format and sends to Sybase,
 > which stores the data in UTF8 format.
 > 
 > I have open a db connection without error by using the
 > following:
 > 
 >     $dbh = new Sybase::CTlib $uid, $pw, $svr, 't_utf',
 >       {CON_PROPS => { 
 >       CS_HOSTNAME() => 'test.db',
 >       CS_SYB_CHARSET() => 'utf8' }};

I think this is the problem. You are using CS_SYB_CHARSET(), but the
code expects CS_SYB_CHARSET (i.e. the string, not the numeric
value). Same with CS_HOSTNAME().

Michael
-- 
Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org
http://www.mbay.net/~mpeppler - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com