Escape ' in sql file

General Discussion
1

Hello,

I use 

<sqlFile

            encoding=“utf8”

            path="${sql.files.path}/TRANSLATION_VALUE_SHORT_DE.sql"

            relativeToChangelogFile=“true”

            splitStatements=“true”

            stripComments=“true”/>

 

to call a sql.

In my sql file, I have : 

UPDATE TRANSLATE SET TRANSLATEDVALUE = q’{toto_DE}’ WHERE ATTRVALUE = q’{Roue entraineuse de l’indicateur 24H}’ AND USAGE = ‘PLM’ AND LANG = ‘DE’;

So I use q’{}’ as sql to escape '. (I have 4 sql file of 26 000 lines)

But I have an error : ORA-00933: SQL command not properly ended

Thanks for your help,

Mathiue