| Subject | Re: [firebird-support] Charsets and searching |
|---|---|
| Author | Helen Borrie |
| Post date | 2007-04-07T23:55:17Z |
At 09:28 AM 8/04/2007, you wrote:
for the 26 ASCII alphabetic character pairs. To do case-insensitive
searching even on these pairs you need to coerce the search using UPPER()
collation for Spanish. For case-insensitive searching you need an
index on the searched column that includes a case-insensitive
collation in its attributes. A collation applies to a specific
character set, i.e. you can't, for example, apply a case-insensitive
collation for Spanish to charset NONE.
You can't "switch" to another character set. There's a bit more to
it than that. ;-)
./heLen
>I have always chose "NONE" as my default Charset when creatingNo. NONE has no knowledge of upper-lower case mappings other than
>Interbase/Firebird databases. Is it possible to do case insensitive
>searches?
for the 26 ASCII alphabetic character pairs. To do case-insensitive
searching even on these pairs you need to coerce the search using UPPER()
>Must I switch to a character set to make this happen? MyYou need both a character set AND at least one locale-specific
>applications are for English and Spanish users.
collation for Spanish. For case-insensitive searching you need an
index on the searched column that includes a case-insensitive
collation in its attributes. A collation applies to a specific
character set, i.e. you can't, for example, apply a case-insensitive
collation for Spanish to charset NONE.
You can't "switch" to another character set. There's a bit more to
it than that. ;-)
> I am developingWhat version of Firebird?
>client apps with Delphi on Win32 and PHP for Win32 and Linux servers.
./heLen