Avatar

Correct answer by
Employee

HI Daeho,

You can also check character set in both databases.

Database

As mentioned in the link shared by Ananya , this issue could be

  • 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.

Also you can enable to sql log and see what actual query is being generated when you perform update and how it is different from the query which is there in Java script.

View solution in original post