Pb saving strings with accentuated characters (MySQL 5)

Jean Pierre Malrieu <[email protected]>
Newsgroups gmane.comp.web.webobjects.devel
Message-ID <[email protected]>
Hi,

I am having a problem with saving a String to a MySQL 5 database.
If I type the text within a WOText and save it, no problem.
But if I paste the text from MS Word, let's say, and save it, then  
the string is trimmed after the first accentuated character. The only  
characters that get saved are the characters before the first  
accentuated character.

This happens with different browsers and generated SQL looks fine.

I used to pass parameters  
(useUnicode=true&characterEncoding=ISO-8859-1) to the jdbc connector  
(version 3.1.12). I have tried  removing those parameters, thinking  
they might be irrelevant for MySQL 5. But the problem remains.

Do you guys have any ideas of what could be going on?

Thanks.

JPM
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.