Search code examples
javascriptsql-serverangularjsunicodeng-options

using unicode symbols in ngOption <select>

Hello I've ran into an issue that is stumping me:

So I have an ngOption that loops through and displays unicode symbols

<select class="form-control symbolSelect" ng-model="input.loadSymbol" ng-options="d as d.TagShpUTF for d in loadSymbols" ng-change=""></select>

Here is an example jsFiddle showing it working: http://jsfiddle.net/tjm9a6o2/

I set up the datasource to have a unicode character like so: loadsymbols[0].TagShpUTF = '\u2660'

This all works fine as static data, but when I try to pull the data from my DB it displays it as regular text and doesn't seem to know it's special unicode characters.

This is how I have it setup in the DB (Don't mind other columns, TagShpUTF is the important one): Db Setup

...what I think it's doing is automatically add a second slash '\' so it can be a valid string, but I don't want that to happen. I want it to be recognized as unicode so it shows the symbols in my dropdown (like jsFiddle), but instead it's showing the actual text (like '\u2660').

Any suggestions would be very helpful. Really need a way of storing these symbols and loading them into a drop down. I tried HTML unicode symbols, but they were giving me even more problems than this method. Thanks!

Solution

  • Eureka!!!

    So after many painful attempts and exhausting the kind help from @OrGuz, I kind of gave up on using the \u version of unicode and started looking at HTML-Code version again.

    I stumbled upon this SO post buried in the garbage i've been digging through. It had a link to a MDN page about String.fromCharCode()

    By storing the HTML- Code number in my DB and calling String.fromCharCode() I was able to load the symbol in the drop down.

    spade: HTML-Code= &#9827;
       TagShpUTF= 9827

String.fromCharCode(TagShpUTF); <---- Works!