Re: char vs. varchar

Posted in 2000

Rudy Fernandes — Wed, 05 Apr 2000 13:02:41 -0400 — source: Informix-list mailing list archive (1991-1998)

Red Valsen wrote: > My Java developers have been struggling mightily against character type > columns. They have been carping about the need to trim, in one way or > another, trailing blanks from all manner of values they pull from Struggling mightily? char_paramField.setText(queryResults.getString("char_param")); has to change to // trim() removes leading & trailing blanks char_paramField.setText((queryResults.getString("char_param")).trim()); Tell them that it should be a programming standard (akin to using getInt to retrieve Integers) > > tables. Why can't all those nasty fixed length columns be > varchar(255)? Arguments of higher overhead and storage requirements > didn't satisfy. Sure, they can. But what about the char(256) & longer? Rudy