NATION

PASSWORD

Forum support for Unicode?

Bug reports, general help, ideas for improvements, and questions about how things are meant to work.
User avatar
Enfaru
Minister
 
Posts: 2921
Founded: Apr 20, 2012
Ex-Nation

Forum support for Unicode?

Postby Enfaru » Tue Dec 04, 2012 6:48 am

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 :lol: ).

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?
Last edited by Enfaru on Tue Dec 04, 2012 7:08 am, edited 3 times in total.
Sovereign Charter Quick Links
Factbook · Role-plays · RMB · Map (Origin | Quantum) · Chat · Members: 73
Myraxia: One does not learn to GM; One throws oneself in and prays they don't fuck up too badly.
Game Master
Founder of the Sovereign Charter,
4th President and,
Tutor of the College of Theatrics

User avatar
[violet]
Executive Director
 
Posts: 16207
Founded: Antiquity

Postby [violet] » Tue Dec 04, 2012 6:22 pm

Test: ဠ

What's not working for you?
Last edited by [violet] on Tue Dec 04, 2012 6:22 pm, edited 1 time in total.

User avatar
Solm
Senator
 
Posts: 3582
Founded: Jul 23, 2008
Corporate Bordello

Postby Solm » Tue Dec 04, 2012 6:49 pm

[violet] wrote:Test: ဠ
∫©¥[list=]6756[i]78ª•¶578987654321
[url][/url]
[/i][/list]&
What's not working for you?

Retired: ns .hellodot. solm @ gmail .dot. com

User avatar
[violet]
Executive Director
 
Posts: 16207
Founded: Antiquity

Postby [violet] » Tue Dec 04, 2012 8:06 pm

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.

User avatar
Enfaru
Minister
 
Posts: 2921
Founded: Apr 20, 2012
Ex-Nation

Postby Enfaru » Tue Dec 04, 2012 11:01 pm

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).
Last edited by Enfaru on Tue Dec 04, 2012 11:05 pm, edited 2 times in total.
Sovereign Charter Quick Links
Factbook · Role-plays · RMB · Map (Origin | Quantum) · Chat · Members: 73
Myraxia: One does not learn to GM; One throws oneself in and prays they don't fuck up too badly.
Game Master
Founder of the Sovereign Charter,
4th President and,
Tutor of the College of Theatrics

User avatar
Frisbeeteria
Senior Game Moderator
 
Posts: 27796
Founded: Dec 16, 2003
Capitalizt

Postby Frisbeeteria » Tue Dec 04, 2012 11:24 pm

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?

User avatar
Enfaru
Minister
 
Posts: 2921
Founded: Apr 20, 2012
Ex-Nation

Postby Enfaru » Tue Dec 04, 2012 11:27 pm

-_-... 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.
Sovereign Charter Quick Links
Factbook · Role-plays · RMB · Map (Origin | Quantum) · Chat · Members: 73
Myraxia: One does not learn to GM; One throws oneself in and prays they don't fuck up too badly.
Game Master
Founder of the Sovereign Charter,
4th President and,
Tutor of the College of Theatrics

User avatar
[violet]
Executive Director
 
Posts: 16207
Founded: Antiquity

Postby [violet] » Tue Dec 04, 2012 11:28 pm

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.

User avatar
Enfaru
Minister
 
Posts: 2921
Founded: Apr 20, 2012
Ex-Nation

Postby Enfaru » Mon Sep 01, 2014 7:08 am

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.
Sovereign Charter Quick Links
Factbook · Role-plays · RMB · Map (Origin | Quantum) · Chat · Members: 73
Myraxia: One does not learn to GM; One throws oneself in and prays they don't fuck up too badly.
Game Master
Founder of the Sovereign Charter,
4th President and,
Tutor of the College of Theatrics


Advertisement

Remove ads

Return to Technical

Who is online

Users browsing this forum: Cessarea, Diarcesia, Kakastania, Lehqhbraot, Number Five

Advertisement

Remove ads