Results 1 to 2 of 2

Unicode content

This is a discussion on Unicode content within the General Discussion forums, part of the vBSEO SEO Plugin category; If we convert a forum Mysql DB from latin1_swedish_ci to utf8_unicode_ci we have to convert exisiting posts too? Or can ...

  1. #1
    Junior Member
    Real Name
    Gareth Boyd
    Join Date
    Jul 2007
    Posts
    5
    Liked
    0 times

    Unicode content

    If we convert a forum Mysql DB from latin1_swedish_ci to utf8_unicode_ci we have to convert exisiting posts too? Or can we run the existing posts in utf8_unicode_ci tables while new posts added as utf8_unicode_ci ?
    How this will effect performance and what you recommend?

    i am going to use vbseo in this forum and it has around 8 million posts.

  2. #2
    vBSEO Staff Brian Cummiskey's Avatar
    Real Name
    Brian Cummiskey
    Join Date
    Jul 2009
    Location
    btwn NYC and Boston
    Posts
    12,789
    Liked
    657 times
    Blog Entries
    2
    If the table is converted, the post content should be converted as well. Mix-match will likely result in errors.

    I HIGHLY suggest exporting to a temp db and playing with it before even attempting something like this on a live db. Hiring a freelancer DBA may be advisable as well.

Similar Threads

  1. vBulletin 4.x Unicode Postings URL setting is correct?
    By penmai.com in forum Troubleshooting
    Replies: 15
    Last Post: 05-18-2011, 01:41 PM
  2. vBulletin 4.x LinkBacks Box - Unicode Character errors
    By dihuta in forum Bug Reporting
    Replies: 15
    Last Post: 12-22-2010, 12:00 AM
  3. Friendly URL Unicode (UTF-8)?
    By ViktorDA in forum URL Rewrite Settings
    Replies: 11
    Last Post: 03-23-2010, 10:25 AM
  4. Special unicode character replacement
    By laittnet in forum General Discussion
    Replies: 33
    Last Post: 08-17-2009, 07:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •