Adaptive Server now supports long identifiers. There are new limits for the length of object names or identifiers: 255 bytes for regular identifiers, and 253 bytes for delimited identifiers. The new limit applies to most user-defined identifiers including table name, column name, index name and so on. Due to the expanded limits, some system tables (catalogs) and built-in functions have been expanded. For variables, “@” counts as 1 byte, and the allowed name is 254 bytes long.
Change identifier names with corresponding application changes for binding values. Make sure your application is not binding names of identifiers with only 30 bytes, which was the previous limit. This may cause a variety of unexpected behaviors or error messages.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |