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
