Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <46ED9FBF.5060209@cruzio.com>
Date: Sun, 16 Sep 2007 14:27:27 -0700
From: Richard Yee <ryee@cruzio.com>
User-Agent: Thunderbird 1.4 (Windows/20050908)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: Trying to insert hebrew text, mysql stores ??? instead
References: <12695809.post@talk.nabble.com> <46EC95C7.1070204@cruzio.com>
 <12697634.post@talk.nabble.com>
 <Pine.LNX.4.64.0709161200420.2637@localhost.localdomain>
 <12724076.post@talk.nabble.com>
In-Reply-To: <12724076.post@talk.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.

-Richard


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 -
>>
>>
>>     
>
>