some unicode problem

From: Johan Eriksson <valpis@xxxxxxxxx>
To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 23 Mar 2009 15:39:43 +0100

Hi

I am facing a problem here I just can't figure out.

The database is 11.1.0.7, running on Red Hat Linux 4 and the character
set is WE8ISO8859P1.

When running the query:

select col1 from tab1 where col2 like '%zoran%'

I get 'kort/zoran-đinđić' as an row, but when running

select * from tab1 where col1 = 'kort/zoran-đinđić'

I get no rows back.

Both col1 and col2 is nvarchar2

Any suggestions?

/johan
--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: some unicode problem
  - From: Stephane Faroult

some unicode problem

Other related posts: