Hi Nobu
I got it working finally. Your advice was correct. I used
jdbc:mysql://localhost:3306/mocha?useUnicode=true&characterEncoding=SJIS
Also - the problem was tomcat was giving the data in ISO 8859_1. I had to
convert it to SJIS and then store it.
Thanks a lot.
Regards,
Somik
----- Original Message -----
From: "Somik Raha" <[EMAIL PROTECTED]>
To: "Turbine Torque Users List" <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 5:13 PM
Subject: Re: Torque, Japanese, MySQL
> 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]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
