i have old site visitors can add comments. until worked well, doesn't have many visitors (it's niche audience). built in classic asp , it's using mysql (now 5.6). it's running on iis 8.5 , connects db without dsn.
whenever adds emoji characters posts it'll make iis service go kind of loop using more 60% of cpu , never stops.
i not want filter these characters out, think fit in site's premise, did not foresee issue. when first set mysql used utf-16 make sure users write in language, , never had issues until now. there messages in looks japanese , korean, , figured out issue emojis when user told me doing when site crashed on him.
- all site's pages/files saved in unicode , of them charset set "utf-8".
- the database's collation utf16_unicode_ci , tables'.
- i can insert emojis tables directly command line or via heidisql, however....
- the server sending emojis question marks (?).
here's connection string:
driver={mysql odbc 5.3 unicode driver};server=...;user=******;password=******;option=3;charset=utf16;
use character set utf8mb4 end-to-end in mysql.
