Decimal Seperator Problem
Posted on 2004-10-09
Hi... I have a problem with the decimal seperator in mysql while I am trying to insert or update data which has atleast 2 decimal places.
In Turkey, defoult currency format is like that 123,456.98 .... But in europe the default currency format is like that 123.345,65 ... So whenever I try to insert 34,12 I only see the 34.00. Nothing more... My field type is Double(10,2). I am able to insert 34.12 If I am using Mysql Control Center directly from sql query. Is it possible change the defoult mysql locale setting which is suitable to Turkish type?