By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

Information_schema.columns

P: 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
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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.