thnx to all of you
finaly i have try to insert greek content in MySQL using connect/j
i write down all the step i have to do
cocoon.xconf
<dburl>jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=ISO-8859-7</dburl>
sitemap.xmap
in actions:
<map:action name="set-encoding"
src="org.apache.cocoon.acting.SetCharacterEncodingAction"/>
in pipeline:
<map:act type="set-encoding">
<map:parameter name="form-encoding" value="UTF-8"/>
</map:act>
the action in site map help me to post greek text from html forms to .xsp
where the data are appended to mysql
--stavros
On Fri, 17 Oct 2003 [EMAIL PROTECTED] wrote:
>
> for example
>
> in UTF case te url will be like this ? :
>
>
> jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=UTF-8
>
>
>
> On Fri, 17 Oct 2003, Mark H wrote:
>
> > 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]
> >
> >
>
>
> ---------------------------------------------------------------------
> 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]
