Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread Select clause include " like '%keyword%' " didn't work when keyword is in Chinese Words (Ver 4.17 )
Sat, Nov 13 2010 11:14 PMPermanent Link

fuxiaoyou

I do some test in Delphi 7 using DBISAM ver 4.17, what ever the database's field is in string or text, when make sql search with the clause "like '%keyword%' " , the result will return too more while the keyword in in chinese words.
Sun, Nov 14 2010 3:59 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

fuxiaoyou


>I do some test in Delphi 7 using DBISAM ver 4.17, what ever the database's field is in string or text, when make sql search with the clause "like '%keyword%' " , the result will return too more while the keyword in in chinese words.

Can you give some examples. DBISAM isn't unicode and my guess is you're trying to do a unicode comparison.

Roy Lambert [Team Elevate]
Sun, Nov 14 2010 10:55 AMPermanent Link

fuxiaoyou

Roy Lambert wrote:

fuxiaoyou


>I do some test in Delphi 7 using DBISAM ver 4.17, what ever the database's field is in string or text, when make sql search with the clause "like '%keyword%' " , the result will return too more while the keyword in in chinese words.

Can you give some examples. DBISAM isn't unicode and my guess is you're trying to do a unicode comparison.

Roy Lambert [Team Elevate]


Roy Lambert
Dear Sir
How are you, thank you for your quickly response.

There is a test data called informatin in attachment, you can test the search result as the following strings:

test 1, searching field in text style:
------------------------------------------------------
select *  from information where memo like  '%扇形%'

test 2, searching field in string style:
------------------------------------------------------
select *  from information where TypeThreeName like '%松科%'

thanks
fuxiaoyou



Attachments: information.rar
Sun, Nov 14 2010 11:08 AMPermanent Link

fuxiaoyou

fuxiaoyou wrote:

Roy Lambert wrote:

fuxiaoyou


>I do some test in Delphi 7 using DBISAM ver 4.17, what ever the database's field is in string or text, when make sql search with the clause "like '%keyword%' " , the result will return too more while the keyword in in chinese words.

Can you give some examples. DBISAM isn't unicode and my guess is you're trying to do a unicode comparison.

Roy Lambert [Team Elevate]


Roy Lambert
Dear Sir
How are you, thank you for your quickly response.

Since your website do not support chinese (GBK or GB2312), the search string became other code, but I wrote the searching string in a txt file, and with this Attachment, I send a string in picture mode (.jpg). Smile

thanks
fuxiaoyou



Attachments: SQL_SearchStringPic.jpg
Sun, Nov 14 2010 11:28 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

fuxiaoyou


As I suggested it looks like you're trying to use unicode data in a non-unicode database. Unless Tim corrects me I don't think DBISAM can handle that. You need to move to ElevateDB which does handle unicode.

Roy Lambert[Team Elevate]
Sun, Nov 14 2010 12:41 PMPermanent Link

fuxiaoyou

Roy Lambert wrote:

fuxiaoyou


As I suggested it looks like you're trying to use unicode data in a non-unicode database. Unless Tim corrects me I don't think DBISAM can handle that. You need to move to ElevateDB which does handle unicode.

Roy Lambert[Team Elevate]

Ok

Your reply made me hopeless on DBISAM for Chinese charac usage, and have hope on your ElevateDB.

Thank you Roy Lambert for your support on my Q. You are so Dedicated.

fuxiaoyou
Sun, Nov 14 2010 1:11 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

fuxiaoyou


Remember you'll need the unicode version.

Roy Lambert [Team Elevate]
Sun, Nov 14 2010 1:29 PMPermanent Link

fuxiaoyou

Roy Lambert wrote:

fuxiaoyou


Remember you'll need the unicode version.

Roy Lambert [Team Elevate]


Yeah, I've remembered.

I'm studing and testing elevateDB (unicode support) for my future use.

Thank you
fuxiaoyou
Tue, Nov 16 2010 8:54 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

fuxiaoyou,

<< I do some test in Delphi 7 using DBISAM ver 4.17, what ever the
database's field is in string or text, when make sql search with the clause
"like '%keyword%' " , the result will return too more while the keyword in
in chinese words. >>

Which two rows are being returned that shouldn't be ?  The LIKE operator in
4.x should work fine with MBCS strings like Japanese or Chinese, and has
specific code for handling multi-byte character comparisons.

BTW, I noticed that the DBSYS query result set window doesn't display the
result set rows using the proper character set.  This is now fixed in 4.30.

--
Tim Young
Elevate Software
www.elevatesoft.com
Image