https://www.icyphoenix.com/viewtopic.php?f=35&t=8755&p=57173#p57173
-----------------------------------
omarska
Mon 22 Oct, 2012 21:33

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.
[hr]
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]Username: omarska Password: MightyGorgon126654[/spoiler]
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]
š = OK
đ = LOST
č = LOST
ć = LOST
ž = OK
Š = OK
Đ = OK
Č = LOST
Ć = LOST
Ž = OK
[/spoiler]

Serbian cyrilic characters all survived.

I have found similar [url=http://www.icyphoenix.com/viewtopic.php?f=2&t=8666]topic by [url=http://www.icyphoenix.com/profile.php?mode=viewprofile&u=7660]Costa, and [url=http://www.icyphoenix.com/viewtopic.php?p=56790#p56790]solution by [url=http://www.icyphoenix.com/profile.php?mode=viewprofile&u=85]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.


