Hi Nobu
Thanks for replying.
> torque.database.[DB Name].url =
> jdbc:mysql://localhost:3306/mocha?useUnicode=true&characterEncoding=EUC_
> JP
I tried this (changed the encoding to EUC_JP everywhere), but it still didnt
work. I had originally tried with
jdbc:mysql://localhost/mydb?useUnicode=true&characterEncoding=Shift_JIS
Insertions work fine, its the retrieval that gives the problem.
> This is of course if you are using Japanese EUC encoding.
I am using Shift_JIS.
For insertion, I am converting the data from Shift_JIS (or EUC_JP) to
8859_1, and then storing. For retrieval, my query is formed with parameters
sent thru a form on a Japanese page. So I am doing the same thing as I did
for insertion.
None of this worked.
Regards,
Somik
----- Original Message -----
From: "Nobuyuki Paul Aoki" <[EMAIL PROTECTED]>
To: "'Turbine Torque Users List'" <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 4:23 PM
Subject: RE: Torque, Japanese, MySQL
>
> I'm planning on using Torque on a web application with Japanese as a
> requirement as well.
>
> I have made a test application and got it to insert/select using torque.
>
> I was able to get inserting to work easily but I ran into a small issue
> with selecting. The answer lies in the JDBC driver.
>
> torque.database.[DB Name].url =
> jdbc:mysql://localhost:3306/mocha?useUnicode=true&characterEncoding=EUC_
> JP
>
> This is of course if you are using Japanese EUC encoding.
>
> I hope this helps.
>
> nobu
>
> > -----Original Message-----
> > From: Somik Raha [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, June 10, 2002 2:57 PM
> > To: Turbine Torque Users List
> > Subject: Torque, Japanese, MySQL
> >
> > Hi,
> > Has anyone tried storing Japanese strings in MySQL with Torque ? I
> > seem to be facing some encoding issues, and am unable to query columns
> > with Japanese data in it.
> > I'd appreciate any tips.
> > Regards,
> > Somik
>
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
