GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

different language data in database

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • different language data in database

    hi all,
    I need to put russian data record in db in mysql server, but the record didn't show normal character for russian, and i can't query expected output for the russian data, is there any config or solution to solve it ? thanks!

  • #2
    What is the result of this query:
    SHOW VARIABLES LIKE 'character%';

    Comment


    • #3
      in the database, it is many ? character.
      in the web page after query, it is many odd character.

      Comment


      • #4
        Thats not the proper answer.
        You were supposed to type that statement
        SHOW VARIABLES LIKE 'character%';
        into your client.

        MySQL uses UTF-8 so there should be (in principle) no problem with a russian data-set.

        Comment


        • #5
          The only help I can provide now is suggesting this query before any INSERT or any SELECT:

          SET NAMES 'utf8'

          This also assumes your HTML pages are outputted in UTF-8, that you input correct UTF-8 and that your MySQL configuration is also set to UTF-8.

          Comment

          Working...
          X