Skip to Content.
Sympa Menu

freetds - [freetds] Sybase large identifier support

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Ludo Brands" <ludo.brands AT free.fr>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Sybase large identifier support
  • Date: Mon, 14 Nov 2011 12:22:49 +0100

Hi,

I'm connecting to a ASE 15.7 server that supports large identifiers (max 255
chars). Freetds doesn't seem to support this. The TDS_CAPABILITY is missing
TDS_REQ_LARGEIDENT. Freetds sends the following TDS_CAPABILITY packet
(starting with 0xe2):
0070 00 04 01 35 31 32 00 00 00 03 00 00 00 00 e2 16 ...512.. ........
0080 00 01 09 00 08 0e 6d 7f ff ff ff fe 02 09 00 00 ......m. ........
0090 00 00 02 68 00 00 00 ...h...

jconnect supports large identifiers and sends following TDS_CAPABILITY (big
endian):
0070 00 00 01 35 31 32 00 00 00 03 00 00 00 00 e2 00 ...512.. ........
0080 18 01 0c 07 cd ff 85 ee ef 65 7f ff ff ff d6 02 ........ .e......
0090 08 00 06 80 06 48 00 00 00 .....H.. .

Is support for large identifiers planned?

A nasty problem with this version of ASE is that the maximum identifier
length is 28 even with quoted_identifier off. The docs specify a length of
30 when quoted_identifier off. The server always returns "The identifier
that starts with '...' is too long. Maximum length is 28."

Thanks, Ludo





Archive powered by MHonArc 2.6.24.

Top of Page