search

eccsup / jwpl

Automatically exported from code.google.com/p/jwpl
0 stars 0 forks source link

[RevisionMachine] Encoding problems with contributor names in revisions table #40

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Database entries in revisions.ContributorName seem to have encoding problems. 
Umlaut characters are not shown correctly.

Original issue reported on code.google.com by oliver.ferschke on 27 Jul 2011 at 7:19

GoogleCodeExporter commented 9 years ago 
This actually was not a problem with the RevisionMachine.
I just messed up the sql import which was a bzip2 decompression stream piped 
via stdout to mysql. Here, you have to declare the standard encoding

bzip2 -dc DATABASE.sql.bz2 | mysql -uUSER -p -hHOST -default_character_set utf8 
DATABASENAME

Original comment by oliver.ferschke on 28 Jul 2011 at 8:26

GoogleCodeExporter commented 9 years ago 
Correction:
The parameter is --default_character_set utf8
with double dashes

Original comment by oliver.ferschke on 28 Jul 2011 at 8:27

GoogleCodeExporter commented 9 years ago

Original comment by oliver.ferschke on 16 Feb 2012 at 1:24