My guess is that you inserted quotes copied from Microsoft Word. Word repaces normal single quotes with "smart quotes"(their term, not mine). This is some value that is not resolved by a lot of applications(notepad,xml/xsl,etc),although XMLSpy seemed to know what it was but wouldn't change it, even though it would show up as escape chars in my xml document.
You can disable them in the "auto-format" section and also in the "auto-format as you type" section under tools-autoformat. I wish there was an 'undo useless formatting enabled by default', but I couldn't find it.
now to get rid of them, you must (after disablind autoformat) replace all ' with ' and you will have normal quotes again. Same with ", the ellipse(...), and other autoformat characters (smiley faces, etc).
now you can re-insert your data to your database.
It took us a while to figure out that word was the culprit.
hope this helps
Charlie
-----Original Message-----
From: Venkat [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 2:22 AM
To: [EMAIL PROTECTED]
Subject: Preserving single quotes
Hi all
Forgive me if it's a repeated post since I could not get adequate info. from
the archives. I'm facing a problem which most of you might have encountered
and solved. Please provide a solution to this: I'm able to insert all
specials characters into my MSSQL tables using PreparedStatement interface
but when I read the same data using a CachedRowSet class or normal ResultSet
class, everything works fine except single quotes which are displayed as '?'
Please suggest me a work around to this
Thank you all
venkat
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
