Page 1 of 1
SQL error on [!=] character entry
Posted: Thu Feb 25, 2010 5:53 pm
by indivisible
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
Re: SQL error on [!=] character entry
Posted: Fri Feb 26, 2010 1:57 am
by BBloke
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!
Re: SQL error on [!=] character entry
Posted: Fri Feb 26, 2010 2:56 am
by AngryWolf
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.
Re: SQL error on [!=] character entry
Posted: Tue May 18, 2010 1:22 pm
by indivisible
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?
Re: SQL error on [!=] character entry
Posted: Tue May 18, 2010 1:35 pm
by BBloke
More than likely more trouble than its worth
Re: SQL error on [!=] character entry
Posted: Tue May 18, 2010 1:43 pm
by indivisible
Agreed. Just sayin'
Re: SQL error on [!=] character entry
Posted: Tue May 18, 2010 1:55 pm
by BBloke
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.
