Subject Re: [firebird-support] Spanish collations
Author Mario Lacunza
El mar, 05-12-2006 a las 18:06 +0000, stevenggibb escribió:
> 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

When you create the tables use the COLLATE ES_Es command?

And I use utf8 like charset.

Mario Lacunza <mario_lacunza@...>

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y m�viles desde 1 c�ntimo por minuto.