Could one of our iconv/charset people tell me what is going on with bug #590898 that the systems are generating weird queries like that ?
I think the best way to deal with things would be to ensure that weird stuff like that, which my copy of MySQL seems to reject itself even, would be to fix why the bad SQL is being generated, but failing that, I could work out a fix in my parser.
Hi
On Mon, 5 Aug 2002, Robin Johnson wrote:
Could one of our iconv/charset people tell me what is going on with bug #590898 that the systems are generating weird queries like that ?
I don't think that this bug was caused by charset conversion, at least because around WebMaster are normal quotes and these messy characters are just around the other words. My guess is that this sql was pasted from some "clever" program which makes automatically opening and closing quotes (aren't they on Windows on these positions? When I convert the text from windows-1252 to iso-8859-1 I get instead these strange chars opening and closing quotes: `Treasurer´).
Michal Cihar
On Mon, 5 Aug 2002, Michal Cihar wrote:
Could one of our iconv/charset people tell me what is going on with bug #590898 that the systems are generating weird queries like that ?
I don't think that this bug was caused by charset conversion, at least because around WebMaster are normal quotes and these messy characters are just around the other words. My guess is that this sql was pasted from some "clever" program which makes automatically opening and closing quotes (aren't they on Windows on these positions? When I convert the text from windows-1252 to iso-8859-1 I get instead these strange chars opening and closing quotes: `Treasurer�).
Any ideas on what can be done or should be done as a solution?
Hi
On Mon, 5 Aug 2002, Robin Johnson wrote:
On Mon, 5 Aug 2002, Michal Cihar wrote:
Could one of our iconv/charset people tell me what is going on with bug #590898 that the systems are generating weird queries like that ?
I don't think that this bug was caused by charset conversion, at least because around WebMaster are normal quotes and these messy characters are just around the other words. My guess is that this sql was pasted from some "clever" program which makes automatically opening and closing quotes (aren't they on Windows on these positions? When I convert the text from windows-1252 to iso-8859-1 I get instead these strange chars opening and closing quotes: `Treasurer´).
Any ideas on what can be done or should be done as a solution?
Report this as wrong SQL, because MySQL won't accept it also. BTW: Could ascii char >= 0x80 appear unquoted in SQL?
Michal Cihar
-
Michal Cihar -
Robin Johnson