oraclle字符问题

ironceo

于 2021-09-23 23:59:19 发布

阅读量92

点赞数

文章标签： sql 数据库 mysql

本文链接：https://blog.csdn.net/ironceo/article/details/120445774

版权

SQL> COMMENT ON COLUMN DATA_LOG.ATTRTYPE IS '属性类型';
ERROR:
ORA-01756: quoted string not properly terminated
ERROR:
ORA-01756: quoted string not properly terminated

SQL> 
SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

/*终端要设置为和数据库字符一样。如果SecureCRT  在会话选项-外观设置为default或者gbk*/


SQL> COMMENT ON COLUMN DATA_LOG.ATTRTYPE IS '属性类型';
Comment created.![配置如下](https://img-blog.csdnimg.cn/c2216f81e5c84c37a40a728529ceb959.JPG?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBAaXJvbmNlbw==,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center)