This discussion is archived
4 Replies Latest reply: Apr 20, 2013 3:52 PM by Pleiadian RSS

Getting “ORA-01482: unsupported character set” when using WHERE IN pattern

Mikail Newbie
Currently Being Moderated
I have a table with the following structure in Oracle database:

CREATE TABLE PASSENGERS
*(ID VARCHAR2(6),*
PASSPORTNO VARCHAR2(14));

I want to get the IDs of the passengers who have been registered more than once. For that I run the following query.

SELECT ID FROM PASSENGERS WHERE PASSPORTNO IN
*(SELECT PASSPORTNO FROM PASSENGERS*
GROUP BY PASSPORTNO
HAVING COUNT()>1);*

But I get "unsuported character set" error. If I try to run the following queries separately I don't get any error:

SELECT PASSPORTNO FROM PASSENGERS
GROUP BY PASSPORTNO
HAVING COUNT()>1;*


SELECT COUNT(PASSPORTNO) FRO PASSENGERS;

SELECT ID FROM PASSENGERS;

What's the point I'm missing?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points