Re: Pb saving strings with accentuated characters (MySQL 5)
Dev WO <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <[email protected]> |
Hello Jean Pierre, just a quick suggestion: you should move to UTF-8;) despite that, you should check the following: -an HTML form send the text back to the server using the same encoding of the web page so you've got to make sure your HTML declares ISO-8859-1 (both in the <head> section and in the web server) -you've got to check the encoding of your SQL database to make sur it also uses ISO-8859-1 -you've got a wrong connection dictionary, you are saying to use unicode but specify a non-unicode encoding...removing it doesn't change anything as java default to unicode (UTF-8) so your connection dictionary might be useUnicode=false&characterEncoding=ISO-8859-1 -finally just make sur the woresponse get the right header concerning the encoding (ISO-8859-1 in your case) Hope this help, I think the connection dictionary is in fault, but checking the other part is worth it;) Xavier > 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 > > > > _______________________________________________ > WebObjects-dev mailing list > [email protected] > http://www.omnigroup.com/mailman/listinfo/webobjects-dev >