Java Database Connectivity (JDBC)

Hi....

I'm using JDBC & MySQL with japanese language with option useUnicode=true&characteEncoding=SJIS

Some japanese language contains mysql escape character...

for example �� character is expressed by "95 5C(escape character:\)" in Hex code.

when i want to insert this character into mysql like this way...

insert into table values ('��'); // sample...

Mysql understans this

insert into table values (' 95(Hex) \');

so ignore single quotation and returns SQLException...

I found SQLException reason by using UltraEdit hex code.

I can insert this character by appending \(escape character) making ��\(95 5C 5C).

Mysql inserts ��\ to ��...

But I nned some automatic code for this problem for random & bulk japanese character input...

I'm not japanese...

So if you anybody knows how to solve this problem, please reply to me...

Thanks