Ora-01756:quoted string not properly terminated problem

Ora-01756:quoted string not properly terminated problem when I execute an upgrade script, I find the Execute Table declaration statement "Comment on column ticket_mm_01.ticket_id Is ' list serial number '; A ora-01756:quoted string not properlyterminated error occurs, and the left-right look does not find any problem with the statement.      The last query on the online data, found that may have a relationship with the character set. The first solution is to temporarily modify the server's character set environment variable and then execute Sqlplus user/password@servicename; @update. sql, modify the Environment character set command as follows: Export Nls_lang=american_ AMERICA.  ZHS16GBK the second solution, to confirm the database character set why, generally UTF-8, then save the Update.sql file, select the UTF-8 format to save. It is best to add the following command to the Update.sql content header to facilitate locating the problem: Set feedback off set define off
Original: http://www.2cto.com/database/201310/253705.html