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.
Best regards,
Björn Dieding
Content & Commerce made easy
GMT +01:00 Hannover, Germany
Björn Dieding
Phone: +49 (511) 5904576
Mobile: +49 (151) 12169868
Email: [EMAIL PROTECTED]
PayPal: [EMAIL PROTECTED]
MSN: [EMAIL PROTECTED]
YIM: bdieding
AIM: BjoernDieding
ICQ: 176927179
SKYPE: BjoernDieding
> -----Original Message-----
> From: Tobias Schlitt [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 16, 2008 4:18 PM
> To: Björn Dieding
> Cc: Components
> Subject: Re: [Components] PersistentObject: Binary data support (#10151)
>
> Hi Björn!
>
> On 01/16/2008 11:51 AM Björn Dieding wrote:
>
> > I don't have much about a clue yet about the ezc since I havn`t used
> > them that much. But by just looking at the list do we have mapping
> > for float/double? I think PDO doesn't have this param, but if we
> > would have it as a helper. I do remember problems across databases
> > when using floats and different locales. E.g. '0.000123' vs
> > '0,000123'
>
> Could you elaborate a bit more on this, please? I can follow you, that
> problems exist in general when using locales that use a comma as the
> decimal seperator instead of the point (like the German locale does).
> However, I don't see a problem in respect to database queries here.
>
> Floating point numbers in PHP are always represented in the same way,
> they only get localized on being cast to string. Since we perform value
> binding in PersistentObject, using native PDO functions, this should not
> be an issue. While reading from the database you retrieve back a string,
> which should also contain a non-localized version of the float (as
> long as you did not configure your database to always return localized
> versions), so the cast to float should work as soon as you use it like
> this.
>
> Or am I wrong?
>
> Thanks for your feedback anyway! :)
>
> 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
smime.p7s
Description: S/MIME cryptographic signature
-- Components mailing list [email protected] http://lists.ez.no/mailman/listinfo/components
