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
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-lReceived on Mon Mar 23 2009 - 09:39:43 CDT