Re: Text Encoding

[Sergei Golubchik]

Hi!

On Jun 10, Olaf van der Spek wrote:
> > 
> > CHAR() columns always have the same length - in bytes.
> > As "a" takes only one byte it's space-padded to 3 bytes.
> 
> And then it's truncated to one character when it's
> retrieved again?

Yes.
You can never get a string with more than one character from
CHAR(1) column.
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com