October 25, 2021, 07:13:03 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Donate to FreePgs.
   Home   Help Search Login Register  
Pages: [1]   Go Down
Author Topic: wrong encoding in mysql import  (Read 2197 times)
Non-Verified Account

Karma: +0/-0
Offline Offline

Posts: 1

Blog entries (0)

View Profile
« on: May 15, 2006, 10:32:32 AM »


I have imported the database of my mediawiki site into freepgs, but the encoding is wrong: the file I upload is encoded in UTF-8 but when I import it it's converted into something like ISO-8859-1, and so the page doesn't render right.

The procedure I've followed is:
a) mysqldump the database in my pc. Running "file" on the dump returns "per.sql: UTF-8 Unicode English text, with very long lines"
b) gzip it
c) import it via the freeogs mysqladmin page

I've been considering writing a php script to fix the encodings but there's quite a lot of tables, I'm hoping there's a way to do the import right from the start.

« Last Edit: May 16, 2006, 02:47:57 AM by grimborg » Logged
Pages: [1]   Go Up
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!