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 <kmenar..ervprise.com> wrote:
>> > -----Original Message-----
>> > From: marco turchi [mailto:marco.turch..mail.com]
>> > Sent: Friday, June 01, 2007 9:26 AM
>> > To: use..ayenne.apache.org
>> > 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
>>
>
This archive was generated by hypermail 2.0.0 : Fri Jun 01 2007 - 13:33:12 EDT