Be careful with ODBC inplementation in DatabaseLayer.

Talk here about issues with one of the components hosted at wxCode, or suggest features for it.
Post Reply
vtararin
Knows some wx things
Knows some wx things
Posts: 37
Joined: Thu May 24, 2007 4:43 pm
Location: Ukraine
Contact:

Be careful with ODBC inplementation in DatabaseLayer.

Post by vtararin » Mon Dec 17, 2007 7:51 am

Be careful. ODBC implementation now very simply and has many dangerous places.

The first one is related to use strings for extraction of sql results. This solution can drive to unpredictable result, if odbc driver know and handle locale settings.

For example MSSQLServer ODBC driver in default configuration return double value in russian local with "," instead ".". And wxWidgets wxVariant can't properly extract double (GetDouble()) from that string.

The second one. Date with time don't properly stores in MSSQLServer. Patch id present on SF but may not work with other databases (not tested with other).

The third one. Blob fields large that 8000 bytes do not stores in the MSSQLServer database. ( I have solution will try to prepare patch for two days).

manteez
Experienced Solver
Experienced Solver
Posts: 58
Joined: Fri Dec 07, 2007 7:54 am

Post by manteez » Thu Feb 28, 2008 7:08 am

thanks for your info.

I also have a problem with databaselayer when storing in blob field with size more than 1 MB. I use MySQL

Post Reply