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.
select 'Clerk1' as Clerk_Name from TBL1
union
select distinct Clerk_Name from TBL1
order by Clerk_Name;
Thanks.
Oracle DatabaseSQL
Last Comment
Peter Anzenberger
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Use the CAST I posted and the select from DUAL dsacker posted.
Make sure you read what I posted about the ORDER BY.
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.
*
ERROR at line 1:
ORA-12704: character set mismatch
Clerk_Name: NVARCHAR2(50)