It sounds like what you need to do is send escape characters. For example,
if you are to insert the string "eric's string", the sql statement will need
to look like
insert into table values ('eric\'s string');
Use \ as your escape character. This will work for characters like quotes
(single and double) and backslashes (forward slashes should not need the
escape character). I'm not sure about the copyright symbol.
Hope that helps.
-Eric
-----Original Message-----
From: Trent Schumann
To: ja...@lists.mysql.com
Sent: 12/3/2000 1:06 PM
Subject: Corrupted special characters
Hi,
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??
TIA
Trent.
5 messages in com.mysql.lists.javaRE: Corrupted special characters
