xoops forums

AHLIS

Not too shy to talk
Posted on: 2013/3/30 14:46
AHLIS
AHLIS (Show more)
Not too shy to talk
Posts: 189
Since: 2004/12/12
#1

UTF-8 to ISO-8859-1

Hi,

I Recently updated my homepage to 2.5.5, more info under here:

Quote:

XOOPS-version XOOPS 2.5.5
PHP-version 5.3.19
mySQL-version 4.0.27-standard
Server-API cgi-fcgi
OS Linux
safe_mode Off
register_globals Off
magic_quotes_gpc On
allow_url_fopen On
fsockopen On
allow_call_time_pass_reference On
post_max_size 52428800
max_input_time -1
output_buffering 0
max_execution_time 20
memory_limit 268435456
file_uploads On
upload_max_filesize 10485760


I have the latest language files in swedish but they are in utf-8.

Can I somehow edit all files in a easy way to iso-8859-1?

Or is there a easy way to change the database from iso-8859-1 to utf-8?

Need some tip before I start working with this. :)

What will happen if I change from iso-8859-1 to utf-8 directly in phpmyadmin?

Best Regards
Ahlis

Mamba

Moderator
Posted on: 2013/3/30 15:22
Mamba
Mamba (Show more)
Moderator
Posts: 10759
Since: 2004/4/23
#2

Re: UTF-8 to ISO-8859-1

Since your MySQL is < 5.0, this tip might be useful for you.

The best would be to:

- export your DB as UTF8
- update your DB to a version 5.0+, and set it UTF8 as default
- import your DB
- test to make sure that everything in converted properly

Check out also this tip
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

AHLIS

Not too shy to talk
Posted on: 2013/3/30 16:20
AHLIS
AHLIS (Show more)
Not too shy to talk
Posts: 189
Since: 2004/12/12
#3

Re: UTF-8 to ISO-8859-1

Thanks.

I will check your tip.

Cesagonchu

Moderator
Posted on: 2013/3/30 21:43
Cesagonchu
Cesagonchu (Show more)
Moderator
Posts: 864
Since: 2010/2/1 2
#4

Re: UTF-8 to ISO-8859-1

Quote:

AHLIS wrote:
Or is there a easy way to change the database from iso-8859-1 to utf-8?


black_beard did a script for that, you can download it here.

AHLIS

Not too shy to talk
Posted on: 2013/3/30 22:47
AHLIS
AHLIS (Show more)
Not too shy to talk
Posts: 189
Since: 2004/12/12
#5

Re: UTF-8 to ISO-8859-1

Hi,

Thanks for the link.

Will check that.

I have for a moment ago sent a mail to the web host to see if they would help me convert this. If they say no then, the script can come in handy.

Best Regards
Ahlis

AHLIS

Not too shy to talk
Posted on: 2013/3/31 15:02
AHLIS
AHLIS (Show more)
Not too shy to talk
Posts: 189
Since: 2004/12/12
#6

Re: UTF-8 to ISO-8859-1

Hi,

Now the web host has upgrade mysql and I have change iso to utf-8 with the script.

If I check phpmyadmin and COLLATION it says now: utf8_general_ci

Admin and most other function looks okey now with åäö but almost everything we have been eriting before has ? instead of å,ä or ö.

If I change ? to whatever it should be, let say ö, after posting it show me ö.

Has something gone wrong for me or is this something that I have to edit myself?

You can se how it looks like if like: www.roslagsloppet.com then click on "KLUBBSIDAN".

Best Regards
Ahlis

AHLIS

Not too shy to talk
Posted on: 2013/3/31 16:23
AHLIS
AHLIS (Show more)
Not too shy to talk
Posts: 189
Since: 2004/12/12
#7

Re: UTF-8 to ISO-8859-1

I have installed the module "Backup". And it say like this:
Quote:

System Database
Tables in database: 218
character_set_client latin1
character_set_connection latin1
character_set_database utf8
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /share/mysql/charsets/
collation_connection latin1_swedish_ci
collation_database utf8_general_ci
collation_server latin1_swedish_ci

Mamba

Moderator
Posted on: 2013/3/31 17:53
Mamba
Mamba (Show more)
Moderator
Posts: 10759
Since: 2004/4/23
#8

Re: UTF-8 to ISO-8859-1

I would talk to the Host people - it's possible that they didn't converted it properly.
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

AHLIS

Not too shy to talk
Posted on: 2013/3/31 18:35
AHLIS
AHLIS (Show more)
Not too shy to talk
Posts: 189
Since: 2004/12/12
#9

Re: UTF-8 to ISO-8859-1

Okey.

I will do that tomorrow.

Thanks

Best Regards
Ahlis

AHLIS

Not too shy to talk
Posted on: 2013/4/6 19:24
AHLIS
AHLIS (Show more)
Not too shy to talk
Posts: 189
Since: 2004/12/12
#10

Re: UTF-8 to ISO-8859-1

Hi,

Problem fixed now, but I don't know what the Web host did.

Thanks for all help.

Best Regards
Ahlis