CMS What is the apposite MySQL charset choice for Publishing suite 4 Hello I intened to install vbulletin publishing suite on my account on HostGator. before that I must create a database through phpmyadmin* am I right ? I intend to support both Arabic and english language in my suite my question is : What is the proper MySQL charset/collation that I can choose for the datebase regarding that I want to avoid rapid increasing in database size by choosing inefficient charset. what is the meaning of this (tip) from MySQL 5 reference manual To save space with UTF-8* use VARCHAR instead of CHAR. Otherwise* MySQL must reserve three bytes for each character in a CHAR CHARACTER SET utf8 column because that is the maximum possible length. For example* MySQL must reserve 30 bytes for a CHAR(10) CHARACTER SET utf8 column. UCS-2 cannot be used as a client character set* which means that SET NAMES 'ucs2' does not work. (See Section 9.1.4* “Connection Character Sets and Collations”.) Thank you:confused: |
الساعة الآن 07:50 AM |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir