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 -
