PhpMyAdmin and UTF-8

biljap

Hi!
I’m having problems with showing data from a database (special characters are not encoded). I have the same version of phpMyAdmin at my home computer and I know that I have the option to choose utf-8 encoding when I import the database. On Frihost I don’t see that option and I’ve tried to search Google and I’ve found some tutorials but nothing works…

Some examples of what I’ve tried:

CREATE TABLE `category` (
`name` varchar(60) NOT NULL character set utf8,
PRIMARY KEY (`name`)
);

CREATE TABLE `category ` (
`name` varchar(60) NOT NULL,
PRIMARY KEY (`name`)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `category ` (
`name` varchar(60) NOT NULL,
PRIMARY KEY (`name`)
) DEFAULT CHARACTER SET utf8;

I don’t have any problems on my computer… I just need to show special characters.

Does anyone know how to solve this?

Thank you!

SamiTheBerber

I can confirm this. I have tried so many times to change phpMyAdmin charset to utf-8, but I always get Swedish latin1. Charset works when I add text from web form, but not through phpMyAdmin. I would also like to know the sollution for this.