Sybase large identifier support

"Ludo Brands" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <007201cca2bf$be0e4040$6602a8c0@Ludo10>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.