I just happen to have spent the last month wrestling with Oracle and
UTF-8 encoding. I had to deal with BLOBs, but Strings should be
easier.
Oracle stores VARCHAR2, VARCHAR, and CLOB fields as unicode and when
the driver fetches the value, it goes into a String which is just an
array of unicode ch
I don't have any experience with Oracle specifically, but when I see this in
MySQL or indeed on the web in general, there is usually a character encoding
disconnect. I suspect that the layer connecting iBatis to Oracle most likely is
not being told that it should expect utf8. I need to tell the
for example if I have long dash, I will see "?" if I have é I will see
replacement character.
I see it in debug/sysout/jsp
Larry Meadors wrote:
>
> Where are you seeing the "?" characters?
>
> On Fri, Mar 12, 2010 at 3:14 PM, John Seer wrote:
>>
>> Hello,
>>
>> I am not sure where is proble
Where are you seeing the "?" characters?
On Fri, Mar 12, 2010 at 3:14 PM, John Seer wrote:
>
> Hello,
>
> I am not sure where is problem...
> If I am using hibernate I am getting data back with out problems...
> Only combination is ibatis and oracle. I am currently using JNDI to connect
> and saw
Hello,
I am not sure where is problem...
If I am using hibernate I am getting data back with out problems...
Only combination is ibatis and oracle. I am currently using JNDI to connect
and saw in documentation for ibatis 3 that I can set env.encoding=UTF-8... I
tried to use it no difference. :(
If you think it's on the Oracle side start by checking NLS_LANG settings:
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410543
Would try an Oracle Alter Session for NLS_LANG and see if that helps:
http://forums.oracle.com/forums/thread.jspa?threadID=436286&
I'd look for info on the oracle connection string, it's not really an
ibatis thing.
I think that it happens that way by default though.
Where are you seeing the "?" characters?
Larry
On Fri, Mar 5, 2010 at 2:44 PM, John Seer wrote:
>
> Hello,
>
> We am currently using Oracle DB with default u