[Phpmyadmin-devel] Charset related SQL parser bug

Michal Cihar cihar at liten.cz
Tue Aug 6 01:57:01 CEST 2002


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

More information about the Developers mailing list