Login   Register  
PHP Classes
elePHPant
Icontem

Correct Umlauts

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      MySQL Dump - database backup  >  All threads  >  Correct Umlauts  >  (Un) Subscribe thread alerts  
Subject:Correct Umlauts
Summary:To get correct umlauts when importing the file with phpmyadmin
Messages:1
Author:Philipp
Date:2011-11-19 10:26:56
 

  1. Correct Umlauts   Reply   Report abuse  
Picture of Philipp
Philipp
2011-11-19 10:26:56
PhpMyAdmin defaults to UTF8 when importing an SQL / SQL.GZ File.
Most Mysql Servers default charset is not UTF8, but latin1 or something else.

if you query this, after connecting to the database (and before instantiating MySQLDump), you will always get correct umlauts.

mysql_query("SET NAMES 'utf8'", $db);
mysql_query("SET CHARACTER SET 'utf8'", $db);