Hi, I upgrade my mysql server and machine from Conectiva linux 8 and mysql 3.23.57 to Debian 3.1 and mysql 4.1.11 and my program don't work. This program was made in Delphi with zeos component to conect mysql and the program use function select now(). With conectiva 8 and mysql 3.23.57 this program return YYYY-mm-dd and after upgrade to Debian return dd/mm/YYYY. I changed in regional settings from win98 to show YYYY-mm-dd and worked but when save any data with date from the program, this date not work correctly.
My question, why don't work after this upgrade? Ps. I don't have the sources of this program :( Thanks. Marcos