National characters corrupted in db (not utf8?)

Hi,

I have a problem with Polish characters. They are completely incorrect in the database.

I think I have set everything to utf-8 but I won't give my arm.

Other scripts (drupal etc) don't have this problem on my machine.

Do know how to sove this?

Regards,

Greg

  • Hi,

    I've installed elgg1.6.1 and db default seeting is uft8-unicode_ci collation, i can publish chinese ports in my blog and dispaly correctly,but  i checked db, all the characters are incorrect and SEARCH does not work for chinese characters ad the chinese tag does not work either.

    db details below:

    SHOW VARIABLES LIKE 'character%';

    Variable_name Value
    character_set_client utf8
    character_set_connection utf8
    character_set_database utf8
    character_set_filesystem binary
    character_set_results utf8
    character_set_server utf8
    character_set_system utf8
    character_sets_dir

    /usr/share/mysql/charsets/

    please help me out here, thanks in advance.

  • neusns, there are 2 mostly unralated problems in your Elgg, AFAICS

    1. With shown SHOW VARIABLES you have correcct data internally in DB (I'm sure!), you just have to have correct client to show data for you (UTF8-capable client, in short)

    2. Search and tags for 8-or-more bits languages was broken in 1.6.1 and fixed only in (unpublished) 1.6.2, which can be found in SVN-repo

    HTH

  • Thank you so much for Alexander, i got it.

    i look forward to publishing 1.6.2

     

     

  • 1.6.2 was scrapped because of major bugs that needed to be fixed.  All changes from 1.6 were rolled into 1.7, which is currently in alpha testing.  See  http://news.elgg.org/pg/blog/brett/read/93/a-call-to-developers-collaboration-and-elggcamp-ba for more information.

    Also, the suggestions offered here by non-core developers are unsupported and will probably cause data loss during the migration between 1.6 and 1.7 because of how the tables have to be re-encoded.  Please remember when you alter core, you risk not being able to upgrade.

  • ...and if you not alter core, you risk to get not usable site

  • 1.7, which is currently in alpha testing

    Will we get full build for testing, not just core? Because questions in my pp.2-5 are outside the core

    BTW, when I'll see correctly and fully written I18n'ed head of /views/default/page_elements/header.php

  • @Alexander - Have you submitted tickets to trac (http://trac.elgg.org) about header.php?  Even better, have you submitted a patch as outlined in http://docs.elgg.org/wiki/Development/Contributing/Patches ?

    Both of these will expedite getting any bug or issue resolved.

    Concerning 1.7 alpha: No, there is no package yet. The alpha is intended only for developers at this point.  Once it reaches beta / RC stage it will be packaged for wider testing by other users.