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 ' manifest serial number ';" ora-01756:quoted string not properlyterminated error, left look to the right to see what is wrong with the statement. Finally, query the online information, found that it may be related to the character set.

The first workaround is to temporarily modify the server's character set environment variable before executing sqlplus user/password@servicename; @update. sql, modify the Environment character set command as follows:

Export Nls_lang=american_america. Zhs16gbk

The second solution, confirm the database character set why, generally is UTF-8, then when saving Update.sql file, choose UTF-8 format to save. It is best to add the following command to the Update.sql content header to conveniently locate the problem:

Spool Update.log
Set Feedback off
Set Define Off