[Toolserver-l] phpMyAdmin latin1 display
Ja Ga
jaga_x_1 at yahoo.com
Fri Sep 23 17:41:35 UTC 2011
I have a question about something that's always annoyed me (not actually a problem so not worthy of a JIRA request IMO).
My
MyISAM tables are collated as latin1_swedish_ci. As far as usage in my
HTML reports goes, everything works great, so I'm happy with this setup.
However,
if I browse one of these tables in phpMyAdmin, (and under the very
unnoticeable +Options link in the browse view, uncheck "Show binary contents as HEX") I don't get the proper display of values.
For instance a table whose column is stored as
dab_title varchar(255) binary NOT NULL default ''
will display as
Jarosław_Dąbrowski
when I want
Jarosław Dąbrowski
and indeed that's what I get when I display it in a report. Again, not a
problem, but I was wondering if anyone knows an easy way to get
phpMyAdmin to display the contents properly.
Thanks,
Jason
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20110923/501f9d3f/attachment.htm
More information about the Toolserver-l
mailing list