Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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.
 




____________
Omarska online
 
omarskaSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Characters Lost After DB Conversion To UTF-8 
 
can you please check your NEW , upgraded database Collation

 snapshot1

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 :

 snapshot2

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




____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 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.
 old

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

M.
 




____________
Omarska online
 
omarskaSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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

convert_utf8_nodbal.php.zip
Description: converting to utf8_general_ci 
Download
Filename: convert_utf8_nodbal.php.zip
Filesize: 1.43 KB
Downloaded: 169 Time(s)

 




____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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

 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.

 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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?
 




____________
TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
 
TheSteffenSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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

 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Characters Lost After DB Conversion To UTF-8 
 
omarska, did you solve your issue?
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron