Thanks Mark,
I saw those collations, but they are for Spanish, French and Portugese.
All but a very small part of my DB will be in US-EN.
I added a column to a table with charset ISO8859_1 and collation ES_ES_CI_AI.
Indeed it was case insensitive for what I tried, however I'm not
On 8-12-2015 20:58, r...@seedsbydesign.com [firebird-support] wrote:
> 1. Is only one byte used for storage for english and spanish?
No, only for plain ASCII, and ñ is not in ASCII. IIRC ñ will take two bytes.
> 2. Is there any CI + AI collation for ISO8859_1?
Yes there are. See
I've used FB for years with ISO8859_1 charset and collation.
Now I designing a new DB for a big app update in FB3 and wonder about this
charset and collation. My goal is to avoid having to UPPER everything for
comparison searches.
For test purposes I am using UTF8 and UNICODE_AI_CI and I
Guten Tag r...@seedsbydesign.com [firebird-support],
> Here are my questions:
> 1. Is only one byte used for storage for english and spanish?
NO plain englisch will still be one Byte but spanisch (the accented n ) will
be multiple bytes
> 3. Is there any downside to using UTF8 and