Hi, I have a cms which store data at MySql tables. The data encoded in UTF-8 and are in Greek language. MySQL charset: UTF-8 Unicode (utf8) MySQL connection collation: latin1_swedish_ci. When my CMS retrieves the data the characters are ok and all the data. Mhen I try to export the data (phpmyadmin) all the exported data seems chinese ???? and DEFAULT CHARSET=latin1 Who I can fix that Any idea?
Yes on site all are ok. I am thinking something with phpmyadmin which export the result. Whatever I define as connection collation the exported data have format table ....{ } ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; and ......
how to do that? Do you mean something like that : MySQL - 4.1.21-standard * Protocol version: 10 * Server: Localhost via UNIX socket * User: rotamegr@localhost * MySQL charset: UTF-8 Unicode (utf8) * MySQL connection collation: armscii8_binarmscii8_general_ciascii_binascii_general_cibig5_binbig5_chinese_cibinarycp1250_bincp1250_croatian_cicp1250_czech_cscp1250_general_cicp1251_bincp1251_bulgarian_cicp1251_general_cicp1251_general_cscp1251_ukrainian_cicp1256_bincp1256_general_cicp1257_bincp1257_general_cicp1257_lithuanian_cicp850_bincp850_general_cicp852_bincp852_general_cicp866_bincp866_general_cicp932_bincp932_japanese_cidec8_bindec8_swedish_cieuckr_bineuckr_korean_cigb2312_bingb2312_chinese_cigbk_bingbk_chinese_cigeostd8_bingeostd8_general_cigreek_bingreek_general_cihebrew_binhebrew_general_cihp8_binhp8_english_cikeybcs2_binkeybcs2_general_cikoi8r_binkoi8r_general_cikoi8u_binkoi8u_general_cilatin1_binlatin1_danish_cilatin1_general_cilatin1_general_cslatin1_german1_cilatin1_german2_cilatin1_spanish_cilatin1_swedish_cilatin2_binlatin2_croatian_cilatin2_czech_cslatin2_general_cilatin2_hungarian_cilatin5_binlatin5_turkish_cilatin7_binlatin7_estonian_cslatin7_general_cilatin7_general_csmacce_binmacce_general_cimacroman_binmacroman_general_cisjis_binsjis_japanese_ciswe7_binswe7_swedish_citis620_bintis620_thai_ciucs2_binucs2_czech_ciucs2_danish_ciucs2_estonian_ciucs2_general_ciucs2_icelandic_ciucs2_latvian_ciucs2_lithuanian_ciucs2_persian_ciucs2_polish_ciucs2_roman_ciucs2_romanian_ciucs2_slovak_ciucs2_slovenian_ciucs2_spanish2_ciucs2_spanish_ciucs2_swedish_ciucs2_turkish_ciucs2_unicode_ciujis_binujis_japanese_ciutf8_binutf8_czech_ciutf8_danish_ciutf8_estonian_ciutf8_general_ciutf8_icelandic_ciutf8_latvian_ciutf8_lithuanian_ciutf8_persian_ciutf8_polish_ciutf8_roman_ciutf8_romanian_ciutf8_slovak_ciutf8_slovenian_ciutf8_spanish2_ciutf8_spanish_ciutf8_swedish_ciutf8_turkish_ciutf8_unicode_ci Documentation * Create new database: Documentation No Privileges * Show MySQL runtime information * Show MySQL system variables Documentation * Show processes Documentation * Character Sets and Collations * Storage Engines * Databases * Export * Import * Log out Info phpMyAdmin - 2.8.0.2 * MySQL client version: 4.1.10 * Used PHP extensions: mysql * Language Info: * Theme / Style: * phpMyAdmin documentation * Official phpMyAdmin Homepage * [ChangeLog] [CVS] [Lists]
another way to solve this problem is : get your sql query , save it in a file , download textpad open the file with textpad and copy past the info into your phpmyadmin.
Server variables and settings Variable Session value / Global value back log 50 basedir / binlog cache size 32,768 bulk insert buffer size 8,388,608 character set client utf8 (Global value) latin1 character set connection utf8 (Global value) latin1 character set database latin1 character set results utf8 (Global value) latin1 character set server latin1 character set system utf8 character sets dir /usr/share/mysql/charsets/ collation connection utf8_swedish_ci (Global value) latin1_swedish_ci collation database latin1_swedish_ci collation server latin1_swedish_ci concurrent insert ON connect timeout 5 datadir /var/lib/mysql/