[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] Character conversion error with special
From:       "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio () vodafone ! com>
Date:       2008-07-18 11:07:20
Message-ID: 72EBB5FADDA71343B78E1F09FF471F6E452946 () OBOMEXO02 ! omnitel ! it
[Download RAW message or body]

--===============2095761811==
Content-class: urn:content-classes:message
Content-Type: multipart/signed;
	boundary="----=_NextPart_000_001A_01C8E8D7.352B1E10";
	micalg=SHA1; protocol="application/x-pkcs7-signature"

This is a multi-part message in MIME format.


> 
> 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: 
> http://pastebin.com/m3a90fc7b
>  
> 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) ??

freddy77

["smime.p7s" (application/x-pkcs7-signature)]

_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

--===============2095761811==--

[prev in list] [next in list] [prev in thread] [next in thread]