RE: [h2] CSV WRITE

Try: (note the extra ‘ chars added in yellow) CALL CSVWRITE ( '/home/gb/carrier.csv', 'SELECT NAME FROM CARRIER WHERE NAME = ''what ever you want''', 'fieldSeparator=;' ) That is add an extra ' Is you have quote string inside a quoted string… (escaping the quote char) So if I

[h2] CSV WRITE

I'm trying use CSVWRITE with quote inside query, but i can not get it CALL CSVWRITE ( '/home/gb/carrier.csv', 'SELECT NAME FROM CARRIER WHERE NAME = 'what ever you want'', 'fieldSeparator=;' ) [Exception, Error code 42.001, SQLState 42001] Error de Sintaxis en sentencia SQL Also

[h2] change encrypt password

Hi, i want to change the database encryption within my java application. ChangeFileEncryption.execute(getDbPath(dbname).toString(), dbname, "AES", filepwdold.toCharArray(), filepwdnew.toCharArray(), true); it silently executed, i mean didn't get any exception, or so but next time when i try

[h2] Re: Recent drops in performance

Hello. Could you build a standalone test case that can be used to reproduce such slowdown? I don't see any reasons for it. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send