Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT Paradox
LIKE behaviour
Juan D��az
2010-12-10 08:51:53.0
I would expect that the statement
"SELECT * FROM table WHERE field LIKE "%value%";
would retrieve all records containing 'value' or 'Value' inside the given field.
This is not working using driver version 2010-nov-18.
Could this be fixed?

In the same direction, a more powerful search when dealing, for example, with Latin American accents ('��', '��', '��', '��', '��', etc.) would be ideal. So, an statement like this:

"SELECT * FROM table WHERE field LIKE "%Nom%";
would retrieve all records containing 'Nom', 'Nombre', and also 'N��mina'

could this be added?

Regards.
Re:LIKE behaviour
HXTT Support
2010-12-10 09:03:03.0
>"SELECT * FROM table WHERE field LIKE "%value%";
>would retrieve all records containing 'value' or 'Value' inside the given field.
Please use ILIKE.

>In the same direction, a more powerful search when dealing, for example, with >Latin American accents ('��', '��', '��', '��', '��', etc.) would be ideal. So, an
>statement like this:
>"SELECT * FROM table WHERE field LIKE "%Nom%";
>would retrieve all records containing 'Nom', 'Nombre', and also 'N��mina'
SELECT * FROM table WHERE field LIKE "%N[o��]m%"

Re:LIKE behaviour
Juan D��az
2011-01-06 06:44:21.0
Thanks, this solves the issue with accented charaters.

Another situation that is confusing is that the LIKE '%someWord%' returns different results from 'someWord%'. I expect both to return records where the value of the field is exactly 'someWord', but LIKE '%someWork%' misses those records.

In other words, the first % on the LIKE '%someWord%' statement does not include the case for nothing. Could this be fixed on the driver?
Re:Re:Re:LIKE behaviour
HXTT Support
2011-01-06 06:54:25.0
>LIKE '%someWord%'
AsomeWordB will match. someWord and someWordB will match too.

>Like 'someWord%'.
AsomeWordB will fail. someWord and someWordB will match.
Re:Re:Re:Re:Re:LIKE behaviour
HXTT Support
2011-01-06 08:58:31.0
Checked.
select 'someWord' like '%someWord%' ;

will return true;
Re:LIKE behaviour
Juan D��az
2011-01-06 09:18:28.0
My point is that I have found instances where LIKE '%word' behaves different.

For example, I have a table where there are records with the value "COMPRAS\n" (yes a new line char at the end, maybe this is the root of the issue?) in a field, and the following statement

SELECT * FROM table WHERE field LIKE '%compras%';

won't return those records.

If you want need a copy of the database to fix this issue please let me know.
Re:Re:Re:Re:Re:Re:Re:LIKE behaviour
HXTT Support
2011-01-06 09:26:24.0
Please sent it to support @ hxtt.com
Re:LIKE behaviour
Juan D��az
2011-01-07 07:07:26.0
I am noticing that the issue is that the LIKE search is case sensitive. Shouldn't it be insensitive? This is the way it works under MS Access, MySQL, etc.

This is why LIKE '%compras%' won't return a record with the value 'COMPRAS' and so on.

I await for your solution.

Thanks
Re:Re:Re:Re:Re:Re:Re:Re:LIKE behaviour
HXTT Support
2011-01-07 07:08:46.0
>This is the way it works under MS Access, MySQL, etc.
SELECT * FROM table WHERE field ILIKE '%compras%';

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap