Type table
"ZIGLIO, Frediano, VF-IT" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi, I'm writing a small table to keep all type information consistent. Anyone can comment it? I have some missing informations, some questions and ideas. missing informations - how should I fill correctly varint for blobs/variant and other strange types?? "classics" like IMAGE/TEXT (with timestamp and table name) use 4 but SYBLONGCHAR use 5 (only 4 bytes length). - I don't know SYBVOID, MS UDT and MS XML that much - some types have different encoding based on usertype (SYBLONGBINARY for instance), how should I fill ascii/unicode ideas - define some "supertype" for conversions?? Supertype should represent a class of types (ie INT1/INT2/INT4/INT8 -> INT, any DATE/TIME -> DATETIME) so tdsconvert should convert sybase -> supertype -> sybase ? The idea is to semplify log switches, for instance for SYBINT2 -> SYBCHAR conversion we could convert SYBINT2 -> INT -> SYBCHAR. freddy77 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds
freetds_types.txt
(text/plain, 2 KB)
Name vendor varint fixed nullable variable blob numeric unicode ascii SYB5INT8 SYB 0 0 0 0 0 0 0 0 SYBBINARY ALL 1 0 1 1 0 0 0 0 SYBBIT ALL 0 1 0 0 0 0 0 0 SYBBITN MS 1 0 1 0 0 0 0 0 # Sybase bit is not nullable SYBBLOB SYB ?? 0 1 1 1 0 Depend Depend SYBBOUNDARY SYB 1 0 1 1 0 0 0 1 SYBCHAR ALL 1 0 1 1 0 0 0 1 SYBDATE SYB 0 1 0 0 0 0 0 0 SYBDATEN SYB 1 0 1 0 0 0 0 0 SYBDATETIME ALL 0 1 0 0 0 0 0 0 SYBDATETIME4 ALL 0 1 0 0 0 0 0 0 SYBDATETIMN ALL 1 0 1 0 0 0 0 0 SYBDECIMAL ALL 1 0 1 0 0 1 0 0 SYBFLT8 ALL 0 1 0 0 0 0 0 0 SYBFLTN ALL 1 0 1 0 0 0 0 0 SYBIMAGE ALL 4 0 1 1 1 0 0 0 SYBINT1 ALL 0 1 0 0 0 0 0 0 SYBINT2 ALL 0 1 0 0 0 0 0 0 SYBINT4 ALL 0 1 0 0 0 0 0 0 SYBINT8 ?? 0 1 0 0 0 0 0 0 SYBINTERVAL SYB 0 1 0 0 0 0 0 0 SYBINTN ALL 1 0 1 0 0 0 0 0 SYBLONGBINARY SYB 5 ?? 0 1 1 1 0 Depend Depend SYBLONGCHAR SYB 5 ?? 0 1 1 1 0 ?? ?? SYBMONEY ALL 0 1 0 0 0 0 0 0 SYBMONEY4 ALL 0 1 0 0 0 0 0 0 SYBMONEYN ALL 1 0 1 0 0 0 0 0 SYBMSUDT MS ?? 0 1 1 ?? 0 ?? ?? SYBMSXML MS ?? 0 1 1 ?? 0 ?? ?? SYBNTEXT MS 4 0 1 1 1 0 1 0 SYBNUMERIC ALL 1 0 1 0 0 1 0 0 SYBNVARCHAR MS ?? 0 1 1 0 0 1 0 # Same as XSYBNVARCHAR ?? SYBREAL ALL 0 1 0 0 0 0 0 0 SYBSENSITIVITY SYB 1 0 1 1 0 0 0 1 SYBSINT1 SYB 0 1 0 0 0 0 0 0 SYBTEXT ALL 4 0 1 1 1 0 0 1 SYBTIME SYB 0 1 0 0 0 0 0 0 SYBTIMEN SYB 1 0 1 0 0 0 0 0 SYBUINT1 SYB 0 1 0 0 0 0 0 0 SYBUINT2 SYB 0 1 0 0 0 0 0 0 SYBUINT4 SYB 0 1 0 0 0 0 0 0 SYBUINT8 SYB 0 1 0 0 0 0 0 0 SYBUINTN SYB 1 0 1 0 0 0 0 0 SYBUNIQUE MS 1 0 1 0 0 0 0 0 SYBUNITEXT SYB 4 0 1 1 1 0 1 0 # UTF-16 SYBVARBINARY ALL 1 0 1 1 0 0 0 0 SYBVARCHAR ALL 1 0 1 1 0 0 0 1 SYBVARIANT MS 4 ?? 0 1 1 0 0 Depend Depend SYBVOID MS ?? 0 1 ?? ?? 0 0 0 0 SYBXML SYB 4 0 1 1 1 0 ?? ?? XSYBBINARY MS 2 0 1 1 0 0 0 0 XSYBCHAR MS 2 0 1 1 0 0 0 1 XSYBNCHAR MS 2 0 1 1 0 0 1 0 XSYBNVARCHAR MS 2 0 1 1 0 0 1 0 XSYBVARBINARY MS 2 0 1 1 0 0 0 0 XSYBVARCHAR MS 2 0 1 1 0 0 0 1 # XSYBVARCHAR blob se TDS9 ?? # char if ascii or unicode # there are some type that allow size 0 or a constants (SYBDATEN, SYBUNIQUE)
smime.p7s
(application/x-pkcs7-signature, 3.1 KB) - not displayed