freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: [ freetds-Patches-582445 ] Add VARCHAR to convert t able

From: "Lowden, James K" <LowdenJK AT bernstein.com>
To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
Subject: RE: [ freetds-Patches-582445 ] Add VARCHAR to convert t able
Date: Tue, 16 Jul 2002 17:23:13 -0400

> From: noreply AT sourceforge.net [mailto:noreply AT sourceforge.net]
> Sent: July 16, 2002 4:09 PM

> Patches item #582445, was opened at 2002-07-16 22:08
> You can respond by visiting:
> https://sourceforge.net/tracker/?func=detail&atid=407808&aid=5
> 82445&group_id=33106
>
> Convert table (in convert.c) do not handle VARCHAR

Actually, several types are missing:

grep '#define SYB' tds.h |cut -n -f 2 -d ' ' |perl -ne'BEGIN {@t = split
/\s+/, qq(CHAR TEXT BINARY IMAGE INT1 INT2 INT4 FLT8 REAL NUMERIC DECIMAL
BIT MONEY MONEY4 DATETIME DATETIME4 BOUNDARY SENSITIVITY); foreach (@t) {
$t{$_}=-1;} } chomp; s/SYB//; $t{$_}++; END {foreach $k (keys %t) {print
"$k$/" if $t{$k};} }

Just cd freetds/include, and run the above. It will print out:

BOUNDARY
VARIANT
BITN
VARCHAR
VOID
SENSITIVITY
INTN
MONEYN
VARBINARY
NVARCHAR
NTEXT
INT8
UNIQUE
FLTN
DATETIMN

More work to do, I'm afraid.

--jkl

RE: [ freetds-Patches-582445 ] Add VARCHAR to convert t able, Lowden, James K, 07/16/2002