How to store a fraction as a character in MySQL so it can be outputted within text

Question

I am trying to store the fraction 3/5 (three fifths) as a character in MySQL so that it outputs in php like the symbol ½ within a line of text. I am using phpMyAdmin.

The code for the fraction 3/5 is:

Character Name - VULGAR FRACTION 3/5
Character - ⅗
Entity --
Num Entity - ⅗
Hex Entity - ⅗

Is there a way to do this.

What is preventing you from storing a character in one of your database tables? — Jocelyn, Jan 18 '13 at 01:44

score 2 · Accepted Answer · edited May 23 '17 at 11:49

2

There is a long answer here that explains what you need. Basically you need to make sure all your tables are using utf-8 encoding. It will take some debugging.

edited May 23 '17 at 11:49

Community

1
1

answered Jan 18 '13 at 01:17

nathan hayfield

2,627
1
17
28

Thanks @nathanhayfield that worked and solved the problem, Ted – TedtheBear Apr 05 '13 at 12:49

How to store a fraction as a character in MySQL so it can be outputted within text

1 Answers1