Icy Phoenix

Old Support Topics - Characters Lost After DB Conversion To UTF-8

omarska [ Mon 22 Oct, 2012 21:33 ]
Post subject: Characters Lost After DB Conversion To UTF-8

Hi all. First to mention that I am writing from my friend's account - we are both admins of our little site www.omarska.net. He was an active member of IP comunity a few years ago, but now he is very bussy with other stuff.

When I found about IP 2.0 I was very pleased to read about it. Therefore I have created a copy of our site (both DB and files) and performed an upgrade. Everything is done, but final result contains some errors.

Tehnical data:
Old version: 1.3.0.53b - avaiable at www.omarska.net
New (upgraded) version: 2.0.0.86 - avaiable at www.omarska.net/icyphoenix/
Use following credentials to access it

Spoiler: [ Show ]

PHP version: 5.2.17
MySQL version: 5.1.65-cll

The problem:
After DB conversion to UTF-8 some serbian latin characters with diacritics have been lost and now are unreadable. Here is the outcome both for lower case and upper case:

Spoiler: [ Show ]

Serbian cyrilic characters all survived.

I have found similar topic by Costa, and solution by TheSteffen but I'm not sure if I can use it in my case.

Second problem:
After clicking on ACP link, nothing happens except sid is added at the end of the URL. The only way I have discovered how to login to ACP is to click on CMS link, and after logging into CMS, I can switch to ACP.

Can anybody help with my problems? No rush, of course

Any help will be appreciated.

Regards,
M.

Limun [ Tue 23 Oct, 2012 07:06 ]
Post subject: Re: Characters Lost After DB Conversion To UTF-8

can you please check your NEW , upgraded database Collation

BTW affter i saw your topic i checked my databases .

Results :

Upgradet databases : was on utf8_bin
Fresh databases 2.0 : one base utf8_bin
and one base was on latin_swedish

i found for me a solution to convert al to utf8_general_ci

result :

so if you want i can attach my edited "convert_utf8_nodbal.php"

omarska [ Tue 23 Oct, 2012 12:54 ]
Post subject: Re: Characters Lost After DB Conversion To UTF-8

Thank you for your reply.

MySQL connection collation: utf8_general_ci

Upgraded database collation utf8_bin.

Collation of tables inside my upgraded DB utf8_bin.

There are some tables with prefix _old and collation of those tabels is different. I guess they are not used after the conversion process.

So, you have modified "convert_utf8_nodbal.php" to create utf8_unicode_ci tables? Sure, I would like to try it.

M.

Limun [ Tue 23 Oct, 2012 13:09 ]
Post subject: Re: Characters Lost After DB Conversion To UTF-8

yep and here it is

BTW backup your database before

let me know if you solved problem with characters

then will see about ACP

Joshua203 [ Tue 23 Oct, 2012 15:18 ]
Post subject: Re: Characters Lost After DB Conversion To UTF-8

Off Topic
:
omarska wrote: [View Post]
First to mention that I am writing from my friend's account

Please create your own private account to avoid further confusion, it will only take you a couple of minutes and it's free .. thanks in advance

Also.. try to post only 1 problem per thread, so please open another thread for the second question ..again .. thanks in advance

Joshua203 [ Tue 23 Oct, 2012 22:26 ]
Post subject: Re: Characters Lost After DB Conversion To UTF-8

Off Topic
:
About your second bug (ACP problem) ...

Would you like to post this in the bugtracker yourself omarska? I confirm it is a bug, since this is even happening at this site

http://www.icyphoenix.com/bugs.php
If you don't have access there please let me know.

TheSteffen [ Thu 25 Oct, 2012 10:58 ]
Post subject: Re: Characters Lost After DB Conversion To UTF-8

omarska,
You still have problems?

What is the collation of the old (IP 1.3) database?
And what letters are there, what language? Serbian?

Joshua203 [ Fri 26 Oct, 2012 16:07 ]
Post subject: Re: Characters Lost After DB Conversion To UTF-8

Off Topic
:
I've already reported the acp bug in the bugtracker for you.. http://www.icyphoenix.com/bug.php?bid=132

Mighty Gorgon [ Sat 17 Nov, 2012 12:33 ]
Post subject: Re: Characters Lost After DB Conversion To UTF-8

omarska, did you solve your issue?