Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Correct the documentation to show that sqlite3_column_text() returns a NULL pointer (not an empty string) when the column value is NULL. The same goes for sqlite3_column_blob(). Ticket #1334. (CVS 2558) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
fd1e013a14710ed2ecabddedc0d11056 |
| User & Date: | drh 2005-07-22 22:53:16 |
Context
|
2005-07-22
| ||
| 23:56 | Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) (check-in: 1a573619 user: drh tags: trunk) | |
| 22:53 | Correct the documentation to show that sqlite3_column_text() returns a NULL pointer (not an empty string) when the column value is NULL. The same goes for sqlite3_column_blob(). Ticket #1334. (CVS 2558) (check-in: fd1e013a user: drh tags: trunk) | |
| 00:31 | Begin adding code to support multiple IN constraints on the same index. (CVS 2557) (check-in: 103f8ccb user: drh tags: trunk) | |
Changes
Changes to www/capi3ref.tcl.
1
2
3
4
5
6
7
8
...
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
|
set rcsid {$Id: capi3ref.tcl,v 1.23 2005/06/16 19:48:39 drh Exp $}
source common.tcl
header {C/C++ Interface For SQLite Version 3}
puts {
<h2>C/C++ Interface For SQLite Version 3</h2>
}
proc api {name prototype desc {notused x}} {
................................................................................
are applied:
<blockquote>
<table border="1">
<tr><th>Internal Type</th><th>Requested Type</th><th>Conversion</th></tr>
<tr><td> NULL </td><td> INTEGER</td><td>Result is 0</td></tr>
<tr><td> NULL </td><td> FLOAT </td><td> Result is 0.0</td></tr>
<tr><td> NULL </td><td> TEXT </td><td> Result is an empty string</td></tr>
<tr><td> NULL </td><td> BLOB </td><td> Result is a zero-length BLOB</td></tr>
<tr><td> INTEGER </td><td> FLOAT </td><td> Convert from integer to float</td></tr>
<tr><td> INTEGER </td><td> TEXT </td><td> ASCII rendering of the integer</td></tr>
<tr><td> INTEGER </td><td> BLOB </td><td> Same as for INTEGER->TEXT</td></tr>
<tr><td> FLOAT </td><td> INTEGER</td><td>Convert from float to integer</td></tr>
<tr><td> FLOAT </td><td> TEXT </td><td> ASCII rendering of the float</td></tr>
<tr><td> FLOAT </td><td> BLOB </td><td> Same as FLOAT->TEXT</td></tr>
<tr><td> TEXT </td><td> INTEGER</td><td>Use atoi()</td></tr>
|
|
|
|
|
1
2
3
4
5
6
7
8
...
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
|
set rcsid {$Id: capi3ref.tcl,v 1.24 2005/07/22 22:53:16 drh Exp $}
source common.tcl
header {C/C++ Interface For SQLite Version 3}
puts {
<h2>C/C++ Interface For SQLite Version 3</h2>
}
proc api {name prototype desc {notused x}} {
................................................................................
are applied:
<blockquote>
<table border="1">
<tr><th>Internal Type</th><th>Requested Type</th><th>Conversion</th></tr>
<tr><td> NULL </td><td> INTEGER</td><td>Result is 0</td></tr>
<tr><td> NULL </td><td> FLOAT </td><td> Result is 0.0</td></tr>
<tr><td> NULL </td><td> TEXT </td><td> Result is NULL pointer</td></tr>
<tr><td> NULL </td><td> BLOB </td><td> Result is NULL pointer</td></tr>
<tr><td> INTEGER </td><td> FLOAT </td><td> Convert from integer to float</td></tr>
<tr><td> INTEGER </td><td> TEXT </td><td> ASCII rendering of the integer</td></tr>
<tr><td> INTEGER </td><td> BLOB </td><td> Same as for INTEGER->TEXT</td></tr>
<tr><td> FLOAT </td><td> INTEGER</td><td>Convert from float to integer</td></tr>
<tr><td> FLOAT </td><td> TEXT </td><td> ASCII rendering of the float</td></tr>
<tr><td> FLOAT </td><td> BLOB </td><td> Same as FLOAT->TEXT</td></tr>
<tr><td> TEXT </td><td> INTEGER</td><td>Use atoi()</td></tr>
|