Whenever I attempt to retrieve my data from an SQL Server database or a MSAccess database characters like apostrophes ' or double quotes " are changed into other characters such as / and ?. I've checked the database and the data is correct. Has anyone else experienced this problem and does anyone know a solution?
Is it always the same characters that appear instead of the apostrophe and double quote? What JDBC driver are you using? JDBC - ODBC bridge? What happens with Oracle or mySQL?
I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
Joined: Sep 04, 2001
It is always the same characters. I've found out that Microsoft format their single and double quotes like they would in word, instead of the conventional ' or "
Joined: Oct 09, 2001
Hi Rik, SQL Server is doing this too? I'm not sure I understand what you mean. Surely the character stored in the database is just the character. When is it being formatted, and what is formatting it? The JDBC driver or the database?