Came across a similar problem a while back. The solution was to add
parameters to the database url, setting the character encoding to the one
that java uses.
in WEB-INF/cocoon.xconf:
<datasources>
<jdbc name="databaseName" logger="core.datasources.databaseName">
<pool-controller min="5" max="10"/>
<dburl>jdbc:mysql://localhost/databaseName?useUnicode=true&characterEnco
ding=Cp1252</dburl>
<user>username</user>
<password>password</password>
</jdbc>
</datasources>
Mark
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> ]On Behalf Of leo leonid
> Sent: 17 October 2003 15:20
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL encoding problems with connector/J not throug ODBC
>
>
>
> What encoding do you use in your DB? I solved all my encoding problems
> when I changed the encoding of my DB to UNICODE. (But I don't know if
> this possible in MySQL now. I migrated to PostgreSQL for this reason, a
> long time ago)
>
> /leo
>
> On Oct 17, 2003, at 4:02 PM, [EMAIL PROTECTED] wrote:
>
> >
> > hi people
> >
> > i have (as many other people here) encoding problems with greek
> > language
> >
> > i have a mysql dadabase runing on winXP with greek content
> >
> > i try a very simple query using cocoon 2.1 using two different
> > connection
> > methods
> >
> > 1. using MySQLConnector/j (3.0)
> > 2. using ODBC connection
> >
> >
> > in case [1] i dont get greek characters
> > in case [2] i get greek characters corectly but is not the way i want
> > because in production mysql and cocoon will be in a linux box ?
> >
> > in my simple example i just execute a .xsp and a xml serialization
> >
> > i have try the simplest query:
> >
> > <esql:connection>
> > <esql:pool>talanto_work</esql:pool>
> > <esql:execute-query>
> > <esql:query>select * from
> contact</esql:query>
> > <esql:results>
> > <customers>
> > <esql:row-results>
> > <customer>
> >
> <esql:get-columns/>
> > </customer>
> > </esql:row-results>
> > </customers>
> > </esql:results>
> > </esql:execute-query>
> > </esql:connection>
> >
> >
> >
> > any idea ?
> >
> >
> > thnx
> > --stavros
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
