ORA-12704: character set mismatch

by

you should do

select COALESCE (EMAIL, n'NO EMAIL') from crmuser.accounts

to convert the literal to NVARCHAR.

eg
http://sqlfiddle.com/#!4/73929/1
vs
http://sqlfiddle.com/#!4/73929/2

More Related Contents:

  1. Maximum Number of times we can query an oracle database [closed]
  2. How to uninstall / completely remove Oracle 11g (client)?
  3. Oracle trigger after insert or delete
  4. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  5. How to handle Day Light Saving in Oracle database
  6. What is the effect of placing the commit after DML in procedure?
  7. Auto Increment for Oracle
  8. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  9. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  10. Oracle Search all tables all columns for string [duplicate]
  11. NLS_NUMERIC_CHARACTERS setting for decimal
  12. creating parameterized views in oracle11g
  13. Create Pivot view in SQL from a SQL table
  14. How to create a user in Oracle 11g and grant permissions
  15. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  16. Trigger to enforce M-M relationship
  17. How can I describe a table in Oracle without using the DESCRIBE command?
  18. Functions vs procedures in Oracle
  19. How to insert a column in a specific position in oracle without dropping and recreating the table?
  20. Get the number of days between two dates in Oracle, inclusive of the dates
  21. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  22. passing in table name as plsql parameter
  23. How to use parameters in a ‘where value in…’ clause?
  24. Why cannot I create triggers on objects owned by SYS?
  25. No more data to read from socket
  26. return resultset from function
  27. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  28. ORA-30926: unable to get a stable set of rows in the source tables
  29. Oracle insert if not exists statement
  30. Error : ORA-01704: string literal too long

Leave a Comment