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.
select 'Clerk1' as Clerk_Name from TBL1
union
select distinct Clerk_Name from TBL1
order by Clerk_Name;
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
*
ERROR at line 1:
ORA-12704: character set mismatch
Clerk_Name: NVARCHAR2(50)