Subject Re: [firebird-support] Re: Performance Penalty for String Joins?
Author Helen Borrie
At 05:05 AM 9/03/2004 +0000, you wrote:
>I'm in the habit (maybe a bad one) of just using VARCHAR. What is the
>advantage to CHAR?

For fixed-length data, it's more compact. Since the length f/l data is
known, it doesn't have to be stored with the data - that's what char is for.

Varchar works OK, and it might actually be more useful, e.g. where codes
from different barcode systems are being read into the same column
(sometimes a requirement). I've certainly worked with more than one setup
where the barcode is a varchar (30) and there is a second column that
carries a code identifying which barcode system it belongs to--with a
unique constraint on the two.