Re: UTF8 problem

From: marco turchi (marco.turch..mail.com)
Date: Sat Jun 02 2007 - 14:43:20 EDT

  • Next message: Andrus Adamchik: "Re: UTF8 problem"

    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 <andru..bjectstyle.org> 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
    >

    This archive was generated by hypermail 2.0.0 : Sat Jun 02 2007 - 21:50:23 EDT