From cb57c3912aef6bed394a4693f94e9c97001aff34 Mon Sep 17 00:00:00 2001 From: Andy Staudacher Date: Sun, 21 Feb 2010 13:05:48 -0800 Subject: Fix random queries (such as for the random image block) for locales that don't use a period as decimal separator of floating point numbers (such as de_DE). (Integrating a fix Kohana's SQL generation for floating point numbers. See http://dev.kohanaframework.org/issues/2636.) --- system/libraries/Database.php | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/system/libraries/Database.php b/system/libraries/Database.php index 98e33fa0..253bb152 100644 --- a/system/libraries/Database.php +++ b/system/libraries/Database.php @@ -420,6 +420,11 @@ abstract class Database_Core { { return (string) $value; } + elseif (is_float($value)) + { + // Convert to non-locale aware float to prevent possible commas + return sprintf('%F', $value); + } return '\''.$this->escape($value).'\''; } -- cgit v1.2.3