I am having a hard time understanding the following differences: ROWS, CElls.
My understading if a rows is this: any collection related data that crosses multiple columns. so for ex:
FirstName MiddleName LastName
john NULL Adams
In my understanding that would mean that a row is entire line that contans that users info, however each "cell" can contain upto 8k characters if i am using ansi, char type (8000). but then....
VARCHAR is an abbreviation for variable-length character string. It's a string of text characters that can be as large as the page size for the database table holding the column in question.
The size for a table page is 8,196 bytes, and no one row in a table can be more than 8,060 characters. This in turn limits the maximum size of a VARCHAR to 8,000 bytes.
The above definition to me indicates that the entire row (meaning all entries or cells) can only contain a total of 8k characters, i know that's not true but am confused on wht the author said that.
here is the link:
Thanks, - i know this is a dumb question but i am only on page 119 of my sql book which is all that i know so far about sql.