Hello.
It is not clear from you message what's the problem. From your
calculations I can see that the length of int field in a flat
file row (BTW please send a piece of your file) is different
in mysqldump programs with different versions? How is the length
of integer fields related to character set? Please provide
more information about the problem and if it is possible send a test
case.
Vivian Wang <vivianwang@stripped> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 132 lines --]
>
> the version is 4.1.12.
> show variables like this,
>
> | character_set_client |
> latin1
> | character_set_connection |
> latin1
> | character_set_database |
> latin1
> | character_set_results | latin1
> | character_set_server |
> latin1
> | character_set_system |
> utf8
> | character_sets_dir |
> /usr/share/mysql/charsets/
> | collation_connection |
> latin1_swedish_ci
> | collation_database |
> latin1_swedish_ci
> | collation_server | latin1_swedish_ci
>
> If the table is like test(name char(30), id1 int(4), id2 int(4))
> When I use mysqldump mysql version 3.23.??, l have the flat file row
> length is 30+4+4=38.
> When I use mysqldump mysql verson 4.1.12, I have the flat file row
> length is 30+11+11=52.
>
> I tried mysqldump --set-charset=latin2, I still got a row length=52.
>
> What I should do?
>
>
> Gleb Paharenko wrote:
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
