Subject | Re: FB2.1 Case-insensitive searching options |
---|---|
Author | tomc7777777 |
Post date | 2008-12-30T09:40:32Z |
---------------------------------------------------------------------
> We are moving to FB2.1 and were wondering on the new optionsavailable
> to us regarding the above. We especially want to get rid of havingto
> have 'shadow upper_fieldname columns' maintained by triggers for---------------------------------------------------------------------
> searchable
> columns.
>
> Anyone with any tips or recent experience with the above (proven in
> the field) would be much appreciated:
>
> Q's:
> 1. Can we drop all upper_x columns and now use expressions indices?
> 2. (Pre-FB 2.5) Any character set/collations combinations that can
> easily be set to get over this need?
> 3. A.n.other technique?
>
> p.s. all data is straight-forward ascii text (locale: GB/UK English)
> "Anyone with any tips or recent experience with the above"It appears there is (virtually) no-one...
> "(proven in the field) would be much appreciated:"