Subject Re: FB2.1 Case-insensitive searching options
Author tomc7777777
--- In, Philippe Makowski
<makowski@...> wrote:
> tomc7777777 [08-12-30 12.15] :
> >> "Anyone with any tips or recent experience with the above"
> >> "(proven in the field) would be much appreciated:"
> >
> > It appears there is (virtually) no-one...
> >
> don't you read my previous post ?
> use collation


Yes, the response was read, hence the use of the word 'virtually' in
the previous sentence.

The original post asked 3 questions. The second, which you kindly
responded to, was: "2. (Pre-FB 2.5) Any character set/collations
combinations that can ***easily*** be set to get over this need?"

The answer appears to be No.

'... easily be set' doesn't entail column by column declarations and
computed by indexes with collate keywords. Plus 2 of the 3 subsequent
questions were unanswered or unclear, especially what to do with
existing data/FB1.5 database.

The main question that I was looking to have answered was the first:
"Anyone with any tips or recent experience with the above (*** proven
in the field***) would be much appreciated:
1. Can we drop all upper_x columns and now use expressions indices?"