Darn, your right.. But I'm sure he gets the idea.
Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Steve Onnis > Sent: Tuesday, 3 February 2004 2:22 PM > To: CFAussie Mailing List > Subject: [cfaussie] RE: sql question... > > > Taco > > "1400 words" > > not > > 1400 Chars > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Taco Fleur > Sent: Tuesday, February 03, 2004 7:19 AM > To: CFAussie Mailing List > Subject: [cfaussie] RE: sql question... > > > TEXT actually allows more like 2Gb (in MS SQL anyway), if you > change it to any other datatype that is text nothing will get > lost unless you specify the length to be less than it was. > > For 1400 characters you should actually use VARCHAR(1400), > VARCHAR goes up to 8000, NVARCHAR (for Unicode) goes up to 4000. > > I'd change your datatype to VARCHAR(1400) and check the > front-end of your application, maybe the cfqueryparam is set > to a max length, or the SP? > > Taco Fleur > Blog http://www.tacofleur.com/index/blog/ > Methodology http://www.tacofleur.com/index/methodology/ > > Tell me and I will forget > Show me and I will remember > Teach me and I will learn > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf > Of Michael > > Kear > > Sent: Monday, 2 February 2004 11:24 PM > > To: CFAussie Mailing List > > Subject: [cfaussie] RE: sql question... > > > > > > "Text" types in MS SQLServer allow for huge fields sizes. Something > > like 3MB, if I remember correctly. It's the one you want > if you have > > very large amounts of text. > > > > It's set to 16 because its only a reference to data held somewhere > > else that's needed in that record. For 1400 word fields, it's > > definitely the > > Text type you need. The problem must be elsewhere. Perhaps > > a double quote > > mark in the text being inserted? You can fix that by changing the > > double quote to a single quote or using " in the text instead. > > > > However if you were to change that field to another type, > say Varchar > > with a length of 255 characters (the maximum), you'd lose > everything > > in that field after the 255th character. > > > > Cheers > > Mike Kear > > Windsor, NSW, Australia > > AFP Webworks > > http://afpwebworks.com > > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Carl > > Vanderpal > > Sent: Tuesday, 3 February 2004 12:16 AM > > To: CFAussie Mailing List > > Subject: [cfaussie] sql question... > > > > Hello CFAussie, > > > > I have an sql 2k databse with a Data Type set to 'text' and > the length > > automatically sets to 16..and my customer is trying to insert some > > text into the field (he said around 1400 words) but it > won't accept it > > all...into the database. So do I need to change the field type to > > something else? he suggested I allow for 3,000 words just in case. > > > > Any suggestions? > > > > 2) and if we do change it will that effect the text already > in there? > > > > > > > > > > > > Best regards, > > Carl Vanderpal > > Po Box 3462 Dural, NSW 2158 > > mailto:[EMAIL PROTECTED] > > > > > > --- > > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To > > unsubscribe send a blank email to > > [EMAIL PROTECTED] > > > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
