PureBasic Forums - English

Posted: **Mon Apr 10, 2017 2:16 pm**

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

Posted: **Mon Apr 10, 2017 5:43 pm**

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.

PureBasic Forums - English

PB Forum Crashes When Posting 4 Byte Unicode Characters

PB Forum Crashes When Posting 4 Byte Unicode Characters

Re: PB Forum Crashes When Posting 4 Byte Unicode Characters