Skip to:
Content
Pages
Categories
Search
Top
Bottom

From Latin1 to UFT8 – Issues

  • Hi

    I’ve built a website for teaching Irish, which has á é í ó ú in it’s alphabet (you probably know where this is going). I saw that my database was set to UTF8_general_ci but noticed when creating post, the post cut off after an accented letter.

    I then followed the steps to convert the DB to latin1 and changed the ‘Reading’ under the WordPress dashboard to latin1 and this solved the problem for posts.

    However, it seems that the Buddypress Posts and AJAX functionality ignore the latin1 characterset from WordPress as it displays the accents as strange characters. E.g. tést is appearing as tést when I post something from a group ‘Whats new in Group A’.

    If anyone has any ideas it would be greatly apperciated as since its a language website, these characters (á é í ó and ú for Irish) are very important.

    Thanks
    Dónal

Viewing 11 replies - 1 through 11 (of 11 total)
  • Avatar of James
    James
    Participant

    @janismo

    hi,

    have same/similar issue with other two non english languages.
    when I post update all non english (non latin/roman) letters appear as unknown symbols. After refresh all changes back to normal view.

    is there any known fix, or it is some normal ajax behaviour?

    thanks.

    Avatar of danbpfr
    danbpfr
    Participant

    @chouf1

    Instead of html entities for your accentuated caracters (& ea cute ; for é ) used in your buddypress-xx_XX.po language file, use octals for any message displayed by javascripts !

    http://www.pjb.com.au/comp/diacritics.html

    Avatar of James
    James
    Participant

    @janismo

    @chouf1

    thanks for reply,
    even if I would find necessary octals for my language, it still would not solve my issue, since biggest problem is updates and, of course, I can not ask my users to use octals in their updates.

    at the moment they will have to refresh page after every update, maybe some other solutions?

    can plugin “RS activity refresh…” solve this issue?
    maybe I should completely switch off javascripts for updates?

    Avatar of danbpfr
    danbpfr
    Participant

    @chouf1

    @James
    I don’t realy know what is your problem. What i can s&y is that my DB has the following settings
    language: french
    DB caracters table: UTF-8 Unicode (utf8)
    DB settings utf8_general_ci

    If you need to use octals to translate some javascript messages, use them in your xx_XX.po file or create another xx-XX..po to translate your specific messages.
    http://codex.buddypress.org/developer-docs/translations/

    What you said here: http://buddypress.org/community/groups/how-to-and-troubleshooting/forum/topic/buddypress-localization-issues/ let me think you have troubles because you use 3 different languages.
    I would recommand you to test first with one language. When this works correctly, try separatly with the others.

    After that it would be probably better for you to use a multilingual plugin like WPML and buddypress multilingual.
    http://buddypress.org/community/groups/buddypress-multilingual/

    It’s also important for you to check all the js files, because most of them are not localized. You can do this manually from within a child theme.
    Normally your visitors has nothing to do with updates. And they have nothing to care about octals.

    Avatar of Boone Gorges
    Boone Gorges
    Keymaster

    @boonebgorges

    @chouf1 – Can you tell me where there are javascript messages that are not being translated? All javascript in BuddyPress is supposed to be localized (though it does use a different technique from __() and _e()); anything untranslated is probably a bug.

    Avatar of James
    James
    Participant

    @janismo

    thanks guys, probably, I have crawled to the wrong kitchen.
    my issue is that during publication of updates (without refresh) all other languages/non english letters are rendered as unknown symbols, after refresh all is fine again.

    checked testbp.org and there all works excellent for every language, so, I am starting to think that issue is my localhost not bp, because I really can not assume what is the difference between testbp.org and my page, because during every necessary step/installation I used utf-8.

    Edit: what I said here: http://buddypress.org/community/groups/how-to-and-troubleshooting/forum/topic/buddypress-localization-issues/ is still an opened question with no response.

    thanks again.

    Avatar of danbpfr
    danbpfr
    Participant

    @chouf1

    @boonebgorges
    apologize, BP js message are actually all translatable… i meant plugins – which are third parties stuff.
    Sometimes confusing because these plugins are not localized correctly, or using old modified BP phrase, are delivered with missing pot file and so on… :-(

    Avatar of James
    James
    Participant

    @janismo

    as I thought, issue was in my localhost and utf-8.
    thanks to all.

    Hi James
    When you say it was in your local host, do you mean in your DB – can you explain further please and I’ll try that out on my site
    thanks

    p.s. I had a look at the phpMyAdmin settings and for localhost it has

    MySQL localhost
    MySQL connection collation: UTF8 (I changed this to latin1_general_ci with no luck)

    I noticed on the right pane it still shows:

    MySQL

    Server: Localhost via UNIX socket
    Server version: 5.0.92-community-log
    Protocol version: 10
    User: accessfo@localhost
    MySQL charset: UTF-8 Unicode (utf8)

    I then noticed this in the server variable settings:

    character set client utf8
    (Global value) latin1
    character set connection latin1
    character set database latin1
    character set filesystem binary
    character set results utf8
    (Global value) latin1
    character set server latin1
    character set system utf8
    character sets dir /usr/share/mysql/charsets/
    collation connection latin1_general_ci
    (Global value) latin1_swedish_ci
    collation database latin1_swedish_ci
    collation server latin1_swedish_ci

    Hi I’ve installed the latest BP and WP and i’ve converted all tables to latin1_general_ci but still having the same problem with the .js groups home page – can anyone please suggest something to try? also when deleting tests from the .js page I’m getting the following error in IE

    Webpage error details

    User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
    Timestamp: Fri, 12 Aug 2011 00:06:31 UTC

    Message: Object doesn’t support this property or method
    Line: 18
    Char: 19570
    Code: 0
    URI: http://www.irishforall.ie/wp-includes/js/jquery/jquery.js?ver=1.6.1

    Message: Object doesn’t support this property or method
    Line: 18
    Char: 19570
    Code: 0
    URI: http://www.irishforall.ie/wp-includes/js/jquery/jquery.js?ver=1.6.1

Viewing 11 replies - 1 through 11 (of 11 total)

You must be logged in to reply to this topic.