Re: Best data type for comments using MySQL?

2007-09-14 Thread Jochem van Dieten
Will Tomlinson wrote: If I have user comments that could be 500-1000 characters, what datatype should I be using with mySQL 5.0? Some type that accepts unicode. Jochem ~| Create robust enterprise, web RIAs. Upgrade to

Best data type for comments using MySQL?

2007-09-13 Thread Will Tomlinson
If I have user comments that could be 500-1000 characters, what datatype should I be using with mySQL 5.0? Thanks, Will ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today

RE: Best data type for comments using MySQL?

2007-09-13 Thread Andy Matthews
Medtext I think. -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 13, 2007 3:05 PM To: CF-Talk Subject: Best data type for comments using MySQL? If I have user comments that could be 500-1000 characters, what datatype should I be using

Re: Best data type for comments using MySQL?

2007-09-13 Thread Will Tomlinson
Medtext I think. Thanks andy! I was using longtext. Just making sure... Will ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now

RE: Best data type for comments using MySQL?

2007-09-13 Thread Andy Matthews
Med text allows for up to 65,535 characters so that should be plenty. Longtext allows for like millions. -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 13, 2007 3:32 PM To: CF-Talk Subject: Re: Best data type for comments using MySQL

Re: Best data type for comments using MySQL?

2007-09-13 Thread Will Tomlinson
Med text allows for up to 65,535 characters so that should be plenty. Longtext allows for like millions. Fixed it! Thanks dude! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and

RE: Best data type for comments using MySQL?

2007-09-13 Thread Andy Matthews
My pleasure -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 13, 2007 5:19 PM To: CF-Talk Subject: Re: Best data type for comments using MySQL? Med text allows for up to 65,535 characters so that should be plenty. Longtext allows for like

Re: Best data type for comments using MySQL?

2007-09-13 Thread Jim McAtee
, 2007 4:18 PM Subject: Re: Best data type for comments using MySQL? Med text allows for up to 65,535 characters so that should be plenty. Longtext allows for like millions. Fixed it! Thanks dude! ~| Check out the new