string sql = string.Format(@"SELECT A.TABLE_NAME 表名, A.COLUMN_NAME 字段名称, A.DATA_TYPE 字段类型, A.DATA_LENGTH 长度, A.NULLABLE 是否为空, A.DATA_DEFAULT 默认值, B.COMMENTS 注释 FROM USER_TAB_COLUMNS A, USER_COL_COMMENTS B WHERE A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME AND A.COLUMN_NAME = ‘{0}‘ ", fileid);
解决方法:
在加载程序时候加入以下代码:
System.Environment.SetEnvironmentVariable("NLS_LANG", "SIMPLIFIED CHINESE_CHINA.ZHS16GBK");
ORA-00911: invalid character SQL包含中文报错
原文:https://www.cnblogs.com/-hao/p/9191767.html