Is there an iconv encoding that matches the utf8_general_ci encoding in mysql?

Question

MySQL

It is necessary to clean the input text in utf8 from all characters not supported by the database encoding.
Particularly from emoji. Of course, you can use a regular expression, but I did not find a detailed description of the encoding restrictions in mysql

Answer 1

utf8 - one-, two- and three-byte characters from \u0000 to \uFFFF.
utf8mb4 - one-, two-, three- and four-byte characters from \u000000 to \u10FFFF.

Answer 2

You can draw in html using canvas. But I would do with svg. You can also just throw a picture of the house on the back and mark it up with the help <map>
. But with svg it’s more convenient for me, since the house can be generated with different configurations.

Answer 3

And I would ul-ohm and already podmarafetil in css ...
The roof :before the picture on the BG, the first floor :after also the picture on the BG
And the rest is just right for the ul list is very suitable ...
Even OL-ohm, and floors will be numbered automatically :)

<ol reversed>
<li>...</li>
</ol>

Answer 4

Better on SVG