[Babase] Re: weird error
Karl O. Pinc
kop at meme.com
Fri Oct 30 13:47:35 EDT 2009
On 10/30/2009 12:00:04 PM, Lacey Roerish wrote:
> File supplied: *NC0209A.txt*
>
> Line 2: *ERROR: unterminated quoted identifier at or near ""ÿþd" at
> character 27*
Well, that was curious. The first 3 bytes of the file are
not regular (ASCII) characters. The bit patterns in hexadecimal
are:
ef bb bf
These don't print, or come out strange like ""ÿþd".
So, you got an error on every line because the first column
name 'date' wasn't really the column name you thought
you had. Which is why every row got an error.
The obscure clue in the error message is the word
'identifier', which is an indication that the problem
is not in the data but is in the SQL that's putting
the data into the database. The only part of the
SQL that ever changes are the column names so if you
get an error about an identifier then it's either about
a column name or somehow an extra quote character got
put somewhere and some data escaped from inside it's
quotes. IIRC the upload program is not supposed to allow
the latter to happen.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list