[freetds] Character conversion error with special characters(umlauts)
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Fri Jul 18 07:07:20 EDT 2008
> Hello everyone,
> After about a day of googling I've given up on tha path, so
> I'll bother you people instead.
> Basically I've got an Ubuntu server with Apache, mod_perl and
> the usual stuff. I've written a simple webapp that
> communicates with an MSSQL 8 on a Win2K3 box. This is being
> done through the (I guess typical) method of Perl package
> (DBI) talking to unixODBC/FreeTDS that talks to the server.
> Normal operation works great, no problems at all. But as soon
> as I showed my small app to my boss he broke it. I had
> totally forgotten to use non-english words when testing it
> (I'm a swede, but I code "in english" and thus I add test
> data in english too, old habit). So, adding words with åäö in
> an INSERT statement broke the application.
> Checking logs gave me an error: [unixODBC][FreeTDS][SQL
> Server]Error converting client characters into server's
> character set. Some character(s) could not be converted.
> Google helped me narrow it down, but I found no way to solve
> it. I've checked that iconv can translate it, it does so
> perfectly. I've tried some "common" special characters (like
> the ' ) and it works just fine. I've made sure I use nvarchar
> in the database (missed that at first, but changing it didn't
> help). My best guess atm is that the characters I want to use
> will "grow" during conversion (i.e. each byte becomes two
> bytes) between UTF-2 and UCS-2LE.
> I've put the logfile for you to have a look at if that helps:
> Many thanks in advance,
> Stefan Axelsson
I think it would be useful to see which characters are inserted.
Also did you try ClientCharset option (I don't know your configuration) ??
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 3129 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080718/10776632/attachment.bin
More information about the FreeTDS