I got problem with Utf-8, collation, mySQL version 5x

thanhnguyen

Hello all,

I've got a problem with mySQL database,

Current Server supports:

Server version: 5.0.27-standard, Protocol version: 10, Server: Localhost via UNIX socket,

MySQL client version: 5.0.27, phpMyAdmin - 2.9.0.2,
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation:

An Albanian script using:

-- phpMyAdmin SQL Dump
-- version 2.6.1

-- http://www.phpmyadmin.net

-- Host: localhost
-- Generato il: 08 Ott, 2006 at 09:02 AM
-- Versione MySQL: 4.1.12

-- Versione PHP: 5.1.6

-- Database: 6al-blog

I cannot use UTF-8 while installing that script even though I've tried many ways: changed collation to unicode_general_ci or using old phpmyadmin to import and export database.

So, please help me ...

Script page: http://a1k6.info
- error page http://www.a1k6.info/member.php?member=admin

thanks

Thanh Nguyen

MarkR

The solution is simply not to use phpmyadmin for anything, ever. It simply isn't a useful piece of kit.

Take backups and load them using the mysql command line tools - these get it right 100% of the time (or more than phpmyadmin at least).

Only use the proper supported methods for creating and restoring database dumps.

Ensure that your encodings are completely consistent (especially your connection encoding - set it with SET NAMES if in doubt) and it will all work.

Mark

thanhnguyen

thanks for your reply,

but can you guide me in details to solve this problem, just because I am a newbie to MySQl and mySql tools are quite strange for me.

I need your help again.

Thanks,

Thanh Nguyen