5 messages in com.mysql.lists.javaRe: Corrupted special characters| From | Sent On | Attachments |
|---|---|---|
| Trent Schumann | 03 Dec 2000 10:06 | |
| Tom Myers | 03 Dec 2000 11:10 | |
| Tim Endres | 03 Dec 2000 14:25 | |
| Eric Muntz | 03 Dec 2000 16:23 | |
| mikel | 04 Dec 2000 05:27 |
| Subject: | Re: Corrupted special characters |
|---|---|
| From: | Tim Endres (ti...@trustice.com) |
| Date: | 12/03/2000 02:25:24 PM |
| List: | com.mysql.lists.java |
Have you tried to use PreparedStatements and using stmt.setEscapeProcessing(
false )?
tim.
At 11:06 AM 12/3/2000 -0700, Trent Schumann wrote:
Using MySQL, mmJDBC Driver on Win2000 machine.
When saving "special" characters (eg. left and right apostrophes, left and right
quotes, copyright symbol etc.), in MySQL, it messes them up and returns a
question mark in place of these characters when retrieved from the database.
Have also tried using BLOB fields to no avail.
Any suggestions??
It might be a bit clumsy, but can't you save in Base64? You can get a GNU GPL Base64 class from http://www.gjt.org/javadoc/com/protomatter/util/Base64.html or other versions from many places, or just write one. Would that do it?
Tom Myers
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.