FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

All, 

More conversions, more messages, just plain more.  Changelog attached.  

Frediano fixed iconv conversion to replace untranslatable characters with
"?" (instead of truncating the string).  And he gave us a new conversion
from char to unique.  

Failed conversions of all kinds should now emit a message to the error
handler of your choice.  There's some cleanup to do.  The bolts are there,
but could use tightening.  

Also, here's my latest convert_acid output.  As you can see, coverage is
much more complete, and, um, it segfaults are getting rarer.  

Regards, 

--jkl

<convert_acid output>
column_name:     nine
column_type:      56
column_size:      4
length:   4
data (first word):       
9
[int,char]      '9' -> '9'
[int,varchar]   '9' -> '9'
Will not convert int, integer-null
[int,tinyint]   '9' -> '9'
[int,smallint]          '9' -> '9'
[int,int]       '9' -> '9'
Will not convert int, long long
[int,float]     '9' -> '9.000000'
Will not convert int, datetime
[int,bit]       '9' -> '1'
[int,text]      '9' -> '9'
Will not convert int, UCS-2 text
[int,image]     Msg 249, Level 16
Syntax error during explicit conversion of SYBINT4 value '9' to a SYBIMAGE
field.

No output converting 4 bytes of 56 to 34
/* money, smallmoney outputs are OK, test program is broken */
[int,smallmoney]        '9' -> (4 bytes) '90909090 '
[int,money]     '9' -> (8 bytes) '90909090 90909090 '
Will not convert int, smalldatetime
[int,real]      '9' -> '9.000000'
[int,binary]    Msg 249, Level 16
Syntax error during explicit conversion of SYBINT4 value '9' to a
SYBBINARY field.

No output converting 4 bytes of 56 to 45
Will not convert int, void
Will not convert int, varbinary
Will not convert int, UCS-2 varchar
Will not convert int, bit-null
[int,numeric]   Msg 249, Level 16
Syntax error during explicit conversion of SYBINT4 value '9' to a
SYBNUMERIC field.

No output converting 4 bytes of 56 to 108
[int,decimal]   Msg 249, Level 16
Syntax error during explicit conversion of SYBINT4 value '9' to a
SYBDECIMAL field.

No output converting 4 bytes of 56 to 106
Will not convert int, float-null
Will not convert int, money-null
Will not convert int, datetime-null
Will not convert int, xchar
Will not convert int, xvarchar 
Will not convert int, x UCS-2 varchar
Will not convert int, x UCS-2 char
Will not convert int, xvarbinary
Will not convert int, xbinary
Will not convert int, uniqueidentifier
Will not convert int, variant 
</output>

recent ChangeLog:
Tue Aug 27 02:38:16 EDT 2002    JK Lowden <jklowden AT schemamania.org>
        * src/tds/convert.c     Error messages (tds_client_msg) from 
tds_convert
        * src/tds/token.c       don't write to null socket's state in 
tds_client_msg
        * src/dblib/dblib.c     fix vasprintf prototype; extend dbprtype
Mon Aug 26 22:04:23 CEST 2002   Frediano Ziglio <freddy77 AT angelfire.com>
        * src/tds/convert.c src/tds/unittests/t0007.c:
        - add conversion from char to unique
        * src/tds/token.c:
        - print also hexadecimal value for unknown marker

Mon Aug 26 17:40:28 CEST 2002   Frediano Ziglio <freddy77 AT angelfire.com>
        * src/tds/iconv.c:
        - compile if iconv not present

Mon Aug 26 16:17:12 CEST 2002   Frediano Ziglio <freddy77 AT angelfire.com>
        * src/tds/convert.c:
        - add comment for not add 0x for binary->char conversions

Sun Aug 25 09:34:34 CEST 2002   Frediano Ziglio <freddy77 AT angelfire.com>
        * src/tds/iconv.c:
        - best conversion from unicode, replace wrong characters with '?'
          (both iconv and C code)
        - do not return garbage data
        * src/tds/mem.c:
        - init iconv cd to -1 to avoid possible wrong iconv_close calls