ORA-01756: quoted string not properly terminated问题
来源：互联网 发布：绿坝 知乎 编辑：程序博客网 时间：2024/06/07 06:28
当我执行某个升级脚本的时候，发现执行表声明语句"comment on column TICKET_MM_01.TICKET_ID is '清单序列号';"时出现ORA-01756: quoted string not properlyterminated的错误问题，左瞧右看都没发现该语句有什么问题。最后查询网上资料，发现可能和字符集有关系。
第一种解决办法，临时修改服务器的字符集环境变量，然后再执行sqlplus user/password@servicename ;@update.sql，修改环境字符集命令如下：
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
第二种解决办法，确认数据库字符集为什么，一般为UTF-8，那么在保存update.sql文件的时候，选择UTF-8格式进行保存。 最好在update.sql内容头里面加上以下命令方便定位问题：
spool update.log
set feedback off
set define off
- ORA-01756: quoted string not properly terminated问题
- ORA-01756: quoted string not properly terminated问题
- ORA-01756: quoted string not properly terminated问题
- ORA-01756: quoted string not properly terminated报错
- sqlplus插入中文字符集问题和ORA-01756 quoted string not properly terminated
- oracle的sqlplus中插入中文错误：ERROR: ORA-01756: quoted string not properly terminated
- quoted string not properly terminated错误提示
- sqlplus做sql查询，报错 quoted string not properly terminated
- jsp page 提示[page] is not properly terminated
- ORA-00933: SQL command not properly ended
- String literal is not properly closed by
- JSP中用include标签动态引入其它文件报错：attribute for %>" is not properly terminated
- jsp页面使用表达式<%=basePath%>跳转报“ attribute for %> is not properly terminated”错误
- RCP程序打包导出时乱码问题String literal is not properly closed by a double-quote
- String literal is not properly closed by adouble-quote
- String literal is not properly closed by a double-quote
- String literal is not properly closed by a double-quote
- ORA-00933: SQL 命令未正确结束 / ORA-00933: SQL command not properly ended
- Eclipse 安装插件(aptana、svn 、git、Java EE、JSHint)
- 使用Navicat for Oracle工具连接oracle
- 对大学的期望。
- 来谈谈企业实施PDM/PLM系统需要做些什么准备
- session 和 cookie 理解
- ORA-01756: quoted string not properly terminated问题
- 调用webservice学习备忘
- 删除ORACL连接用户
- Linux工具大全_bison
- 竞品分析的不同阶段
- Ubuntu 12.04 输入法托盘图标消失
- WINDOWS批处理命令详解
- ”淘宝客欺骗者“病毒手动清理
- ubuntu php服务器安装
