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,852
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    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,852
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    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
    •