Go sqlplus Execute SQL error: ORA-01756:

1.sqlplus Execute SQL Error: ora-01756:quoted string not properly terminated

Category: Technology

An error occurred while executing the SQL file in Sqlplus: ora-01756:quoted string not properly terminated but SQL is not a problem, looking for many reasons, may be due to use Toad Export SQL ins            The problem with the ERT statement, the encoding set, is caused. First, add an environment variable in the. bash_profile file to specify the encoding set:Export Nls_lang=american_america.al32utf8But that's not going to work. WORKAROUND: Use a text editor like notepad++ to convert the encoding of the SQL file toUTF-8 No BOM encoding formatThe result is no problem when you try it. 2.bom:byte Order Mark
UTF-8 BOM is also called UTF-8 signature, in fact, UTF-8 BOM to UFT-8 has no effect, is to support utf-16,utf-32 to add the Bom,bom signature means to tell the editor what encoding the current file, convenient editor identification, But although the BOM does not appear in the editor, it produces output, like a blank line, 3.

PHP file Encoding format is UTF-8, and is no BOM format, if you write PHP file with the wrong code, then the output, especially Chinese will appear garbled. Windows comes with a Notepad by default ANSI encoding format, while saving can be changed to UTF-8 encoding, but not without BOM format, is not output correctly.

WordPress in writing the theme and plug-in PHP code files, it is necessary to follow this rule, the Professional code Editor can solve the coding problem.

When writing PHP files with notepad++, first set the charset correctly by clicking the menu "format → UTF-8 no BOM encoding". After the setup is complete, edit the code and automatically set to UTF-8 without BOM encoding when saving. You can open this file later without setting it again.

Go sqlplus Execute SQL error: ORA-01756: