Escape character in JPQL

Question

In JPQL what is escape character we can use to escape characters such as "'"?

Ex : I am doing something like

...where person.name='Andy'

Here it is working fine

but when the person's name is Andy's then the where clause becomes like

...where person.name='Andy's'

and it returns an error saying

Answer 1

It cannot figure out where string literal ends. Solution is nicely told in specification:

A string literal that includes a single quote is represented by two single quotes—for example: ‘literal’’s’.

In your case means:

...where person.name='Andy''s'