Hello, at the moment I am using MS Access and MS SQLserver as Databases (development and production). Since H2 seems to be much better than Access and other (java) databases, I would like to use H2 interchangeable for MS Access and SQLserver. I am using "LIKE" clauses without "ESCAPE" keywords, and Access and SQLserver do not have default escape characters so I have not dealt with escape characters. Yet H2 has the default character "\", which will generate an SQLException, if used in the like pattern without escaping itself. I have looked for a way to disable the default escape character: The following databases do not have a default escape character:
mssqlserver: http://msdn.microsoft.com/en-us/library/aa933232(SQL.80).aspx hsqldb: http://hsqldb.org/doc/guide/ch09.html derby: http://db.apache.org/derby/docs/dev/ref/ref-single.html#rrefsqlj23075 db2: http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0000751.htm oracle: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/conditions007.htm#i1034153 So I tried the H2 Compatibility Modes for these DBs (e.g. ;MODE=DB2 ) in the connection string, but I had no success in disabling the default escape char. Is there another connection parameter I could use to disable the default escape char? .. Or could such connection parameter provided? Thanks. Best Regards Charly --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
