Char is generally fixed length although will probably work just fine. I don't know what CLOB is as I have never used it. LongVarChar I have also not used. I do know that varchar will probably work just fine. I use it for all my text fields regardless of how they are defined in the DB (char or varchar in SQL 2005).
Ray Thompson Tau Beta Pi - www.tbp.org The Engineering Honor Society 865-546-4578 > -----Original Message----- > From: Rich [mailto:ri...@twcny.rr.com] > Sent: Wednesday, March 10, 2010 12:11 PM > To: sql > Subject: Re: cfqueryparam and MySQL text field > > > Is there supposed to be a choice? Isn't there one that's "supposed to > be used" for text? > > Thanks, > > Rich > > > On Mar 10, 2010, at 8:16 AM, Ray Thompson wrote: > > > > > CF_SQL_VARCHAR would be my first choice. > > > > Ray Thompson > > Tau Beta Pi - www.tbp.org > > The Engineering Honor Society > > 865-546-4578 > > > >> -----Original Message----- > >> From: Rich [mailto:ri...@twcny.rr.com] > >> Sent: Wednesday, March 10, 2010 1:42 AM > >> To: sql > >> Subject: cfqueryparam and MySQL text field > >> > >> > >> Hi. Anybody know what the CFSQLType parameter should be in > >> cfqueryparam when dealing with a text field in a MySQL database? > >> There is no "CF_SQL _Text". The only ones that seem related are: > >> > >> CF_SQL_CHAR > >> CF_SQL_CLOB > >> CF_SQL_LONGVARCHAR > >> CF_SQL_VARCHAR > >> > >> Thanks, > >> > >> Rich > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3294 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
