∞ converts to âž when pasted into a MySQL table

Question

The infinity character ( ∞) is converted to ∞when it is inserted into my MySQL table using a PHP script, but if I insert it directly from phpMyAdmin, it inserts correctly. The character is passed to the PHP script by calling GET with a JavaScript function encodeURIComponent()around the content. Field in MySQL database utf8_swedish_cl. How do I get ∞to insert as quality ∞into the database?

Answer 1

Mark this real good SO: UTF-8 answer all the way ...

Answer 2

, phpMyAdmin ? ∞ UTF8, 1- .

, select hex(column_name) from the_table?

• E2889E, UTF8, .

• C3AC, -1, - utf8.

• EC, , -1

, - UTF8:

select 
    column_name, character_set_name, collation_name 
from 
    information_schema.columns
where
    table_name = '_your table_'

Answer 3

SET NAMES utf8 , ?

Answer 4

"" SET CHARACTER SET utf8 .