Welcome to Geeklog Thursday, September 20 2018 @ 04:04 pm EDT

Geeklog Forums

Unicode


Status: offline

samstone

Forum User
Full Member
Registered: 29/09/02
Posts: 820
What's your server control panel? Is it CPanel? Do you have a PHPmyAdmin?

Sam

Status: offline

trampoline

Forum User
Full Member
Registered: 24/02/06
Posts: 392
I have OS X Server 10.4.11
SQL Administrator
Navicat
I could install PHPMYAdmin

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/02
Posts: 820
I don't know about SQL Administrator, but PHPmyAdmin would let you easily dump the data the way you want it, or you have to use the commandline.

Sam

Status: offline

trampoline

Forum User
Full Member
Registered: 24/02/06
Posts: 392
OK I have done it,
It took 20 minutes..
I used Mark's tutorial

at http://www.gllabs.org/wiki/doku.php?id=geeklog:utf-8

I downloaded ICONV with Darwin ports on my OSX machine.

I Used BBedit to change the Latin to utf-8 encoding (96) occurances in the text file.

Verified the output with ICONV

Uploaded the result to the new database

Changed the database that the site uses...

Done...

Thanks Everyone...


All times are EDT. The time is now 04:04 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content