1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Fixed Character Bug after import

Discussion in 'Resolved Bug Reports' started by Mert, Oct 6, 2010.

  1. Mert

    Mert Well-Known Member

    There is a major bug within Profile Comments. Non English characters display correct on regular forum topics however they are messed up within profile comments.

    The display in profile comments is as following

    Tanýdýðýma çok memnun olduðum hoþ sohbet insan :D keþke cey de olsaydý artýk bi daha ki sefere :)
  2. Mike

    Mike XenForo Developer Staff Member

    I see the code to convert to UTF-8, but that looks like it might be a double conversion.

    What collation are you using for the tables you're importing from? Is it inconsistent?
  3. Mert

    Mert Well-Known Member

    These are from old db

    collation_connection	latin1_swedish_ci
    collation_database	utf8_general_ci
    collation_server	latin1_swedish_ci
    The issue can be re producable on all profile messages and it only happens within profile messages.
    Can't say anything about PM's as they currently fail to import but all other parts of the site , urls are correctly converted and displaying correct
  4. Andy.N

    Andy.N Well-Known Member

    Yes, looking at my phpadmin, it shows the XF database collation is latin1_swedish_ci.
    Should I do something on my VB database before I import into XF?
  5. Mike

    Mike XenForo Developer Staff Member

    It looks like the visitormessage table was utf8, while all the other tables were latin1. The data stored in the VM table was actually utf8, and appears to have been converted to latin1 on the fly.

    I believe I have a workaround for this issue now, and it should hopefully help the PM import issue too.

Share This Page