Link to home
Create AccountLog in
Avatar of mrong
mrong

asked on

character set mismatch in Oracle

I got "ORA-12704: character set mismatch" error with the following query in Oracle. Any suggestions?

select 'Clerk1' as Clerk_Name from TBL1
union
select distinct Clerk_Name from TBL1
order by Clerk_Name;


Thanks.
SOLUTION
Avatar of dsacker
dsacker
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of mrong
mrong

ASKER

select 'Clerk1' as Clerk_Name      
          *
ERROR at line 1:
ORA-12704: character set mismatch

Clerk_Name: NVARCHAR2(50)
Use the CAST I posted and the select from DUAL dsacker posted.

Make sure you read what I posted about the ORDER BY.
Thank you for your example. It helped a colleague of mine a lot. He went home with a happy smile on his face.