469,337 Members | 5,958 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,337 developers. It's quick & easy.

Information_schema.columns

13
if I select character_maximum_length from INFORMATION_SCHEMA.COLUMNS
if returns -1 on columns that are defined as varchar(max)
is this normal???
Apr 11 '08 #1
1 1958
ck9663
2,878 Expert 2GB
It's because varchar(max) has no defined length in character. It was added in sql2005 to accommodate those datatypes that could potentially exceed 8000 characters. Specially that sql2005 have improved it's support to XML data type. As of today, it can accommodate up to 2GB of data. That's why it's not giving you a definite character length.

-- CK
Apr 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Pachydermitis | last post: by
reply views Thread by Mark Johnson | last post: by
1 post views Thread by HSalim | last post: by
14 posts views Thread by mike.griffin | last post: by
reply views Thread by BB | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.