Re: UTF8 problem

2007-06-03 Thread marco turchi
Dear Andrus, first of all, thanks a lot for your patience. I have created a new database using character set utf-8, and colletion utf8... Then i set the following variables: SET character_set_server = utf8; SET character_set_client = utf8; SET character_set_db = utf8; now the "status" command giv

Re: UTF8 problem

2007-06-03 Thread Andrus Adamchik
On Jun 2, 2007, at 9:43 PM, marco turchi wrote: | summary | longtext | utf8_general_ci | YES | | description | longtext | utf8_general_ci | YES | I believe the third column is "collation", not "encoding"; so encoding is still "latin". My idea is that the data are encod

Re: UTF8 problem

2007-06-02 Thread marco turchi
To be honest I do not understand which is the right encoding of my data. If I type "status", i obtain that server, db, connection and client are latin1, but if I type "show full columns from FeedsAll;", I obtain: | summary | longtext | utf8_general_ci | YES | | description | longtext

Re: UTF8 problem

2007-06-02 Thread marco turchi
:-( I have found the problem. Server characterset:latin1 Db characterset:latin1 Client characterset:latin1 Conn. characterset:latin1 all the characterset are latin1 and not UTF8... it is a tragedy!! If I do not misunderstand, I need to recreate the db using the utf8

RE: UTF8 problem

2007-06-01 Thread Fredrik Liden
[mailto:[EMAIL PROTECTED] Sent: Friday, June 01, 2007 11:44 AM To: user@cayenne.apache.org Subject: Re: UTF8 problem Dear Andrus, I have not the admin privileges, so I cannot use mydb :-( I'll ask to the administrator to check it for me. Should I add the "useUnicode=true" parameter in the s

Re: UTF8 problem

2007-06-01 Thread Andrus Adamchik
On Jun 1, 2007, at 8:44 PM, marco turchi wrote: Dear Andrus, I have not the admin privileges, so I cannot use mydb :-( I'll ask to the administrator to check it for me. You need to replace "mydb" with the actual name of your database. Should I add the "useUnicode=true" parameter in the sam

Re: UTF8 problem

2007-06-01 Thread marco turchi
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 Mes

Re: UTF8 problem

2007-06-01 Thread Andrus Adamchik
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: user@cayenne.apa

Re: UTF8 problem

2007-06-01 Thread marco turchi
ext. 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: user@cayenne.apache.org > Subject: Re: UTF8 problem > > I&#

RE: UTF8 problem

2007-06-01 Thread Kevin Menard
> -Original Message- > From: marco turchi [mailto:[EMAIL PROTECTED] > Sent: Friday, June 01, 2007 9:26 AM > To: user@cayenne.apache.org > Subject: Re: UTF8 problem > > I'm using Cayenne 1.2.1, could the version be the problem? > Note that the languages o

Re: UTF8 problem

2007-06-01 Thread marco turchi
Dear Andrus, I force the charset encoding, but nothing changes. The strange things is that if I run my software and I put the output in a file using a pipe, it is: pippo.txt: UTF-8 Unicode text, with very long lines but the stressed letter are wrong encoded... while in the database the

Re: UTF8 problem

2007-06-01 Thread Andrus Adamchik
Usually MySQL JDBC driver can detect the encoding. Not sure why it does not in your case. But you can always force UTF-8 via a connection URL parameter: jdbc:mysql://localhost?characterEncoding=UTF-8 http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference- configuration-properties.

UTF8 problem

2007-05-31 Thread marco turchi
Dear experts, I have a strange situation when I read data from mysql using cayenne. The table is encoded by utf8, I read the data, but some characters, like stressed letter, are not corrected encoded. If i read data inside mysql by a query, they are correct, otherwise if I read data by cayenne, an

UTF8 problem

2007-05-31 Thread marco turchi
Dear experts, I have a strange situation when I read data from mysql using cayenne. The table is encoded by utf8, I read the data, but some characters, like stressed letter, are not corrected encoded. If i read data inside mysql by a querry, they are correct, otherwise if I read data by cayenne, a