Default character encoding

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Default character encoding

Postby Jozjasz » 26. May 2011 18:35

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.
Jozjasz
 
Posts: 8
Joined: 03. September 2009 19:48

Re: Default character encoding

Postby Sharley » 27. May 2011 01:27

Well add it yourself under that heading section in the my.ini file, save it and restart MySQL.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Default character encoding

Postby Jozjasz » 28. May 2011 15:53

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.
Jozjasz
 
Posts: 8
Joined: 03. September 2009 19:48

Re: Default character encoding

Postby Sharley » 29. May 2011 01:07

User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 35 guests