Re: Problem with Character Encoding

2010-03-12 Thread Larry Meadors
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

Re: Problem with Character Encoding

2010-03-12 Thread François Schiettecatte
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

Re: Problem with Character Encoding

2010-03-12 Thread John Seer
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

Re: Problem with Character Encoding

2010-03-12 Thread Larry Meadors
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

Re: Problem with Character Encoding

2010-03-12 Thread John Seer
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. :(

Re: Problem with Character Encoding

2010-03-05 Thread Ellis Miller
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&

Re: Problem with Character Encoding

2010-03-05 Thread Larry Meadors
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