Escape apostrophe in H2

[Luigi Galati]

Hi all,
I have a SURNAME column in my H2 table and it contains some surnames with apostrophes.
I've read that in H2 the apostrophe escape is like in Oracle, so it is a double apostrophe, is it correct?
But this query doesn't work, it found 0 result but I have one surname like that:

SELECT * FROM T_CSV_I_TEMP WHERE SURNAME = 'D''Angelo'

Can you help me? thank you,

Luigi

[Noel Grandin]

there is this thing called "documentation"

http://h2database.com/html/grammar.html#string

​

[Luigi Galati]

Sorry,  but I didn't see this point.  The thing called "community" is made for this. ASAP I try it.

Thank you,
Luigi

Il sab 17 dic 2016 10:02 Noel Grandin <noelg...@gmail.com> ha scritto:

there is this thing called "documentation"

http://h2database.com/html/grammar.html#string

​

--
You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/AcGDKE4n-A4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.