Databases Reference
In-Depth Information
Hexadecimal representation
Characters are stored in MySQL (and in computers in general) as numeric data, and
converted into something meaningful for the screen or printer. Users sometimes cut
and paste data from another application to phpMyAdmin, leading to unexpected
results if the characters are not directly supported by MySQL. A case that was
reported in phpMyAdmin's help forum involved special quotation marks entered
in a Microsoft Word document and pasted to phpMyAdmin. It helps to be able to
see the exact hexadecimal codes, and this can be done by using the
application/
octetstream: hex
transformation.
In the following example, this transformation will be applied to the
title
column of
our
book
table. When browsing the row containing the
Future souvenirs
title, we can
see the following screen:
As we know which character set this column is encoded with, we can
compare its contents with a chart describing each character. For instance,
http://en.wikipedia.org/wiki/Latin1
describes the Latin1 character set.
Search WWH ::
Custom Search