|
From: SourceForge.net <no...@so...> - 2005-05-22 15:02:29
|
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 |