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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
