At 04:30 AM 2/14/99 +0000, Thomas G. Lockhart wrote:
>> You want a varchar (or is it bpchar?), not a char. char(x) will always
>> return x characters, with space padding if necessary.
>
>"bpchar" == "blank padded char", which is what char() is mapped to
>internally. As Matthew has already learned, he probably really wants to
>be using varchar(), or fix it up with trim().
>
> - Tom
Yeah, but the docs say you get a performance hit for using varchar, text,
and the like. Which is worse, the database performance hit or the extra
call to trim for every char field?
Matthew