Re: [firebird-support] Computed index for case insensitive queries

2014-08-25 Thread Alexandre Benson Smith ibl...@thorsoftware.com.br [firebird-support]
Em 25/8/2014 00:59, Caroline Beltran caroline.d.belt...@gmail.com [firebird-support] escreveu: Mark, thank you for responding. I ended up downloading FlameRobin and it does show computed indexes in the 'Index' tab as well as in the DDL, i.e.: CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY

Re: [firebird-support] Computed index for case insensitive queries

2014-08-25 Thread Caroline Beltran caroline.d.belt...@gmail.com [firebird-support]
Alexandre, thank you for suggesting! I am thinking of using the ISO8859_1 characterset and ES_ES_CI_AI collation. Since I need support for English and Spanish, would this collation be the best option for case/accent insensitive searching? Thanks Again!