ORA-12704: character set mismatch

ORA-12704: character set mismatch
Cause: 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: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12704：字符集不匹配,
.原因：以下之一：,
.- 操作符或内置函数的字符串操作数（除了nlsparams参数）不具有相同的字符集。,
.,
.- nlsparams操作数不在数据库字符集中。,
.,
.- 带有字符集而不是数据库字符集的字符串数据被传递给不需要它的内置函数。,
.,
.- CHR（）或CSCONVERT（）的第二个参数不是CHAR_CS或NCHAR_CS。,
.,
.- INSERT语句的VALUES子句中的字符串表达式，或UPDATE语句的SET子句，不具有与要插入值的列相同的字符集。,
.,
.- 创建表时在DEFAULT子句中提供的值的列不具有与为列声明的字符集相同的字符集。,
.,
.- PL / SQL函数的参数不符合相应参数的字符集要求。,
.,
.操作：无,
.

aiaiDBA

13718043309

010-86462881

ORA-12704: character set mismatch

1 个回答

相似问题