1
Yurdal
Convert latin1_swedish_ci to UTF-8
  • 2015/11/10 18:45

  • Yurdal

  • Friend of XOOPS

  • Posts: 375

  • Since: 2005/3/27


Is there a some kind of converter to do this automatically ?

I did found here a converter but it didn't correctly convert the publisher database

At this moment i have latin1_swedish_ci

2
Mamba
Re: Convert latin1_swedish_ci to UTF-8
  • 2015/11/10 19:04

  • Mamba

  • Moderator

  • Posts: 11245

  • Since: 2004/4/23


What was the problem, and which tool did you use? The Convert_mysql from montuy337513?

You can also try CDC: http://bobsguides.com/convert-db-utf8.html
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

3
Yurdal
Re: Convert latin1_swedish_ci to UTF-8
  • 2015/11/10 19:18

  • Yurdal

  • Friend of XOOPS

  • Posts: 375

  • Since: 2005/3/27


Hi Mamba, yes i did used the first one, but it doesnt works very well

I will try the second one, thanks for your help

4
Roby73
Re: Convert latin1_swedish_ci to UTF-8
  • 2015/11/15 0:01

  • Roby73

  • Friend of XOOPS

  • Posts: 262

  • Since: 2011/6/15


Try with module backup, i converted all db in utf-8.
The module can't modify or broken system database, you can create one copy in other database. If all is correct, set the copy database as the system and modofy old system db.

5
Yurdal
Re: Convert latin1_swedish_ci to UTF-8
  • 2015/11/24 20:37

  • Yurdal

  • Friend of XOOPS

  • Posts: 375

  • Since: 2005/3/27


Hi Roby, im still struggling with this problem, i have to convert to utf-8 because im upgrading from 5.3 php to 5.4 and that this gives problems with some (Turkish) characters

Can you give me a step by step guide to accomplish this ?

Thanks

6
Mamba
Re: Convert latin1_swedish_ci to UTF-8
  • 2015/11/24 22:10

  • Mamba

  • Moderator

  • Posts: 11245

  • Since: 2004/4/23


One method:
1) Export out of phpMyAdmin the whole database in your default latin1_swedish

2) open the document in something like Notepad++

3) convert the document inside Notepad++ as UTF-8 and save it

4) import into phpMyAdmin

Make sure you do a backup, and then test it before you go live with it.
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

Login

Username:
Password:

Lost Password? Register now!

Who's Online

84 user(s) are online (48 user(s) are browsing Support Forums)


Members: 0


Guests: 84


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits