Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    1

    Unanswered: Problem with encoding russian text to mysql

    Hallo

    I have a problem with importing database to mysql; with encoding russian symbols.
    when i import database through phpMyAdmin (or just make query) to mysql, russian text is written like "?????? ????" instead "russian text".

    Example: http://sushko.net/xlam/problem.sql

    I tried to convert text to utf8, win-1251 and so on, but no results.. words are "?????" or other strange like "—œ–™" that browsers can't understand.

    SET NAMES 'utf8'; doesn't help too

    will anybody help me?
    thank you
    Last edited by Tonyyy; 06-05-12 at 04:11.

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Hi Tonyyy,

    I have encountered this type of problem in the past. If I can remember it had something to do with the file character set is encoded in. In Linux/UNIX there is a utility called "file" which shows the character set used in the file:

    Code:
    $ file toto.sql
    toto.sql: UTF-8 Unicode text
    Check this to make sure that it is being imported using the correct character set otherwise this will lead to issues you have mentioned above.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •