Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New Coder
    Join Date
    Mar 2008
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts

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

    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? I'll be crazy...

    phpMyAdmin version: 2.11.5
    MySQL version: 5.0.45

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,865
    Thanks
    160
    Thanked 2,224 Times in 2,211 Posts
    Try executing
    Code:
    SET NAMES utf8
    before your actual queries.
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)

  • #3
    New Coder
    Join Date
    Mar 2008
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by abduraooft View Post
    Try executing
    Code:
    SET NAMES utf8
    before your actual queries.
    No, it's same .

  • #4
    New Coder
    Join Date
    Mar 2008
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts
    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,

  • #5
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,865
    Thanks
    160
    Thanked 2,224 Times in 2,211 Posts
    I'M AN IDIOT!

    Thank you,
    Not really. You've isolated the issue by yourself. You won't forget this ever. That's very great achievement
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)


  •  

    LinkBacks (?)


    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •