perl-unicode

Japanese Data(Names) Retrieval

2001-09-09 01:45:42
Hi All,

I am facing a very strange problem,

I am firing the following query to my Oracle database:

SELECT DISTINCT a.SC_CONT_EMAIL 
FROM SCAT_CONTACT a, scat_customer b 
WHERE a.sc_customer_id=b.sc_customer_id 
AND a.SC_CONT_LAST_NAME = N'小島' 
AND b.sc_cust_password is not null

This query works fine for all the names in my database except for a few. 

These names are 
1) 三上 
2) \xA8焉扤扤村 
3) 河島  

Can somebody please guide me, what could be the possible cause for the query 
not working fine for the above mentioned names ?
Thanks a lot.

Regards
Ashutosh Sangle.





<Prev in Thread] Current Thread [Next in Thread>
  • Japanese Data(Names) Retrieval, ashutosh sangle <=