[Firebird-devel] [ firebird-Bugs-1121246 ] Like operation can not get the valid result set

[SourceForge.net <no...@so...>]

Bugs item #1121246, was opened at 2005-02-12 05:20
Message generated for change (Settings changed) made by asfernandes
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1121246&group_id=9028

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Charsets/Collations 
>Group: Irreproducible Bug
>Status: Deleted
>Resolution: Rejected
Priority: 5
Submitted By: Mario Hsu (vip88_688)
Assigned to: Adriano dos Santos Fernandes (asfernandes)
Summary: Like operation can not get the valid result set

Initial Comment:
I try the flowing command,

select * from mytables where textfield like '%瑞王%' or
textfield like '瑞王%' or textfield like '%瑞王'

firebird return no result set but it does exist.
(charset is Unicode_FSS)

Another problem is the code confliction.  Charset is 
BIG5，the sql command is below:

select * from mytables where thefield like '%天%' or
thefield like '%天' or thefield like '天%'

firebird did return the result set but not valid.  The rows 
contains '中晟' to be listed in the result set because of

天, code in BIG5 is  A4 D1
中晟, code in BIG5 is A4 A4 D1 D4

Though A4 D1 is in the set but bot valid.  Help me 
please.

Thanka a lot.

Best regard, Mario Hsu
gv...@gm...
2005-02-12 15:21


----------------------------------------------------------------------

Comment By: Adriano dos Santos Fernandes (asfernandes)
Date: 2005-05-22 11:59

Message:
Logged In: YES 
user_id=940451

I can't reproduce your problem.

It appear you missed to set the character set of test.name
to big5.
Creating the database with default character set big5 or
defining test.name with character set big5 works ok for me
in 1.5 and 2.0.

And I can't decipher the problem with unicode_fss because
you had only uploaded description of big5 problem.


----------------------------------------------------------------------

Comment By: Adriano dos Santos Fernandes (asfernandes)
Date: 2005-05-22 11:59

Message:
Logged In: YES 
user_id=940451

'Irreproducible' tracker entries are closed with Status = 'Deleted' 
and Resolution = 'Rejected'

----------------------------------------------------------------------

Comment By: Mario Hsu (vip88_688)
Date: 2005-02-14 03:05

Message:
Logged In: YES 
user_id=926446

Use uploaded files, please.

Thank you very much. ^-^

----------------------------------------------------------------------

Comment By: Adriano dos Santos Fernandes (asfernandes)
Date: 2005-02-12 13:01

Message:
Logged In: YES 
user_id=940451

Please attach a file with the description because
international characters are unreadable.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1121246&group_id=9028