ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Russian characters not saving to database

June 19, 2012 12:11pm

Subscribe [3]
  • #1 / Jun 19, 2012 12:11pm

    circa1977

    118 posts

    Hello,

    I’m trying to store Russian content in 1 field in an entry that is otherwise Latin-based.

    When I hit Submit to save the entry, the value in that field is not saved to the database. The field is empty in the database.

    If I enter the value directly into the database field, it persists, and when I load the entry screen in the CP, I can see the value in the field. When I save the entry again, though, the value disappears—It’s not saved again.

    EE: 2.5.2, 20120606
    PHP: 5.3.6 (MAMP Pro)
    MySQL: 5.5.9
    MySQL charset: UTF-8 Unicode (utf8)
    exp_channel_data collation: utf8_general_ci (as well as all tables/fields)
    Config values:

    $db['expressionengine']['char_set'] = 'utf8';
    $db['expressionengine']['dbcollat'] = 'utf8_general_ci';

    Am I missing anything? Should this just work?

    Thanks,
    Mark

  • #2 / Jun 20, 2012 11:27am

    Dan Decker

    7338 posts

    Hi circa1977,

    I’m sorry for the problems you are having, this certainly should be working as you expect.

    I was unable to replicate the issue on my sandbox, so there must be something unique to your setup.

    Do you have any third-party add-ons installed? What kind of channel field are you attempting to save into?

    I look forward to your reply!

    Cheers,

  • #3 / Jun 20, 2012 11:32am

    circa1977

    118 posts

    Hi Dan,

    It’s just a text input field (for now).

    So far I only have:

    * Assets
    * Structure
    * Wygwam
    * Zoo Flexible Admin

    installed. RTE is disabled.

    Here’s the setup for the channel fields: http://www.circa1977.net/snap/channel-fields.png

    Thanks,
    Mark

  • #4 / Jun 20, 2012 1:19pm

    circa1977

    118 posts

    Hi again,

    I just deployed the site to my Staging server and tried things and it works there - Just not in my MAMP Pro environment locally.

    It’s not an EE issue then, but any thoughts as to why that would be?

    Thanks,
    Mark

  • #5 / Jun 20, 2012 1:32pm

    circa1977

    118 posts

    If I switch MAMP Pro from PHP 5.3.6 to PHP 5.2.17, I’m able to save the Russian text.

    The server is PHP 5.3.5.

    Mark

  • #6 / Jun 21, 2012 1:58pm

    Shane Eckert

    7174 posts

    Hey circa1977,

    Thanks for letting us know!

    Is there anything else we can help you with?

    Cheers,

  • #7 / Jun 21, 2012 2:00pm

    circa1977

    118 posts

    I’d love to know if it’s a PHP version thing or a server thing if anyone has any insight…

    Other than that, I have what I need to work on the site build and run it on the Staging server. Thanks!

  • #8 / Jun 22, 2012 3:53pm

    Shane Eckert

    7174 posts

    Hey circa1977,

    I am not sure, but I think it’s a server configuration issue. I have not seen this before and if it was a PHP version issue, I think I would have.

    I am glad that things are good now.

    If you need anything else, please just let me know by opening a new thread.

    Cheers,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases