Non-standard patterns in LIKE patterns prohibits use in DBMS-independent systems
A pure Java JDBC driver for Microsoft Access database files
Brought to you by:
jamadei
Menu
▾
▴
Hi,
I work on a system that interfaces to a number of DBMSs including SQL-Server, Oracle, MySQL and Access. The current Access JDBC driver (Jadozoom), which we are hoping to get rid of, just accepts standard % and _ wildcards in LIKE patterns. UCanAccess accepts these but also accepts * and ?. Unfortunately, this will break our system (as, in fact would the use of # for numbers).
I can't see a situation where it would be desirable to accept both kinds of wildcard; would it be possible to implement a switch as a parameter in the jdbc connection string?
Cheers,
Mick.