I'm no MySql expert, but this really sounds like a encoding or codepage problem.
AFAIK you can add encoding hints in the jdbc connect string. But I don't know the details.
an alternative solution could be to write a FieldConversion that provide a proper String to byte[] conversion. This converison can be implemented to use UTF-8 or any other codepage that knows all those german �berraschungen and �rgernisse :-)
cheers, Thomas
Hinnerk Feldwisch wrote:
Hello again,
doesn't anyone have an idea for a sollution of my problem? Any hint? I tried to debug it, but didn't succeed to solve the core of the problem. And I forgot to mention that everything works fine without OJB, I can INSERT arbitrary Strings to the database when using direkt JDBC- statements...
Thanks again, Hinnerk
Friday, June 13, 2003, 10:09:04 PM, I wrote:
Hello,
I'm using OJB with the mm.mysql- driver (the latest stable release) to store my objects in a mysql- database, which works quite fine; but I'm having problems with special characters like the german umlaute (����). They are stored ok to data- fields with the type "VARCHAR", but are mixed up when I use the mysql- type "TEXT" (and the jdbc- type "LONGVARCHAR").
Where's the problem? Do I have to set the encoding up somewhere?
(OJB does retrieve the text and the special chars from the database correctly, only the storing is a problem)
Thank you very much for any help, Hinnerk
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
