A string literal is enclosed in single quotes:
’Duke’
If a string literal contains a single quote, you indicate the quote by using two single quotes:
’Duke’’s’
Like a Java String, a string literal in the query language uses the Unicode character encoding.