I still suspect that this is a JDBC or MySQL problem, not Cayenne.
Here is another URL parameter you may try: "useUnicode=true". Also
you may want to doublecheck whether database was configured to
support UTF-8. Enter "mysql" prompt and do something like this:
> use mydb;
> status;
This should print a bunch of info, including this:
Server characterset: utf-8
Db characterset: utf-8
Client characterset: utf-8
Conn. characterset: utf-8
If it prints anything other than utf-8, you may need to recreate the
DB with an appropriate charset.
Andrus
On Jun 1, 2007, at 8:07 PM, marco turchi wrote:
Dear Kevin,
I have tried, but nothing has changed.
here I have an Italian example of my problem:
1a)Assemblea e scontro in redazione per l'allegato di Michela
Brambilla Interviene anche il direttore Belpietro: "Il quotidiano sarà
in edicola" Inserto dei "Circoli della Libertà" e al "Giornale" scatta
lo sciopero
1b)Assemblea e scontro in redazione per l'allegato di Michela
Brambilla Interviene anche il direttore Belpietro: "Il quotidiano sarÃ
in edicola" Inserto dei "Circoli della Libertà " e al "Giornale"
scatta lo sciopero
where 1a is obtained directly by mysql, and 1b is obtained by Java/
Cayenne.
A difference that I have noticed is that:
if I write on two different files the sentence using mysql for 1a and
Java for 1b. The first is encoded as UTF-8 Unicode English text,while
the second as UTF-8 Unicode text.
Sorry about that.
Thanks
Marco
On 6/1/07, Kevin Menard <[EMAIL PROTECTED]> wrote:
> -----Original Message-----
> From: marco turchi [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 01, 2007 9:26 AM
> To: [email protected]
> Subject: Re: UTF8 problem
>
> I'm using Cayenne 1.2.1, could the version be the problem?
> Note that the languages of my shell are:
> en_GB.UTF-8:en_GB:en
I don't know for certain that this will fix your problem, but you
should
probably try 1.2.3. It's the latest 1.2.x release, is fully
backward-compatible with 1.2.1, and includes a decent number of bug
fixes.
--
Kevin
