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.
These two statements result in errors: CREATE TABLE TBLPAT1 (xb1x DOUBLE, xb2x DOUBLE) Error: Lexical error at line 1, column 24. Encountered: "\ufeff" (65279), after : "". CREATE TABLE TBLPAT2 (xb1x VARCHAR(50), xb2x VARCHAR(50)) Error: Lexical error at line 1, column 24. Encountered: "\ufeff" (65279), after : "". SQLState: 42X02 ErrorCode: 30000 These statements work just fine. CREATE TABLE TBLPAT3 (xvar1x DOUBLE, xvar2x DOUBLE) CREATE TABLE TBLPAT4 (xvar1x VARCHAR(50), xvar2x DOUBLE) CREATE TABLE TBLPAT5 (xvar1x VARCHAR(50), xvar2x VARCHAR(50)) Thanks, Patrick
