SQL error on [!=] character entry

indivisible · Post by **indivisible** » Thu Feb 25, 2010 5:53 pm

Forum does not like the "not equal to" sign

Throws out a SQL error on submit (not preview) with the symbol in the "post_text" or "post_subject" columns in the phpbb_post table.
Error linky

BBloke · Post by **BBloke** » Fri Feb 26, 2010 1:57 am

Shame on you for trying LOL. You could always pop over to phpbb and post a bug! Smokedef already caused a thread error due to cyrillics!

AngryWolf · Post by **AngryWolf** » Fri Feb 26, 2010 2:56 am

Yeah BBloke is on the right track: I think the post_text field is probably encoded as ISO Latin 1 (or something similar) in the database, and indivisible's "not equal to" sign does not fit into that character set, more specificly, it could be an UTF-8 character, that is why MySQL complains.

indivisible · Post by **indivisible** » Tue May 18, 2010 1:22 pm

Just noticed I'd let these replies sneak by me.
Wasn't really an issue to begin with but wouldn't phpMyAdmin or whatever db manager Festers' host uses let you change the charset?

BBloke · Post by **BBloke** » Tue May 18, 2010 1:35 pm

More than likely more trouble than its worth

indivisible · Post by **indivisible** » Tue May 18, 2010 1:43 pm

Agreed. Just sayin'

BBloke · Post by **BBloke** » Tue May 18, 2010 1:55 pm

I know.. I'm not that clued up with charset/collations and what nots... so it would be a dark path for me to tread. It's working so I'm staying clear of changing anything LOL.. Cheers anyway indivisible.

SQL error on [!=] character entry

SQL error on [!=] character entry

Re: SQL error on [!=] character entry

Re: SQL error on [!=] character entry

Re: SQL error on [!=] character entry

Re: SQL error on [!=] character entry

Re: SQL error on [!=] character entry

Re: SQL error on [!=] character entry