AppGini Community Forums

Hello,
I'm testing at the moment AppGini. There is no problem to use a german language file to get the interface in german.
On the other hand we have a few problems using german number and date fields!

Number Problems:
English: 1,000.00
German: 1.000,00
And the end-user will enter just 1000

English: 1,000.12
German: 1.000,12
And the end-user will enter just 1000,12

Date Time Problems
Englisch (MySQL): 2014-07-15
German: 15.07.2014 (And the end-user will enter this)

Does any one get this run?

It's a shame that MySQL doesn't, until now, support this natively. You could implement it manually by:

1. Modifying user input through the before_insert and before_update hooks to replace commas with periods: http://bigprof.com/appgini/help/advance ... ore_insert
2. Modifying the table view display query to use the format() SQL function for decimal fields. This works only on MySQL 5.5 and higher. Please refer to http://dev.mysql.com/doc/refman/5.5/en/ ... ion_format