db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brett Wooldridge <brett.wooldri...@gmail.com>
Subject Re: Problem with Column Names
Date Mon, 07 Jun 2010 13:36:05 GMT
It is not valid in SQL to have column name (or other identifiers) that begin
with a numeric character.  You're going to have to code specifically for
this case.

Brett

On Mon, Jun 7, 2010 at 10:29 PM, pb2208 <pete.beatty@gmail.com> wrote:

>
> I am defining a DB where I will need to import numerous data files.  These
> data files may come from EXCEL, CSV files, and Tab delimited files.  All of
> these files use alphabetic (A-Za-z0-9) in their column names.  Some columns
> may contain only the (0-9) characters.
>
> I have been trying to create a table using the numeric characters.
>  However,
> I am always getting exception errors pointing to the column name.  The
> command I am using is:
>
> Create Table mytab (393 decimal(3));
>
> I have also tried changing the 393 to encase it in single and double
> quotes.
> THis has no affect.
>
> How can I define and reference a column using numeric characters?
>
>
> --
> View this message in context:
> http://old.nabble.com/Problem-with-Column-Names-tp28805238p28805238.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>
>

Mime
View raw message