title: NLS_CHARACTERSET WE8ISO8859P1 and UTF8 issues in Oracle
body: <p>I am currently using a Database in oracle which has NLS_CHARACTERSET WE8ISO8859P1 so lets say I store a value in varchar2 field which is maž (accented character) so in database it gets stored as maå¾ . Now when I try to retrieve it with query select * from table where fieldValue = 'maž' it returns 0 rows, and then when i try to insert it again it gives me a constraint error saying value already exist.</p>
  
  <p>How to overcome such situation. 
  I am doing this via Java code</p>