I've found after using a CMP J2EE entity bean, along with the 7.1.3 jdbc
driver, queries return the entire char field back while using char(), but
varchar returns just the value of the field back.
for example,
create table test_table(
id integer primary key not null,
name varchar(255)
);
vs.
Hmm.. ok.
Just I usually prefer using fixed field lengths as queries tend to be
significantly faster. Also, you can use them in indexes.
I find it strange that that would be the case...
And it leads me to wonder how you would represent an ending space in a
field,
for example
insert into
Well, that's how it works in the postgres documentation... I could have
sworn that I've never encountered this in other databases.. Must have a bad
memory.
Guess I'll just trim everything.
-Jeff
Hmm.. ok.
Just I usually prefer using fixed field lengths as queries tend to be
significantly