Hi Björn! On 01/16/2008 05:00 PM Björn Dieding wrote: > Hi,
> Let me give you one example. There is a global Oracle config var that > defines the floating point separator of a float(, or .). You can set > that individually from the Locals like en_GB. The problem is if the > "," is set for the floating point separator a query as stated below > will fail. This is e.g. the case if you do not set the floating point > separator and just use a locale like de_DE. UPDATE table set > myfloat='12.0001' (will fail) UPDATE table set myfloat='12,0001' > (will work with either the setting of de_DE or floating point > separator to ,) > Are the ezc able to reflect that? Can the PDO functions really cover > that(I haven't discovered config options in PDO::*)? Meaning the ezc > would need to bring the value to the right format depending on the > connection ( databasetype or server). > I hope this is clearer. Thanks for your reply. I like the work you do > with the rest of the ezc team. Thanks for elaborating. Without explicit testing I would guess that PDO handles this gracefully. Since we use PDOStatement->bindValue() to submit any kind of PHP values with a query (at least with PersistentObject we do), we do not put any values into text queries directly. Binding values first prepares a query with a set of placeholders and then submits the values dedicatedly to the server. However, if you have an oracle server with such a configuration available it would be very nice if you could run the PersistentObject test suite against it to verify this assumption. Regards, Toby -- Mit freundlichen Grüßen / Med vennlig hilsen / With kind regards Tobias Schlitt (GPG: 0xC462BC14) eZ Components Developer [EMAIL PROTECTED] | eZ Systems AS | ez.no -- Components mailing list [email protected] http://lists.ez.no/mailman/listinfo/components
