Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 9 of 9 total |
Select clause include " like '%keyword%' " didn't work when keyword is in Chinese Words (Ver 4.17 ) |
Sat, Nov 13 2010 11:14 PM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent 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 AM | Permanent 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). thanks fuxiaoyou Attachments: SQL_SearchStringPic.jpg |
Sun, Nov 14 2010 11:28 AM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent 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 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | fuxiaoyou
Remember you'll need the unicode version. Roy Lambert [Team Elevate] |
Sun, Nov 14 2010 1:29 PM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |