1
sadistiko
Upgrade 2.0.18/2.2.4 to 2.3.3 UTF-8 database problem
  • 2009/3/23 11:00

  • sadistiko

  • Friend of XOOPS

  • Posts: 477

  • Since: 2004/12/13


This was for sure asked many times, but for me today search option doesnt work! Why? don't know
Ok, this is my problem.
I have 2.0.18 site (also later will upgrade one more 2.2.4) and when I upgrade (locally for now) everithing pass well. New 2.3.3 XOOPS looks ok, but all text is lost where is used croatian special caracters like ž?.
I tried several times to use UTF-8 general_ci, and some other options for conversion of database but with no success.
If I use upgrade without change, I get ? char for all croatian specific characters and this would be big work to change all chars manually. Easier would be new fresh install and copy and paste from old site.

Any sugestions?

Thanks in advance
Croatian Xoops support site:
http://www.xoopshr.org
Lowcost linux hosting:
http://www.adpgroup.hr

2
Anonymous
Re: Upgrade 2.0.18/2.2.4 to 2.3.3 UTF-8 database problem
  • 2009/3/23 11:39

  • Anonymous

  • Posts: 0

  • Since:


Hi,

Find the file language/your-language/global.php

At the bottom of this file you'll see a setting for the default character set and language. Edit this and make it the same as your previous 2.0.x settings (same setting in same file).

3
sadistiko
Re: Upgrade 2.0.18/2.2.4 to 2.3.3 UTF-8 database problem
  • 2009/3/23 17:55

  • sadistiko

  • Friend of XOOPS

  • Posts: 477

  • Since: 2004/12/13


Yes, that would be one solution. Not best one, but hope this could work. I want convert all my (clients) sites to UTF-8 because of future upgrades.
Croatian Xoops support site:
http://www.xoopshr.org
Lowcost linux hosting:
http://www.adpgroup.hr

4
vaajte
Re: Upgrade 2.0.18/2.2.4 to 2.3.3 UTF-8 database problem
  • 2009/5/3 18:30

  • vaajte

  • Just popping in

  • Posts: 4

  • Since: 2005/2/10


Hi, I have the same problem. I had only one language setting (English) and everything was OK before I upgraded. All Finnish characters (äåö) make rest of the data to disapper. I changed language settings to
define('_CHARSET', 'ISO-8859-1');
with no help. I checked that my mysql-database is set on Finnish...
Apua! That's Help in Finnish

Login

Who's Online

218 user(s) are online (159 user(s) are browsing Support Forums)


Members: 0


Guests: 218


more...

Donat-O-Meter

Stats
Goal: AU$15.00
Due Date: Jun 30
Gross Amount: AU$0.00
Net Balance: AU$0.00
Left to go: AU$15.00
Make donations with PayPal!

Latest GitHub Commits