Truncated data on spaces..?

2001-11-01 Thread Gil G.
Hello, Does the data stored in a VARCHAR field get truncated on spaces? All my fields contain the data up to the first space... What should I use ? Thanks a lot, sincerely, Gil. [ PHP 4.01, MySQL 3.23, FreeBSD 4.2 ] -- PGP public key at: keskydee.com/gil.asc ICQ: 3310801

Re: Re: Truncated data on spaces..?

2001-11-01 Thread Paul DuBois
database,sql,query,table At 12:29 PM -0500 11/1/01, Gil G. wrote: Hello, Does the data stored in a VARCHAR field get truncated on spaces? Trailing spaces, yes. All my fields contain the data up to the first space... What should I use ? One of the TEXT types. Thanks a lot, sincerely, Gil.