June 12th, 2002, 09:24 PM
difference between “” and ""
The data file (*.txt) I tried to bulkload into MySQL database
contains some “” instead of "" in the strings. When I tried to show those as links on JSP, I found that they changed into question mark '?'. And when I click the links, I want to call another JSP to show the contents related to the strings. And of course in this case the search failed. MySQL does not support “”, right?
Can anyone help me out? Thank you very much!
June 13th, 2002, 11:29 AM
My first guess would be that the hex code for that character is being interpreted different by the different parsers. Browsers and Java use unicode as far as I know, but what about mysql? What character is the correct one? It is highly possible that mysql is indeed changing the character into something it thinks it should be. In the end, none of what we type is really characters at all, it is only hex values that something must then convert into characters.
June 13th, 2002, 07:14 PM
Thank you very much! When I checked it in MySQ and also read it under Unix system, I found that all “” turned into ô, and some of dash - turned into û.
Can we configure MySQL to accept those characters, or we need to convert all “” into "" before loading the data file into MySQL?
Thanks a lot.
June 13th, 2002, 11:53 PM
If it is indeed supposed to be a double quote, I would convert it to that I guess. I do not know what kind of data you are using, so it is hard to say how critical that would be. Regardless of what it is, make sure and encode it if you are using it in a url.