Subject Spanish collations
Author stevenggibb
Can someone point me to information about the specifics of various
Charset and Collate behaviors for a Firebird 1.5 or 2.0 database? I
have a Delphi 5 application accessing a Firebird 1.5 database with a
column storing Spanish words. When I use Charset DOS850 and Collate
DB_ESP850, the result is that all accented letters sort below the
entire alphabet of non-accented letters except for the accented letter
"รณ" which sorts before the alphabet of non-accented letters. When I
try other charsets and collations listed for spanish, the application
crashes with an overflow error. I would like the collation to sort
each accented letter next to the same unaccented letter or ignore the
accent.

Steven