List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 1 2001 5:54pm
Subject:Re: Re: Truncated data on spaces..?
View as plain text  
>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.
Thread
Re: Re: Truncated data on spaces..?Paul DuBois1 Nov