开发者

May I use comma as decimal separator on SQLite?

开发者 https://www.devze.com 2023-02-22 18:47 出处:网络
I imported TSV files using Firefox SQLite Manager but the decimal separator is co开发者_开发问答mma and math functions are ignoring the decimal part of the value. Could you help me?

I imported TSV files using Firefox SQLite Manager but the decimal separator is co开发者_开发问答mma and math functions are ignoring the decimal part of the value. Could you help me?

Thank you


I haven't used Firefox SQLite but I have used SQLiteman and with this GUI was a problem work with comma as decimal mark (if your database is light perhaps you can 'replace' those commas using an spreadsheet or something like that...). In my case, as my database was really large, the solution was use the raw SQLite shell: I imported perfectly a csv file (separated by ;) with commas as decimal mark. Additionally, the importing process was faster. Cheers.

0

精彩评论

暂无评论...
验证码 换一张
取 消