Subject | Re: FB2.1 Case-insensitive searching options |
---|---|
Author | tomc7777777 |
Post date | 2008-12-27T19:06:10Z |
--- Philippe Makowski <makowski@...> wrote:
existing an FB1.5 to FB2.1 db?
i.e.
1. Does it need every searchable column to have the COLLATE ISO8859_1
appended to the definition?
2. What is the situation with the existing db - do we have to dump and
pump?
3. Indexes. Do we simply define as usual or do we need any magic
COLLATE keywords?
Thanks,
Tom
> 2. (Pre-FB 2.5) Any character set/collations combinations that canPhillipe, apologies for my ignorance but what does this mean for
> easily be set to get over this need?
> you have CI collations for ISO8859_1 and for UFT8
existing an FB1.5 to FB2.1 db?
i.e.
1. Does it need every searchable column to have the COLLATE ISO8859_1
appended to the definition?
2. What is the situation with the existing db - do we have to dump and
pump?
3. Indexes. Do we simply define as usual or do we need any magic
COLLATE keywords?
Thanks,
Tom