List:Cluster« Previous MessageNext Message »
From:pekka Date:April 5 2005 3:57am
Subject:Re: error on loading data
View as plain text  
Hi

> have is the overhead for CHARs. For VARCHARs it's size + 2 rounded up to a
> number divisible by 4. What are the rules for CHARs?

In 4.1 mysql converts varchar to char.
In 4.1 and 5.0 char is size rounded to 4.
In 5.0 varchar is 1 + size or 2 + size (if size >= 256) rounded to 4.

If charset is multibyte, multiply by max bytes in char.
For example utf8 => multiply size by 3.

-- 
Pekka Nousiainen, Software Engineer
MySQL AB, www.mysql.com
pekka@stripped +46 (0) 73 068 4978
Thread
error on loading dataJim Hoadley4 Apr
  • Re: error on loading dataMikael Ronström4 Apr
    • Re: error on loading dataJim Hoadley4 Apr
      • Re: error on loading dataMikael Ronström4 Apr
        • Re: error on loading dataJim Hoadley5 Apr
          • Re: error on loading datapekka5 Apr
          • Re: error on loading dataMikael Ronström5 Apr
Re: error on loading dataJim Hoadley4 Apr