1
Vote

Float insertion in non-US languages

description

If you have your windows configured to use "," as decimal separator (like in france), each insert of a float will create an error.

For example :
SQLite2CE Error: Could not insert data into table: stops
Insert command: INSERT INTO [stops] ([_id],[stop_id],[stop_code],[stop_lat],[stop_lon],[stop_name],[stop_url]) VALUES (1229,'MAZEL_04','709B',48,59526
22551934,7,71833337843418,'Mathieu Zell','http://applis.cts-strasbourg.fr/CTS_FicheHorairev3/ResultatsFiches.aspx?arret=709B')
Reason: Les nombres de noms de colonnes et d'expressions sources ne correspondent pas. [ Column name count = 7,Source expression count = 9 ]

comments