Will the database convert to "utf-8" after upgrade to VB5 ?
Collapse
X
-
-
it encoding of HTML Character Set not Character Set of databaseComment
-
So the database for this forum will remaining the same after upgrade to VB5? "iso-8859-1"
Because of that I asked this question
I wish it will not cause any issue with special characters
Also, it will be great if vbulletin can provide a tool to convert the database to utf-8Signature test :)Comment
-
Any update about this question?
Different encoding (database and board), thread IDs being changed, no styles and plugin compatibility
Not so easy to upgrade from vB4 to vB5Comment
-
Comment
-
There is a little confusion about databases and UTF-8...
- MySQL 4.1 and higher can store data as UTF-8. This is based on the Character Set defined. Character set determines how the data is presented in queries. Collation determines the sort order of characters. Many MySQL Servers default to Latin1 though in newer versions of MySQL that was changed to UTF-8. Newer installs of MySQL should use UTF-8.
- vBulletin 3 and 4 can talk to MySQL in UTF-8 as long as you're using the MySQLi classes provided.
- The character encoding of the HTML output has nothing to do with MySQL and how it stores data. It tells the browsers how to interpret the characters and display them. Ideally it should match MySQL's character set. So if you're using a Latin1 database, it should be ISO-8859-1. If you're using UTF8 then it should be UTF-8.
The issue with vBulletin and UTF-8 lies a lot in the programming and how to interpret characters and years of use. Some characters have to be interpreted by ICONV and are turned into HTML entities. Others are passed through. There are also some PHP Functions that don't take UTF-8 into account. This is why when people try to convert to UTF-8 they get problems with characters. These are often problems we cannot solve. It is only a real problem in older forums and when you move servers. When you move servers, the character set can cause problems due to interpretation. Especially if they do not match character sets on both servers.
On new installs with the MySQL character set to UTF8 and the collation set to utf_general_ci or one of the other UTF8 collations, using MySQLi and telling vBulletin to speak in UTF-8 in the /core/config.php file then there will be very few problems in the system. Same for vBulletin 3 and vBulletin 4. Searching on the other hand brings a new set of issues with certain languages, predominantly Asian, which don't have stop characters like Middle Eastern and European languages. This is on new systems.
On old systems, the issue is converting data stored as HTML entities back into actual characters during conversion. Or dealing with sites that have multiple languages and specify different character encodings for the language. The same entity can be different characters under different HTML encodings.Translations provided by Google.
Wayne Luke
The Rabid Badger - a vBulletin Cloud demonstration site.
vBulletin 5 APIComment
-
That is exactly the problem for those who need special characters.
Upgrading to vB5 the database remains on ISO-8859-1, whilst page encoding will change to UTF-8.
That is not ideal, as you said.
How do we solve this, should we convert database from ISO to UTF-8 before upgrading?
ThanksComment
-
One of my sites vB4, uses UTF-8 (charset and database) and each time I upgrade I create a new database and convert collation to UTF-8 before I restore.
I restore the database and make sure all is ok, then I upgrade...And I uncomment the UTF-8 line in my config.php... I never had any issues.To be or not to be... Where the hell is the question????My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too
Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16
Comment
-
One of my sites vB4, uses UTF-8 (charset and database) and each time I upgrade I create a new database and convert collation to UTF-8 before I restore.
I restore the database and make sure all is ok, then I upgrade...And I uncomment the UTF-8 line in my config.php... I never had any issues.
Any official answer on this issue ?Comment
-
Translations provided by Google.
Wayne Luke
The Rabid Badger - a vBulletin Cloud demonstration site.
vBulletin 5 APIComment
-
My database is on latin1-
Wayne, you look like a great guy and you are used to give well detailed answers.
Please just let me say that my question still keeps unanswered.
I am asking vBulletin how do I upgrade my forum form vB4.2 to vB5 being my database on latin1- ?
Should I convert my database to UTF-8 before upgrading ?
ThanksLast edited by manebe; Mon 17 Sep '12, 7:06am.Comment
-
Which is not equal to ISO-8859-1. ISO-8859-1 is the encoding predominantly for English. Latin1 is a lot more than English.
I am asking vBulletin how do I upgrade my forum form vB4.2 to vB5 being my database on latin1- ?
Shoul I convert my database to UTF-8 before upgrading ?
You can attempt to follow his example but we will not certify the outcome.Translations provided by Google.
Wayne Luke
The Rabid Badger - a vBulletin Cloud demonstration site.
vBulletin 5 APIComment
-
Should I keep database on latin-1 and board on UTF-8 ?
That is not ideal as we all know, could cause issue with special charcaters rendering.
Let me remember that my database is not so old,
it has been created 1 year ago in a fresh installation of vB 4 !Comment
Related Topics
Collapse
-
by Panni100Does anyone know if I Will I need to use the same database as VB4 when upgrading to VB5? or create a new one of VB5? Thanks in advance.
-
Channel: vBulletin 5 Installs & Upgrades
Wed 27 Feb '13, 10:16am -
-
by mrscotI've installed a fresh version of VB5 and would like to import my database from VB4 into my new version of VB5. What's the best approach for me to do this?
-
Channel: vBulletin 5 Installs & Upgrades
Tue 2 Jan '18, 12:58pm -
-
by interfxI have a client with an existing VB4.2 site that has 30K posts | 4K members on a dedicated server and the client really likes VB5 look and feel, some of the usability areas... Without upgrading the site,...
-
Channel: Support Issues & Questions
Tue 3 Dec '13, 7:48am -
-
I have a forum running VB4.2.2 which I am thinking of converting to VB5. however I don't have enough data to test VB5 properly. Is is possible to install VB5 in a sub directory and use the same database...
-
Channel: Support Issues & Questions
Thu 26 Dec '13, 10:43am -
-
by SteamGamersI have a copy of the Advanced Application Forms: http://www.vbulletin.org/forum/showthread.php?t=289291 and want to upgrade it to work with vb 5.1.1. However, I cannot find anything on the vb5 changelog...
-
Channel: Support Issues & Questions
Tue 10 Jun '14, 10:46am -
Comment