importing polish characted into mysql via phpmyadmin

Discussion in 'Webmaster Discussion' started by swordsinfo, Jan 18, 2013.

  1. swordsinfo

    swordsinfo New Member

    Hi guys quick question im trying to use the import function in phpmyadmin to import csv file into mysql. However I cant get the following characters in ł ż ś ń

    I have tried changing the encoding of the excel file I have tried changing the encoding of the import but no dice. If i put them in manually its ok which means the encoding of the db is ok as is the encoding with the field but i get ?? instead of the characters. Any tips on how to avoid these problems

    heres some info on platform being used:

    Server version: 5.5.21
    Protocol version: 10

    MySQL charset: UTF-8 Unicode (utf8)
    Web server

    MySQL client version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $
    PHP extension: mysqli

    as always thanks again for your help
  2. mneylon

    mneylon Administrator Staff Member

    What's the character encoding on the web server running phpmyadmin?
    Can you use the command line tools in MySQL directly? (sorry - I don't have info about your exact setup) it sounds like a character encoding issue in one of elements..
  3. swordsinfo

    swordsinfo New Member

    I can manually enter them in using the insert function so it seems the character encoding is ok - but the import route yelds the ?? characters using utf 8 in the import and also as the encoding in the csv file. I think maybe im not getting a true utf 8 from excel poss??

    Thanks for your response

Share This Page