some unicode problem

From: Johan Eriksson <valpis_at_gmail.com>
Date: Mon, 23 Mar 2009 15:39:43 +0100
Message-ID: <6c133d8a0903230739x1182cf34n82c6d37097a7fe26_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 23 2009 - 09:39:43 CDT

Original text of this message