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
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
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
:-(
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
[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
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
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
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
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
> -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
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
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.
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
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
14 matches
Mail list logo