Hi All.
I'm working with SQLite through a Perl script to store some data files
on CD-ROM into tables. Everything has gone rather well considering I am
learning SQL and SQLite as I go along. The data files are CSV and
appear to be an SQL variant used by a proprietary SQL engine installed
by the CD's setup program on another OS.
Anyway, I am seeing the following behavior--when the following line is
put into the database with an INSERT command:
"How Do You Like Our QST, OM?", ...
SQLite gives me this
'How Do You Like Our QST, OMNULL', ...
Yet, a '?' inside a string followed by a space passed into the column
data just fine. However, I found a similar case as above where the '?'
was inserted without error:
"Simple, Isn't It?",
becomes:
'Simple, Isn''t It?',
Some more searching through the file revealed the following pattern. If
the string contains an escaped apostrophe (as the latter, above) then the
query character is passed into the table data. If there is no escaped
apostrophe (as the former, above), then the query is translated to the
"NULL" string that appears in the table data in place of '?'.
I even found this tricky gem:
"Why Not Reform the ""Squeek-Box?""",
which became:
'Why Not Reform the "Squeek-BoxNULL"',
Is this a bug or am I missing something?
For what it's worth I am using SQLite 2.8.6 packaged in Debian
GNU/Linux, Sarge distribution.
Thanks!
- Nate >>
--
Wireless | Amateur Radio Station N0NB | Successfully Microsoft
Internet | [EMAIL PROTECTED] | free since January 1998.
Location | Bremen, Kansas USA EM19ov | "Debian, the choice of
Amateur radio exams; ham radio; Linux info @ | a GNU generation!"
http://www.qsl.net/n0nb/ | http://www.debian.org
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
