Sorry for dont start my own topic... I apologize Hi! No I haven't tested with the v5 driver yet, but I found out that the problem is when I use date_format function
If I dont use it the data is returned ok in my app(but with hours, minutes etc), but if i do a date_format i get "bytes" on each record instance of get date formated, the column type is datetime(of my table) Regards! -----Mensaje original----- De: Martijn Tonies [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 10 de Febrero de 2006 12:51 p.m. Para: 'Mysql ' Asunto: Re: MySQL 5.0.x and Delphi Hi, First of all: you're sending a message with an enormous quote of someone elses message, this really is "not done" on an e-mail list. Start your own topic. > I'm having problems upgrading my database from 4.0.x to 5.0.x, > specially with date fields > > For example with 4.0.x I do: "select startDate from TEvent" and in my > application it is displayed ok(managed with controls), but the same > code, same odbc, same control in delphi, etc with mysql 5.0.x it > displays: byte instance of the date storaged in my table What datatype is being returned for this column if you try and use it in Delphi with the ODBC driver? Did you try the v5 driver already? http://dev.mysql.com/downloads/connector/odbc/5.0.html > My versions are: > Delphi 5 > MyODBC-3.51.11-2-win > MySQL 5.0.18 > MySQL 4.0.26 Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
