Cyrillic alphabet in MySQL

Discussion in 'MySQL' started by jimbojones, Jun 26, 2008.

0
  1. #1
    Hi Everybody,

    I have an MySQL problem :(

    I am making a Russian website but I can´t get the Cyrillic Alphabet to go throught the database and show it correctly in the web browser.

    All I see in the webbrowser is ????? instead of the Cyrillic words I have added in the database.

    Does anyone know what to do? Thanks a lot,

    // Jimbo
     
    jimbojones, Jun 26, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Make sure that the table encoding is CP866 or ISO-8869-5 and the server is set for the same encoding. You may need to manually set a header or something else to force the encoding on the website.
     
    jestep, Jun 26, 2008 IP
  3. vikuz

    vikuz Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Try MySQL command 'SET NAMES cp1251' before work with database.
    And try (for PHP): header('Content-type: text/html; charset=cp1251')

    Texts inside MySQL are stored in what encoding?
     
    vikuz, Jun 27, 2008 IP