Menu
▾
▴
#155 Column name incorrect after create table.
CREATE TABLE Customers (
[Customer ID] varchar(10) PRIMARY KEY NOT NULL,
[Company Name] VARCHAR(30) NULL,
[Contact Name] VARCHAR(30) NULL,
[Contact Title] VARCHAR(10) NULL,
[Address] VARCHAR(40) NULL,
[City] VARCHAR(30) NULL,
[Region] VARCHAR(10) NULL,
[Postal Code] VARCHAR(10) NULL,
[Country] VARCHAR(2) DEFAULT 'US',
[Phone] VARCHAR(30) NULL,
[Fax] VARCHAR(30) NULL,
[Status] CHAR(1) NULL,
[Date Registered] Timestamp DEFAULT NOW(),
[Date Of Last Order] DATE,
[Test Local Date] date,
[Test Local DateTime] Timestamp
)
When you execute this command the column "Test Local DateTime" becomes "TEST LOCAL TIMESTAMP" in the database. Happens also with "Test Local Date Time"
if you executed a sql statement, then you were probably using another library with jackcess. my guess would be ucanaccess. you should file a bug with that project first.
So you can't reproduce? Just try it and let me know. I'll check with ucanaccess.
looks like this will be fixed in ucanaccess https://sourceforge.net/p/ucanaccess/discussion/general/thread/52ae8bb570/
Last edit: James Ahlborn 2021-09-15