|Subject||Re: [ib-support] Re: where FIELD1 LIKE '%ç§¢ >|
> At 07:42 AM 13-12-02 +0000, you wrote:Hi Helen,
>>Any update in this area?
> For the LIKE predicate you have to have the '%' wildcard character in there
> somewhere - before or after the search string, or both.
> I didn't see the original posting but I wonder if you tried this:
> select * from table1 where field1 like _UNICODE_FSS'%ç¥§'
> This won't be valid if field1 is not a unicode_fss column though.
The problem was that when using special characters (é, ç, etc...) and
the field is UNICODE_FSS, Firebird seems to be working in overtime and
the CPU resources jumps to 100% and stays there until you do a forced
shutdown. I can reproduce the problem easily and posted it in the bug
tracker. I use UNICODE_FSS in one of my databases and if I try to to
perform a "SELECT * FROM CLIENTS WHERE FIRSTNAME LIKE 'é%'", the
server's CPU process goes to 100% and stays there(I wouldn't know for
how long, since I kill the server after waiting for 30 minutes). And,
in my test database, I only have 20,000 records. And, if I use a
normal english character, the query returns a result instantly.
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)