ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard Yee <r...@cruzio.com>
Subject Re: Trying to insert hebrew text, mysql stores ??? instead
Date Sun, 16 Sep 2007 21:27:27 GMT
There are no language settings for iBATIS. I suggest writing a test 
application that uses JDBC to insert into the database. I think you will 
find the same results as you are getting with iBATIS now. This would 
then mean that you need to look at the documentation for MySQL and 
configure it so that it knows that the character set you are sending 
using JDBC is Hebrew. Just because it is working with the mysql command 
line tool, doesn't mean it going to work the same with JDBC.


startxxx wrote:
> my database tables are set utf8
> netbeans debugger shows me the hebrew value of the string fine
> one line before i insert it using iBatis.
> anything else?
> Graeme J Sweeney wrote:
>> On Sun, 16 Sep 2007, startxxx wrote:
>>> The database seem to hold hebrew text if I add it using the mysql query
>>> browser and the hebrew
>>> values show fine when selected from my application using iBatis - so I
>>> have
>>> all reasons
>>> to believe it's not a mysql setup issue (unless I'm missing something in
>>> between the lines)..
>> Assuming the database character set is 'hebrew' and not 'utf8', have 
>> you encoded the content correctly prior to inserting it?
>> See java.lang.String(byte[] bytes, String charsetName)
>> -- 
>> Graeme -

View raw message