ORA-12704 character set mismatchCause: One of the following: The string operands (other than an NLSPARAMS argument) to an operator or built-in function do not have the same character set. An NLSPARAMS operand is not in the database character set. String data with character set other than the database character set is passed to a built-in function not expecting it. The second argument to CHR() or CSCONVERT() is not CHAR_CS or NCHAR_CS. A string expression in the VALUES clause of an INSERT statement, or the SET clause of an UPDATE statement, does not have the same character set as the column into which the value would be inserted. A value provided in a DEFAULT clause when creating a table does not have the same character set as declared for the column. An argument to a PL/SQL function does not conform to the character set requirements of the corresponding parameter. Action: Strings declared with NCHAR or NCHAR VARYING do not interoperate with strings declared with CHAR or VARCHAR2. Use TRANSLATE() function to explicitly convert one to the other.按照理解是说你可能建立表结构的时候设定的column类型有问题或者insert时
插入了不符合column 字符集的值。具体情况看你的表结构和insert语句
插入了不符合column 字符集的值。具体情况看你的表结构和insert语句
解决方案 »
- 繁體系統下的Oracle查詢簡體系統下的SQL數據庫,中文是亂碼(問號),如何解決?
- oracle字符集问题
- 数据库问题
- windows系统重新安装以后,以前的oracle数据如何恢复
- oracle 登陆问题
- oracle中Blob字段 32K 写入问题
- 请大家推荐一本面向开发者的oracle教程
- ORACLE 和MS-SQL里的语句如SELECT 的逻辑理念都不一样,大家举一下这方面的例子.
- 每个汉字在char/nchar/varchar2/nvarchar2中占几位
- 关于OID的一些基础不太明白的地方请教
- 高分求解——高手请进
- 一个用户如何才能访问另一个用户下的对象(比如SELECT * FROM USER1.TABLE1)?
ORA-12704: 字元設定不符合
具體錯在那裡還沒有找到.