Re: [Toolserver-l] Character encoding after selecting form database

2010-11-26 Thread Platonides
Maciej Jaros wrote: > Strange. I wasn't able to make phpMyAdmin act as expected otherwise then > casting page_title as binary. Shell act the same to me but I guess it > might be because my system doesn't use latin1. > > I guess using this in my script was NOT a good idea: > PDO::MYSQL_ATTR_INIT_

Re: [Toolserver-l] Character encoding after selecting form database

2010-11-25 Thread Maciej Jaros
@2010-11-26 04:19, Jeremy Baron: > > Have you set putty or your web browser (when viewing phpMyAdmin) to use UTF-8? Setting up putty to translate from UTF8 worked, but I haven't managed to figure out how to setup phpMyAdmin on the toolserver. I've tried various connection collations and nothing

Re: [Toolserver-l] Character encoding after selecting form database

2010-11-25 Thread Maciej Jaros
@2010-11-26 04:00, Maciej Jaros: > @2010-11-26 03:33, MZMcBride: >> Maciej Jaros wrote: >>>There seems to be a problem with character encoding in (at least) the >>> Polish >>> Wikipedia database. At first I thought it was the problem with my script but >>> phpMyAdmin and even shell mysql also

Re: [Toolserver-l] Character encoding after selecting form database

2010-11-25 Thread Jeremy Baron
2010/11/25 Maciej Jaros : > @2010-11-26 03:33, MZMcBride: >> Maciej Jaros wrote: >>>   There seems to be a problem with character encoding in (at least) the >>> Polish >>> Wikipedia database. At first I thought it was the problem with my script but >>> phpMyAdmin and even shell mysql also shows we

Re: [Toolserver-l] Character encoding after selecting form database

2010-11-25 Thread Maciej Jaros
@2010-11-26 03:33, MZMcBride: > Maciej Jaros wrote: >> There seems to be a problem with character encoding in (at least) the >> Polish >> Wikipedia database. At first I thought it was the problem with my script but >> phpMyAdmin and even shell mysql also shows weird characters. >> >> See for e

Re: [Toolserver-l] Character encoding after selecting form database

2010-11-25 Thread MZMcBride
Maciej Jaros wrote: > There seems to be a problem with character encoding in (at least) the Polish > Wikipedia database. At first I thought it was the problem with my script but > phpMyAdmin and even shell mysql also shows weird characters. > > See for example: > SELECT page_title FROM page WH

[Toolserver-l] Character encoding after selecting form database

2010-11-25 Thread Maciej Jaros
Hi. There seems to be a problem with character encoding in (at least) the Polish Wikipedia database. At first I thought it was the problem with my script but phpMyAdmin and even shell mysql also shows weird characters. See for example: SELECT page_title FROM page WHERE page_id = 2117937 Or a