I'm using c++builder 6 and MYDAC 3.55 component with "MySQL client version: 4.1.3 Direct" The MYDAC support told me that "MyDAC reserves memory for field data on describing fields, before getting values from server. Other products, which ignore performance, can detect end of string values by #0 terminator."
It's seems , are least that is what MYDAC support told me, that "MySQL API function mysql_fetch_field_direct returns Field.Length = 14 for Slave_IO_state field." while the field should be bigger. So, the field Slave_IO_State, returned by 'show slave status' command, should be as belowe: Slave_IO_State: Waiting for master to send event Instead I only get a value: 'Waiting for ma' I got the same problem for more other fields as Last_Error and Replicate_Ignore_Table. Do you have some hints, maybe there is no compatibility between mysql server 5 and client mysql 4.1.3 ? -----Messaggio originale----- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Inviato: mercoledi 11 gennaio 2006 16.20 A: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Mysql. Com (E-mail) Oggetto: Re: wrong field size on query like 'show slave status' "AESYS S.p.A. [Enzo Arlati]" <[EMAIL PROTECTED]> wrote on 01/11/2006 03:00:37 AM: > > I found out that when I run a query like 'show slave status' mysql I get > wrong size of the data field. > > The component I using to read the field are using the field length by the db > to allocate the space for data, so the mismatch cause the read of truncated > data. > > Is this bug already known, and if yes there is a planning to solve it ? > I'm using mysql 5.0.18 for windows. > > Regards, > Enzo Arlati > [EMAIL PROTECTED] > We can't read your mind. If you don't tell us WHICH component you are using and HOW you are using it to read your data, we can't recommend anything to help you with your problem. Please respond with more details describing your system, your setup, what commands you use, and how your current results differ from your expectations. Thanks! Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]