Forums
This topic is locked
text &data type&cannot input too many character
12 May 2004 15:56:55 Yeyi cn posted:
db:sql2000os:windows 2000 advanced server
software:dreamweaver mx 6.0
I want to make a guestbook for my homepage,
found that: I cannot input to mang character into the field which field type is ntext,
if text.length > 4000 then (about 9k)
the sql server will be stopped ,all site cannot run at this moment.
I should restar the sql server .
why?
Replies
Replied 12 May 2004 16:05:02
12 May 2004 16:05:02 Vince Baker replied:
This is the spec for 2000 sql server:
The storage size of char is a specified number of bytes, not to exceed 8,000. For varchar, the storage size is the actual length in bytes of the data entered, again not to exceed 8,000 bytes. Storage size of text also depends on the length of the data entered, but can store up to 231-1 (2,147,483,647) bytes.
Try changing it to a varchar field instead. ( or the n equivelant)
Regards
Vince
DMX Talkzone Manager
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
The storage size of char is a specified number of bytes, not to exceed 8,000. For varchar, the storage size is the actual length in bytes of the data entered, again not to exceed 8,000 bytes. Storage size of text also depends on the length of the data entered, but can store up to 231-1 (2,147,483,647) bytes.
Try changing it to a varchar field instead. ( or the n equivelant)
Regards
Vince
DMX Talkzone Manager
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
Replied 13 May 2004 03:32:31
13 May 2004 03:32:31 Yeyi cn replied:
Thank you for your help,
My site work naturally ,when I change the odbc connection to oledb connection.
But I did't know the reason .
My site work naturally ,when I change the odbc connection to oledb connection.
But I did't know the reason .
Replied 13 May 2004 10:23:24
13 May 2004 10:23:24 Vince Baker replied:
Did you have the latest MDAC component installed? 2.8 now I think... maybe your MDAC version is too old?
Still if it isnt broken, dont fix it!
Regards
Vince
DMX Talkzone Manager
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
Still if it isnt broken, dont fix it!
Regards
Vince
DMX Talkzone Manager
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
Replied 13 May 2004 19:47:34
13 May 2004 19:47:34 Yeyi cn replied:
I download the mdac 2.8 and install it,updata the dns conection,but the problem as before.