Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of meyerjp3@gmail.com designates
 209.85.213.47 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <53528DE4.5010705@gmail.com>
References: <002101cf5b6f$904bd4e0$b0e37ea0$@gmail.com>
	<53528DE4.5010705@gmail.com>
Date: Sat, 19 Apr 2014 11:18:37 -0400
Message-ID: 
 <CACxRNRNoFc25t-HtNb5q0ffL-PCzUjXyqF-P_iJdAVwK+Yhzbw@mail.gmail.com>
Subject: Re: CREATE TABLE lexical error
From: Patrick Meyer <meyerjp3@gmail.com>
To: Derby Discussion <derby-user@db.apache.org>
Content-Type: multipart/alternative; boundary=20cf303e9f3cc552d504f766c7e1

--20cf303e9f3cc552d504f766c7e1
Content-Type: text/plain; charset=UTF-8

Thanks John. Yes, I was cutting and pasting from Notepad, but I was doing
that for all four lines. I don't understand why it worked for some lines
but not others.

Nevertheless,  the cutting and pasting is not my real problem. I created
these four statements to reproduce a problem I encountered with my program.
I get the same lexical error when my program obtains the column names from
a delimited text file. This error only occurs with some (actually, very
few) files and I cannot figure out why. Any ideas why?

Thanks
On Apr 19, 2014 10:53 AM, "John English" <john.foreign@gmail.com> wrote:

> On 19/04/2014 04:34, Patrick Meyer wrote:
>
>> I have an application that allows users to import data into Derby. As
>> such, the
>> users specify the column names. A user encountered a lexical error
>> message that
>> I have been able to reproduce with the following CREATE TABLE statements.
>> Can
>> anyone explain why the column names appear to be causing a lexical error
>> and how
>> to avoid it? I am using 10.9.1.
>>
>
> \uFEFF is a Unicode "zero-width line break" character. Presumably you're
> cutting and pasting from somewhere; try pasting into a plain-text editor
> and then cut & paste from there to get rid of it?
>
> HTH,
> --
> John English
>

--20cf303e9f3cc552d504f766c7e1
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<p dir=3D"ltr">Thanks John. Yes, I was cutting and pasting from Notepad, bu=
t I was doing that for all four lines. I don&#39;t understand why it worked=
 for some lines but not others.</p>
<p dir=3D"ltr">Nevertheless,=C2=A0 the cutting and pasting is not my real p=
roblem. I created these four statements to reproduce a problem I encountere=
d with my program. I get the same lexical error when my program obtains the=
 column names from a delimited text file. This error only occurs with some =
(actually, very few) files and I cannot figure out why. Any ideas why?</p>

<p dir=3D"ltr">Thanks</p>
<div class=3D"gmail_quote">On Apr 19, 2014 10:53 AM, &quot;John English&quo=
t; &lt;<a href=3D"mailto:john.foreign@gmail.com">john.foreign@gmail.com</a>=
&gt; wrote:<br type=3D"attribution"><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 19/04/2014 04:34, Patrick Meyer wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
I have an application that allows users to import data into Derby. As such,=
 the<br>
users specify the column names. A user encountered a lexical error message =
that<br>
I have been able to reproduce with the following CREATE TABLE statements. C=
an<br>
anyone explain why the column names appear to be causing a lexical error an=
d how<br>
to avoid it? I am using 10.9.1.<br>
</blockquote>
<br>
\uFEFF is a Unicode &quot;zero-width line break&quot; character. Presumably=
 you&#39;re cutting and pasting from somewhere; try pasting into a plain-te=
xt editor and then cut &amp; paste from there to get rid of it?<br>
<br>
HTH,<br>
-- <br>
John English<br>
</blockquote></div>

--20cf303e9f3cc552d504f766c7e1--