• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

MySQL 4.1 to 5.0 compatibility

After I upgraded MySQL version 4.1 to 5.0 my Delphi application issued an error.

The data type changed from FloatField to String on all SQL statements which have SUM function in SELECT clause.

I could not find quick solutions to solve this problem, and I think the whole source code has to be revised and changed.

Is there another way? Can I say to MySQL 5.0 server act as a 4.1 server?
1 Solution
Michael WorshamInfrastructure / Solutions ArchitectCommented:
I highly recommend reading the articles here first prior to upgrading from 4.1 to 5.0...

Upgrading from MySQL 4.1 to 5.0
U can use cast or convert function and then do the sum...
Suppose id is string .
cast(id as int)

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now