Max record size

[enak]

I was looking at the specifications for SQL 2000. It states that Bytes per record is 8060. However, a text field will hold 2 GB.

Can someone explain this to me?

TIA
Nate

 

[fleckingerre]

Hi!

The Text Fields data is not directly stored in the Recordset. It stores a pointer to this Data and the Data itself is stored somewhere else. This is handled internally and you dont see this.

Greetings
Remo

 

[enak]

Thanks for your reply.

 

[enak]

Do I still UPDATE, INSERT, DELETE, and SELECT the same way?

 

[fleckingerre]

Hi again!

Normaly yes. You should make some tests to see if everything works for your needs.

Greetings
Remo

 

[tlbroadbent]

Actually, you may need to use text functions to read and update text columns. See TEXTPTR, TEXTVALID, READTEXT, WRITETEXT, and UPDATETEXT in SQL Books Online. The topics "Text and Image Functions" and "Using text, ntext, and image Functions" should be helpful in knowing why and how to use these functions. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.