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     | utf8_general_ci | YES  |

My idea is that the data are encoding UTF8 inside the table, but when
Cayenne creates a connection, all the data that pass through that
connection are encoding latin1. Is it right?

Thanks a lot
Marco



On 6/1/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote:

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 same place of
> "characterEncoding=UTF-8"?

Yes, this is a part of the JDBC URL. You can also use them both at
the same time: jdbc:mysql://....?characterEncoding=UTF-8&useUnicode=true

Andrus

Reply via email to