Re: select a varchar(2048) field, but it show only first 255 characters
| From: | Pierre-Alain Joye | Date: | Thu, 26 Jun 2003 13:56:22 +0000 |
| Subject: | Re: select a varchar(2048) field, but it show only first 255 characters | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-17754@lists.php.net to get a copy of this message | ||
On Thu, 26 Jun 2003 15:38:31 +0200
"Roberto Balet" <roberto.balet@onstage.ch> wrote:
> hello
> i do my db connections with pear. if i want do a select statement for
> example:
> name is varchar(2048)
char, respectively varchar are usually limited to 255 chars. Even if
your DB supports more, I suggest to use text in preference to
char(2048). As most of DBs does not support more than 255, you will run
in trouble if you have to port your app.
pierre