Dear Kees, -------------------------------------------- From: Kees Nuyt <k.n...@zonnet.nl> Sent: Mon, 22 Sep 2014 23:59:52 +0200 To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite max arguments assistance > > and/or the receiving table doesn't define column > transaction_amount as a numeric type (REAL, NUMBER, INTEGER and > the like). > By the way, lacking a currency or decimal type, the best way to > represent money amounts is INTEGER, expressed as cents. > >> Is there anything I can do post export from the other database to change the >> values correctly? > > Have a look at > http://sqlite.org/datatype3.html > "2.3 Column Affinity Behavior Example" >
I did this: sqlite> create table august (MERCHANT_ID,DBA,WHITELABEL_ID,ORDER_ID,TRANSACTION_DISPLAY_DATE,TYPE,STATE,TRANSACTION_AMOUNT); sqlite> .separator "," sqlite> .import portalUseMonthly_20140901.csv august doing: sqlite> .mode csv sqlite> .import C:/work/somedata.csv tab (with correct values) Results in .schema assuming everything as text So I'll just need to make transaction_amount number -- inum: 883510009027723 sip: jungleboo...@sip2sip.info xmpp: jungle-boo...@jit.si _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
