I need some help for database convertion

Discussion in 'Databases' started by nasser bahaj, Apr 16, 2012.

0
  1. #1
    Hello

    Please I need your help for converting database to utf8

    I have database of flash games arabic website and I converted the database to wordpress manually but after I installed the database on wordpress the arabic language appeared as a strange chars because of the encoding , the encoding of original DB is windows-1256 and encoding of wordpress database is utf8 , so I have to convert the database to utf8 , I tried alot of convertion methods but no results .

    please can any one help me , I am getting crazy !!

    thank you all
     
    nasser bahaj, Apr 16, 2012 IP
  2. hoangvu

    hoangvu Greenhorn

    Messages:
    75
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #2
    conver it to utf-8, you can use

    mysql_query("SET NAMES 'utf8'");
     
    hoangvu, Apr 16, 2012 IP
  3. nasser bahaj

    nasser bahaj Greenhorn

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #3
    thank you dear hoangvu but is this query change the content of the database ? because the content stored in the database are in windows-1256 encoding thank you
     
    nasser bahaj, Apr 16, 2012 IP