...

View Full Version : In UTF-8 Special Character Problem (They Seem "?")



Richy
04-04-2009, 10:24 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? I'll be crazy...

phpMyAdmin version: 2.11.5
MySQL version: 5.0.45

abduraooft
04-05-2009, 05:33 PM
Try executing

SET NAMES utf8 before your actual queries.

Richy
04-05-2009, 05:57 PM
Try executing

SET NAMES utf8 before your actual queries.

No, it's same :(.

Richy
04-05-2009, 06:06 PM
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,
:)

abduraooft
04-05-2009, 06:22 PM
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 :)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum