Maximum character limit reached!

[pjsamuel3]

Hi there,

I am trying to get more than 8000 characters into my SQL database but am having trouble!

I have been looking everywhere on the web and the only info I can find is that 'text' is the data type I need to use rather than 'varchar'.

Unfortunately I dont seem to be able to change the default character limit from 16. One page said I should be able to use 2^31-1 characters! morethan enough, but no joy yet.

Any replies would be most appreciated

cheers

Pete

[MAK]

varchar[(n)]

Variable-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000.


text

Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters.

Please note:

For text use
sp_configure "max text repl size", value

If you are using query analyser, click on Tools-option-results and update the "maximum character per column" to display all the data from a text or varchar column.

[pjsamuel3]

I am using Enterprise manager and i'm not sure how to enter what you have put for the text data type

sp_configure "max text repl size", value

into it. Is it along a stored proceedure line?

Thanks for the prompt reply!

Pete

[pjsamuel3]

fixed it!

I was being a moron!

I was updating the wrong column!

Your fix worked a treat, thanks MAK

Pete