<div>
That's generally a problem with the software you are using to query the database, which cannot display the international character. &nbsp;Try viewing the column value using a different software.
</div>


<div>
Hey thanks, could you please suggest any query software I can use, I have tried Toad and SQLDeveloper., but both display ¿
</div>


<div>
Hi!<br />
Toad depends on version, 10.6 displays unicode, but 9.6 does not (I'm not sure for versions in between)<br />
<br />
Did you try this select:<br />
<br />
select unistr('\0153') from dual;<br />
<br />
In Toad 10.6 I get correct 'œ', but in 9.6. I get 'o'<br />
<br />
It is also possible that application you used to write to database does not support that character correctly.<br />
<br />
Regards<br />
<br />

</div>


<div>
thanks, it worked.<br />
<br />
I need one last help on this, is there any predefined function to which I can pass 'œ' and it returns me <br />
unicode value &nbsp;- '\0153' ?<br />

</div>


<div>
You might consider alternative solution:<br />
<br />
<a href="http://www.fileformat.info/info/unicode/char/153/index.htm" rel="ugc">http://www.fileformat.info/info/unicode/char/153/index.htm</a><br />
Just search for the character and you can find its code, and you can be sure that that IS the correct character<br />

</div>


<div>
There is function ASCIISTR, but I didn't get expected results in Toad because it seems that when parsing data it converted unicode to nearest ascii character before executing SQL...<br />
<br />
select asciistr('œ'),asciistr(uni<wbr />str('\0153<wbr />')),unistr<wbr />('\0153') from dual;<br />
<br />
Regards...<br />

</div>


<div>
I am using sqldeveloper to test and my front end application is java, both of them returns inverted question mark &quot;¿&quot; not really sure why, <br />
<br />
as I executed select unistr('\0153') from dual;, returns me correct result, I am pretty sure oracle supports it.<br />
<br />
I am not really sure how to send these type of parameter values from my client &nbsp;to oracle.<br />
<br />

</div>


<div>
If that's the case I suppose that you need to use setFormOfUse() method when inserting or updating NVARCHAR2 column.<br />
<br />
Check this link:<br />
<a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch7progrunicode.htm" rel="ugc">http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch7progrunicode.htm</a><br />
<br />
Chapter: Binding and Defining Java Strings to SQL NCHAR Datatypes<br />
<br />

</div>


<div>
Thanks htonlov.<br />
<br />
I do it while setting the parameter, to insert or update the table row, but somehow when I fetch the row back, it gives me inverted question mark.<br />
<br />
so I have no way to test it that if it is saved as is or as inverted question mark.
</div>


<div>
You sad that &quot;select unistr('\0153') from dual&quot; got correct result... in the same application execute &quot;select COLUMN from TABLE&quot; where you inserted that character...<br />
<br />
Also just to be sure (if you didnt already) try to run System.out.println(&quot;œ&quot;), in java and see if console displays it correctly ...<br />
<br />

</div>


<div>
I have two parts to this problem.<br />
<br />
a. running through sqldevloper- so if pass select * from my table where my_column = 'aaaœ' , it does not return correct result and returns me 'aaa¿'.<br />
<br />
b. when sending requests from java with setForm, on debugging in eclipse (java), it shows me that it is storing the value as 'aaaœ' but when my front end application fetch the result to display on screen, i get 'aaa¿' on my screen. System.out.println(&quot;œ&quot;) displays &quot;œ&quot;.<br />
<br />

</div>


<div>
Thanks htonkov<br />
<br />
A. YES<br />
B. YES<br />
C. NO with Exception<br />
In java when I ran<br />
<br />
String sql = &quot;select my_column from my_table&quot;;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;ResultSet rs= stmt.executeQuery(sql);<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;while(rs.next());<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;{<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; System.out.println(rs.getS<wbr />tring(1));<wbr /><br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;}<br />
<br />
I got exception <br />
<br />
Exception in thread &quot;main&quot; java.sql.SQLException: Exhausted Resultset<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.SQLStat<wbr />eMapping.n<wbr />ewSQLExcep<wbr />tion(SQLSt<wbr />ateMapping<wbr />.java:70)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.Databas<wbr />eError.new<wbr />SQLExcepti<wbr />on(Databas<wbr />eError.jav<wbr />a:133)
</div>


<div>
This code looks OK to me...<br />
you don't have linenumber in stack trace of your code, do you maybe have several statements?<br />
<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I have a NVARCHAR2 column, whenever I try to insert 'œ' string, it displays as ¿.<br />
Not really sure, why it is happening although my column type is NVARCHAR2(240).<br />
<br />
Please help.<br />
<br />

</div>
</div>


I have a NVARCHAR2 column, whenever I try to insert 'œ' string, it displays as ¿.
Not really sure, why it is happening although my column type is NVARCHAR2(240).

Please help.



Oracle nvarchar2

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.