In UTF-8 Special Character Problem (They Seem "?")

Discussion in 'MySQL' started by manyakca, Apr 5, 2009.

0
  1. #1
    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
     
    manyakca, Apr 5, 2009 IP
  2. manyakca

    manyakca Peon

    Messages:
    14
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Resolved!

    I exported the table, and I saw problem.

    CREATE TABLE `songs` (
    `songid` int(5) NOT NULL auto_increment,
    `song` varchar(100) character set latin1 NOT NULL,

    I'M AN IDIOT!

    Thank you,
     
    manyakca, Apr 5, 2009 IP