buppcpp wrote:

> Which character set should I use if a wanted a case insensitive
> database that would only be available to the USA?
>
> Preferrably one that takes up the least amount of additional disk
> space.

Err... the good answer may have to wait for Firebird 2.0. There are
case insensitive collations for ISO8859-1 (that's the character set you
want, I suspect). The problem is integrating case insensitivity into
all the string comparisons and functions ... Peter Jacobi wrote
collations that are case insensitive, which might be a starting point.

The collation chosen has no effect on data representation - that's the
character set - and a case insensitive collation has no effect on index
size, as compared with a case sensitive but dictionary style collation.

Regards,


Ann