[freetds] Data conversion limit for strings

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Mon Jan 26 04:30:16 EST 2004


...
> 19:20:23.342530 in dbsqlexec()
> 19:20:23.342545 in dbsqlsend()
> 19:20:23.342561 tds_put_string converting 128 bytes of "USE 
> xxxx_xxx; INSERT INTO test (test) VALUES 
> (N'ãLF-X1ãã¯ã12.1Våã®æ²æã¢ãã¿ã¼ã¨æä½é¨ï¼ãã¼ã¹ã¹>
> ãã¼ã·ã§ã³ï¼ã§æ§æãããåæ¹ã®éä¿¡ã"ã¯ã5GHz帯ã¯ã¤ã¤ãã¹è¦æ 
> ¼ã®ç¡ç·æè¡ï¼IEEE802.11aï¼ã¨ã2.4GHz帯ã®ã¯ã¤ã¤ãã¹è¦æ 
> ¼ã®ç¡ç·æè¡ï¼IEEE802.11b /  ^M
> ')"

This seem very strange... data seems not utf8... perhaps you cat log and copy/paste from shell/file? I noted your mail system is exchange. Can you post a lof of a select of already inserted data?

> 19:20:23.342580 tds_put_string wrote 0 bytes
> Sending packet @ 19:20:23.342597
> 0000 01 01 00 08 00 00 01 00-                        |........|
> 

This seem a bug in libTDS... tds_put_string do not output any bytes... perhaps data is not utf-8... perhaps libTDS should just return failure. If I remember data came from a web page... have you forced html charset to utf-8??

freddy77



More information about the FreeTDS mailing list