Announcement

Collapse
No announcement yet.

MySQL UTF8 problem

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

  • MySQL UTF8 problem

    How to set my MySQL datebase, so that the Chinese characters can be displayed correctly when I use phpmyadmin to view it?

    The scriptcase claims that all multibyte characters will be stored as UTF8, but when I set my MySQL default character set to UTF8, it still show strange character.


  • #2
    Re: MySQL UTF8 problem

    Hi,

    This is happen when you execute the app ?

    Comment


    • #3
      Re: MySQL UTF8 problem

      I think client_encoding is the best solution for this but it does not work on mysql.

      My solution is below:

      On each application, Settings>Events>onScriptInit write the code below:
      sc_exec_sql("set names 'utf8'");

      -------------------------------------------------------------
      Integrate your Scriptcase applications to Joomla!
      http://www.ilerian.com

      Comment


      • #4
        Re: MySQL UTF8 problem

        [quote author=thinker link=topic=1560.msg6015#msg6015 date=1285275529]
        Support is like a joke. They send a message for each day. I could not make them believe that there is an UTF8 problem.

        I think client_encoding is the best solution for this but it does not work on mysql.

        My solution is below:

        On each application, Settings>Events>onScriptInit write the code below:
        sc_exec_sql("set names 'utf8'");
        [/quote]

        The connection has a parameter that already set that, hasnt? client_encoding set automatically after the connection this parameter.

        Comment


        • #5
          Re: MySQL UTF8 problem

          I saw the advanced tab and client_encoding. But It does not work for mysql.

          Comment


          • #6
            Re: MySQL UTF8 problem

            let me test.

            Comment


            • #7
              Re: MySQL UTF8 problem

              Can you confirm if isnt working on development environment or only on the deployed environment?

              Comment


              • #8
                Re: MySQL UTF8 problem

                It does not work on both development and deployment.
                Application can not display mysql db content correctly with utf8 collation.

                -------------------------------------------------------------
                Integrate your Scriptcase applications to Joomla!
                http://www.ilerian.com

                Comment


                • #9
                  Re: MySQL UTF8 problem

                  [quote author=thinker link=topic=1560.msg6015#msg6015 date=1285275529]
                  My solution is below:

                  On each application, Settings>Events>onScriptInit write the code below:
                  sc_exec_sql("set names 'utf8'");
                  [/quote]

                  I was having the same problems. My app's languages are English and French with a lot of French characters in the MYSql db. The grid was not displaying French characters. English and French Languages set to UFT-8.

                  The above solution worked. A reference to the MYSQL - SET NAMES can be found at: http://dev.mysql.com/doc/refman/5.5/...onnection.html

                  Comment


                  • #10
                    Re: MySQL UTF8 problem

                    Try to make a new user on your db but not superuser and change connection.
                    MySql superuser got trouble with UTF-8 probably...

                    Comment

                    Working...
                    X