January 28, 2003 at 11:05 am
Hi all, I have large amounts of text i have to put in a text field in a sql 2000 database, what datatype should i use? Varchar (8000), Text (16), when i try both of these when i paste the text in the database noting happens. Usually you get the <Long Text> message box this is not happening. Can anyone helpe me out?
Thanks.
January 28, 2003 at 11:18 am
Use code to insert text data into your table. Do not use Enterprise Manager.
Do not use regular SQL INSERT, UPDATE, etc. The following commands should be used:
READTEXT, TEXTPTR, WRITETEXT, UPDATETEXT. Look in Help for details on these commands.
If your text size does not ecceed 8000 characters, avoid the TEXT type and use VARCHAR instead. Then you can use regular SQL commands: INSERT, UPDATE, etc. Be aware of the fact that TEXT data is stored separately from the other columns of a table: TEXT cannot fit on a SQL Server page. Only a pointer to the text is stored with the row itself. Therefore, text data operations are much slower than operations on other data types.
January 28, 2003 at 11:43 am
Thanks mromm for your help. I'll try that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply