NationStates

Hi,

Just wondering if it would be possible to allow this? There are a few unicode symbols that I would like to use as part of my posts simply because the current provisions of 0-9a-Z along with the various keyboard symbols are not quite enough for me, but... I keep getting a mysqli error. (You should really be using MySQL full but never mind, I can live with that ).

I would recommend a new BBCode tag called [unicode1] of which would take HTML or a Unicode (eg U+A102) and transform it into the relevant entity. So the following would work.

[unicode1]&[/unicode] or [unicode1]U+0026;[/unicode] would output '&'.

Admin?

Test: ဠ

What's not working for you?

Unfortunately that doesn't help, since I don't know what you typed in, what you're seeing on whichever browser/OS combo you use, how what you're seeing differs from what you expected, or how it relates to the mysqli error the OP reported.

https://en.wikipedia.org/wiki/Gothic_alphabet#Unicode
http://www.codetable.net/unicodecharacters?page=89
http://www.codetable.net/unicodecharacters?page=88
http://www.codetable.net/unicodecharacters?page=81

And various others don't work for me. I can get quite a variety of symbols...just...not the ones I want.

By the way, I'm using hex code 𝐒 as a test to pull up the mysqli error. (Which should display an S glyph). I also use Firefox on linux (I can assure you however that the problem isn't client side).

Enfaru wrote: I also use Firefox on linux (I can assure you however that the problem isn't client side).

That's what I'm using, and I'm not seeing any of the problems you're having. Have you checked your add-ons library to look for conflicts, perhaps?

-_-... the problem is not client side... otherwise I'll need you to prove it. Please post http://www.codetable.net/hex/1d412.

Here's the Error in full.


General Error
SQL ERROR [ mysqli ]

Incorrect string value: '\xF0\x9D\x90\x92' 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.

Please notify the board administrator or webmaster: no-reply@nationstates.net


I've highlighted the bit which states the problem is not client side.

Enfaru wrote:By the way, I'm using hex code 𝐒 as a test to pull up the mysqli error.

Yep, reproduced the problem, thanks. A little odd, since we're all UTF8 forum-side... I'll look into it.

It seems like I'm still getting the problem,

Maybe it's something to do with the fact that it is UTF-8 encoding. It's quite possibly that the character I wanted is UTF-16, but I don't know enough about that.