Click to See Complete Forum and Search --> : [RESOLVED] In UTF-8 Special Character Problem (They Seem "?")


manyakabi
04-05-2009, 04:06 AM
Hi, I have an UTF-8 SQL file. When I import this file to Mysql, the special non-english characters seem as question mark in phpMyAdmin. The database, the tables, MySQL charset, and MySQL connection collation are set as UTF-8_Unicode_Ci (utf8).

Also, I cannot update the fields manually. It says;
Warning: #1366 Incorrect string value: '\xC4\xB1r K?...' for column 'song' at row 1

What is the problem?

phpMyAdmin version: 2.11.5
MySQL version: 5.0.45

mojtaba
04-06-2009, 02:33 AM
Hi dear,
in the first page of phpMyAdmin Select your collection [ MySQL connection collation: ].

for your script run this query befor all queris:

SET NAMES 'utf8'

good Luck. :-)