Re: [sqlite] Deactivation of Manifest Typing

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon de Hartog wrote: > to prevent stored values not being > what my code (C++) expects them to be. Note that the APIs will convert the values for you. For example if you call sqlite3_column_text then the value will be converted to text for you no

Re: [sqlite] Deactivation of Manifest Typing

"Simon de Hartog" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > SQLite has a feature called Manifest typing. As with many features of > software I run, I wonder whether this feature can be disabled. No. It's a fundamental part of the architecture. Igor Tandetnik

Re: [sqlite] Question about sqlite3_clear_bindings

"Tito Ciuro" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 1 • Create the object using sqlite3_prepare_v2() or a related > function. 2 • Bind values to host parameters using the > sqlite3_bind_*() interfaces. > 3 • Run the SQL by calling sqlite3_step() one or more times. > 4 •

[sqlite] Question about sqlite3_clear_bindings

Hello, I was reading the following pages: http://www.sqlite.org/c3ref/stmt.html http://www.sqlite.org/c3ref/clear_bindings.html I was wondering why sqlite3_clear_bindings() is not mentioned in the SQL Statement Object page. Would the following be incorrect?: 1 • Create the object using

Re: [sqlite] Deactivation of Manifest Typing

Simon de Hartog wrote: > SQLite has a feature called Manifest typing. As with many features of > software I run, I wonder whether this feature can be disabled. I prefer > to use static typing in my databases to prevent stored values not being > what my code (C++) expects them to be. So in short:

Re: [sqlite] detecting which column matched a like clause

On Dec 4, 2008, at 5:32 AM, Igor Tandetnik wrote: > "Hernan Eguiluz" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> The problem is that a >> query like this >> >> >> SELECT column1, column2 from TABLE WHERE column1 LIKE "%PATTERN%" or >> column2 LIKE "%PATTERN%" >> >> >> won't

[sqlite] Deactivation of Manifest Typing

Dear all, SQLite has a feature called Manifest typing. As with many features of software I run, I wonder whether this feature can be disabled. I prefer to use static typing in my databases to prevent stored values not being what my code (C++) expects them to be. So in short: is it possible to use

Re: [sqlite] is there a way to escape a '-' in FTS match syntax?

I am new on NABBLE, so my reply comes perhaps too late... FTS ignores all the characters not enclosed in [A-Za-z0-1], so it treats "T" and "BONE" as two adjacent words. You can search "T-Bone" using NEAR operator (NEAR/0 is used to find adjacent words): select * from FT where FT match 't