Skip to Content.
Sympa Menu

freetds - Re: [freetds] How to Turn Off Character Conversion Failed Warnings

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: David Dick <ddick AT cpan.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] How to Turn Off Character Conversion Failed Warnings
  • Date: Fri, 12 Nov 2010 19:03:20 +1100

On 12/11/10 07:52, Eli Finkelshteyn wrote:
Hi Folks,
I'm using FreeTDS with Perl and DBD::Sybase to connect to a MSSQL 2008
server. Normally, this is well and good, but today I noticed that someone
thought it would be a good idea to write cp1252 data to a char column I'm
selecting from. This promptly made FreeTDS and Perl fail with the error:
"*Some
character(s) could not be converted into client's character set.
Unconverted bytes were changed to question marks ('?')*"

Now, that's completely fine, and I'm willing to live with the question
marks. The problem is that this warning is read as an error by Perl and
breaks my code!

Googling around, I found that I can use " * set * * char_convert on with no
error*" on a normal Sybase server to ignore this and go on with the code.
Is there some equivalent I can send to FreeTDS, or DBD::Sybase (perhaps a
setting in freetds.conf?) to do the same? I would find that immensely
helpful!

I wrote a <a href="http://use.perl.org/~ddick/journal/39102";>use.perl.org journal</a> which might be useful




Archive powered by MHonArc 2.6.24.

Top of Page