joined:Sept 30, 2009
I am inserting text into my database with text typed from a smartphone. There are special characters users are typing so my database and connection are setup to use utf-8.
I'm finding in phpMyAdmin for a few users text is showing up as:
But when I edit it the text displays as (with characters that look slightly off):
Into working out, hip hop, trap, R&B, rock, rap, intellectuals, health enthusiasts[...]
I'd like to normalize this data before inserting it into my database (while at the same time still support any special characters used on smartphones like emoji).
I tried to first see how this is encoded by using mb_detect_encoding but everything is being listed as ASCII.
I don't know how to start this project and I would appreciate any help. Thanks.