Hi!
On Jun 09, Hagen H?pfner wrote:
> Dear list,
>
> i currently try to understand some MySQL internas. However, I am
> wondering about the text encoding. I created a table while using latin1
> and another while using utf8 on a windoof-machine. Then I inserted the
> value "abäöüß" that includes special German characters. If I now
> look
> into the MYD-file with a hex-editor, both tables include the same Bytes.
> Does MySQL internally use a default encoding? If so, which one is used
> internally. While looking at a standard ASCII-table one can recognize,
> that "a" and "b" is standard latin1 (61 and 62) but "äöüß" ist
> something
> else.
No, MySQL does not use default encoding internally.
Check table definitions with 'SHOW CREATE TABLE'.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
