Summary
In this chapter, we saw how we can improve the browsing experience by
transforming data using various methods. We can see thumbnail and full-size images
of .jpeg and .png BLOB fields, generate links, format dates, display only parts of
texts, and execute external programs to reformat each cell's contents.
Character Sets and
Collations
This chapter explains how phpMyAdmin stores and fetches data, and how it deals
with the character set and collation features available under MySQL. The program's
behavior is highly dependent on the MySQL version used.
A character set describes how symbols for a specific language or dialect are encoded.
A collation contains rules to compare and sort the characters of a character set. (See
the MySQL 4.1.x and Later section in this chapter.)
The character set used to store our data may be different from the one used to display
it, leading to data discrepancies. Thus, a need to transform the data arises.
Language Files and UTF-8
"Unicode is an industry standard designed to allow text and symbols [??¦]
to be consistently represented and manipulated by computers". See
http://en.wikipedia.org/wiki/Unicode and also http://www.unicode.org.
Unicode currently supports more than 600 languages, which is its main advantage
over other character sets available with ISO or Windows. This is especially important
with a multi-language product like phpMyAdmin.
Pages:
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233