Announcement

Collapse
No announcement yet.

Problems with special characters

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problems with special characters

    Hello Everyone,
    i have my first application in the pipe and as far as good to set it up on production server.
    But i encountered problems with the "umlauts" sepcial characters. I am using MySQL with UTF-8_general_ci. And php.ini with default charset. And SC Version 8.
    From my developement enviroment everything look alright. But uploaded to the webserver, special characters from database source appear as questiontag while text embbeded in php appear correct.
    umlaute.jpg

    When i make a new Entry to Database using the form application then i see it correctly. but in the database it is saved as follow
    sc_view.jpg

    I think it come from the database or? Has anyone an hint?

    thanks in advance!

  • #2
    Hi,
    to make sure your MySQL server AND client is set to utf8, run the following commands.
    If you don't get the expected result, adjust your configuration accordingly.

    SHOW VARIABLES LIKE 'character_set%';

    Verify that they're all utf8, except ..._filesystem, which should be binary and ..._dir, that points to the charset directory of the mysql installation

    SHOW VARIABLES LIKE 'collation%';

    They should all be utf8_general_ci.

    Also I would suggest to set your php.ini to utf. default_charset = "UTF-8".

    jsb

    Comment


    • #3
      thanks jsb!
      I am quiet not sure what i did wrong but now it works. First i went through the current settings. Without help. Then I erased the database and set it up again from scratch. And paying attention that all is set on utf-8. i set the value in php.ini on utf-8 and now it works correctly.

      greetings to halifax!

      Comment


      • #4
        i have my first application in the pipe and as far as good to set it up on production server.
        But i encountered problems with the "umlauts" sepcial characters. I am using MySQL with UTF-8_general_ci. And php.ini with default charset. And SC Version 8.
        Last edited by shahjee1; 10-06-2014, 12:57 AM.
        Subscribe for Testking Testking LX0-102 training and pass your Union Theological Seminary exam in first attempt. Get guaranteed success using Aruba braindumps and other resources.

        Comment

        Working...
        X