Marko Riedel wrote:
> The problem is that the German Umlauts disappear during the
> process. The new install displays them as stars or as the "unknown
> glyph" in different browsers.
> We tried using mysqldump from the command line, rather than
> PHPMyAdmin, setting the character sets with
> Neither of the above works. Someone suggested we try UTF-8, but it is
> not listed among the character sets on the source machine. Here is
> what we have:
> How do I tell "mysqldump" to output UTF8? Also, we were not able to
> find an option for "mysql" to set the character set of data being
> piped in.
Some days ago I had the same problem with a spanish mysql dump. I
exported the data from one
mysql server (4.x) and imported into another one (4.x too, but with a
different x subversion number) .
The original data was UTF8 encoded, and I had to include this chunk of
text in the beginning of original dump.sql
so I can import accents well (I think that the magic is in SET NAMES
utf8... the rest may be superfluos...)
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
By the way, which are your mysql versions? can you show us the result of
this mysql query?
mysql> show variables like 'char%';
Hope it helps,