Default character encoding

[Jozjasz]

Hello,

May anybody help me to set encoding in PHPMYADMIN ?
I use XAMPP 1.7.1 and MySQL client version: 5.0.51a in XAMPP on Windows.

I am trying to use polish characters into a database, but whatever I do it turns out to be wrong. I set everywhere (wherever I can when I create a new database) in phpmyadmin utf8_unicode_ci (collation, MySQL connection collation, table_name/structure/collation) and as I connect to MySQL by PHP code on my website (function: mysqli_connect()) there are question marks instead of Polish characters. XAMPP has its default presets. What shall I do to solve the problem and make XAMPP work with polish characters fine. On my website I use encoding="utf-8"

I was told that I should change 'c:\xampp\mysqli\bin\my.ini'

Code: Select all

# The MySQL server
[mysqld]
default-character-set=latin2
[client]
default-character-set=latin2

but there is not such data in 'my.ini' ....

thanks in advance.

[Sharley]

Well add it yourself under that heading section in the my.ini file, save it and restart MySQL.

[Jozjasz]

It didn't help. It has changed nothing.
Is it possible to use other's languages characters in Xampp? Whatever I do it doesn't work.
Is there something to configure to obtain wanted chars.

[Sharley]

See if this Knowledgebase article helps:
Default MySQL character set and collation

More reading:
http://php.net/manual/en/function.mysql ... coding.php
Some relevant Google search results