Re: [sqlite] Using bind_text for numeric columns

2018-02-18 Thread x
<mailto:slav...@bigfraud.org> Sent: 18 February 2018 15:29 To: SQLite mailing list<mailto:sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Using bind_text for numeric columns On 18 Feb 2018, at 12:44pm, x wrote: > Suppose I have a query with several parameters on column

Re: [sqlite] Using bind_text for numeric columns

2018-02-18 Thread Simon Slavin
On 18 Feb 2018, at 12:44pm, x wrote: > Suppose I have a query with several parameters on columns that could be > integer, real or text. The values for these parameters are taken from the > result set of another query which is stored in a string array. > > Is there any pitfalls or disadvantages

[sqlite] Using bind_text for numeric columns

2018-02-18 Thread x
Suppose I have a query with several parameters on columns that could be integer, real or text. The values for these parameters are taken from the result set of another query which is stored in a string array. Is there any pitfalls or disadvantages to binding them all as text as opposed to the m