PB Forum Crashes When Posting 4 Byte Unicode Characters

Everything else that doesn't fall into one of the other PB categories.
User avatar
Shield
Addict
Addict
Posts: 1021
Joined: Fri Jan 21, 2011 8:25 am
Location: 'stralia!
Contact:

PB Forum Crashes When Posting 4 Byte Unicode Characters

Post by Shield »

Hi guys

Not sure where to post it since this is not a bug related to PB but to this forum.
The forum software crashes with an SQL error when I post a 4 byte character
from this website: http://www.i18nguy.com/unicode/supplementary-test.html (e.g. U+2070E).

SQL Error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Incorrect string value: '\xF0\xA0\x9C\x8E\x0A\x0A...' for column 'post_text' at row 1 [1366]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Would be nice to have it fixed. :)

Thanks
Image
Blog: Why Does It Suck? (http://whydoesitsuck.com/)
"You can disagree with me as much as you want, but during this talk, by definition, anybody who disagrees is stupid and ugly."
- Linus Torvalds
User avatar
Demivec
Addict
Addict
Posts: 4085
Joined: Mon Jul 25, 2005 3:51 pm
Location: Utah, USA

Re: PB Forum Crashes When Posting 4 Byte Unicode Characters

Post by Demivec »

I noticed that error last month while posting some code with gadgets that also involved 4 byte UTF-16 codepoints. I had to rewrite the sample to finally get it to post but it was hard. I ended up having to put some values in Chr () functions and in comments (to be manually replaced for working code).

I couldn't send the code by personal message either since the same limitations were present.

It would be nice if there was a forum fix for this.
Post Reply