|
|
Posted by Hugo Kornelis on 09/30/55 11:17
On 31 May 2005 08:53:53 -0700, Sam wrote:
>Hi,
>What is the maximum character a text type column can contain ? Can't
>change the length to upper than 16....
>What is the bigger ? Varchar(8000) or Text ?
Hi Sam,
The length you see for text columns in tools such as Enterprise Manager
is actually the length of a pointer. This pointer points to a seperate
location where the actual text is stored. The pointer is part of the
data row; the text itself is not. This keeps the data row small
(speeding up queries that dopn't use the text), but makes access to the
text slow (since another page has to be read).
The maximum length of a text value is 2 GB. (2,147,483,647 characters).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Navigation:
[Reply to this message]
|