Welcome Visitor, Please Login or Register Now Sunday, December 17, 2017 05:51 PM 
Forums Index>Mewsoft>Minor Updates and bug fixes>Webawy 2015 Upgrade Version 21.1 More UTF8 Unicode Support
New Topic   New Reply
Search for:
Author Message
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 12-17-17 05:51 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Webawy 2015 Upgrade Version 21.1 More UTF8 Unicode Support Edit Delete Reply with quote Quote
First Post Posted on: 12-19-16 07:25 PM last post first post

Greatings,


This upgrade supports more unicode letters for some languages besides the general utf8 support

which already exists in the software.


If you are expecting to have content that includes characters in German, Russian, Bulgarian,

Belarusian, Macedonian, Serbian, Ukrainian, etc., the new upgrade will support matching and sorting,

collation for those languages.


The default current SQL database collation was utf8_general_ci, the new upgrade uses collation utf8_unicode_ci.

The new upgade also support utf8 everywhere, all software input and output now in utf8 well formed.


How to apply this upgrade

=================

1)-Backup your entire site and databases to your local computer. This step is very important

2)-Make sure you did installed or upgrade Version 2015 (Version 21.00) First DO NOT UPGRADE TO THIS VERSION NOW.

3)-Download the file upgrade-2015-backup.zip attached to this topic and unzip it, it contains the file upgrade-2015-backup.cgi.

4)-Upload this file upgrade-2015-backup.cgi in ASCII mode to your installation folder app/web

5)-Change this file permissions to 755.

6)-Call this file from browser only Once like this:

     http://yourdomain.com/app/upgrade-2015-backup.cgi

     and wait until the file is finished, do not close the browser before the file is finished.

7)-The above steps will backup all your database files in the old format.

8)-Upgrade to the latest version 21.1.

9)-From your admin->Database, Restore all your database tables by click the link:

     Restore Database From The Text Files Backup

     this will restore your database in the new supported format.

10)-From your admin->Database,click the link "Database Commander".

11)-Enter this text exactly in the Database Commander page:

        ALTER TABLE %%table%% CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

     and wait until the process finish, do not close the browser, it make take long time based

     on your database size.

12)-Your are done.


Mewsoft Support
www.mewsoft.com

File
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print