Serious problem with SQLite(DataSource)
Publicado: Dom Ago 26, 2007 2:50 pm
Running the following query on the Customers table (from the Xailer SQLite
sample db) results in emty dataset:
SELECT * FROM customer WHERE state = 'ME'
However, when changing the WHERE clause to "WHERE state LIKE 'ME'" or "WHERE
state LIKE 'ME%'" the result set is NOT empty (as expected).
I also have a problem when using something like WHERE state <= "ME"
NO PROBLEM if the field is a numerical field.
Regards,
Stephan
sample db) results in emty dataset:
SELECT * FROM customer WHERE state = 'ME'
However, when changing the WHERE clause to "WHERE state LIKE 'ME'" or "WHERE
state LIKE 'ME%'" the result set is NOT empty (as expected).
I also have a problem when using something like WHERE state <= "ME"
NO PROBLEM if the field is a numerical field.
Regards,
Stephan