source: src/main/java/weka/experiment/DatabaseUtils.props.msaccess @ 4

# Database settings for ODBC in conjunction with MS Access 2000
#
# General information on database access can be found here:
# http://weka.wikispaces.com/Databases
#
# url:     http://weka.wikispaces.com/Windows+Databases
# author:  Fracpete (fracpete at waikato dot ac dot nz)
# version: $Revision: 5837 $

# JDBC driver (comma-separated list)
jdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver

# database URL
jdbcURL=jdbc:odbc:DSN_Name

# specific data types
# string, getString() = 0;    --> nominal
# boolean, getBoolean() = 1;  --> nominal
# double, getDouble() = 2;    --> numeric
# byte, getByte() = 3;        --> numeric
# short, getByte()= 4;        --> numeric
# int, getInteger() = 5;      --> numeric
# long, getLong() = 6;        --> numeric
# float, getFloat() = 7;      --> numeric
# date, getDate() = 8;        --> date
# text, getString() = 9;      --> string
# time, getTime() = 10;       --> date

varchar=0
float=2
tinyint=3
int=5
text=0

# other options
CREATE_DOUBLE=DOUBLE
CREATE_STRING=TEXT
CREATE_INT=INT
CREATE_DATE=DATETIME
DateFormat=yyyy-MM-dd HH:mm:ss
checkUpperCaseNames=false
checkLowerCaseNames=false
checkForTable=true

# All the reserved keywords for this database
# Based on the keywords listed at the following URL (2009-04-13):
# http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
Keywords=\
  ADD,\
  ALL,\
  ALTER,\
  AND,\
  ANY,\
  AS,\
  ASC,\
  AUTOINCREMENT,\
  Alphanumeric,\
  Application,\
  Assistant,\
  Avg,\
  BETWEEN,\
  BINARY,\
  BIT,\
  BOOLEAN,\
  BY,\
  BYTE,\
  CHAR,\
  CHARACTER,\
  COLUMN,\
  CONSTRAINT,\
  COUNTER,\
  CREATE,\
  CURRENCY,\
  CompactDatabase,\
  Container,\
  Count,\
  CreateDatabase,\
  CreateField,\
  CreateGroup,\
  CreateIndex,\
  CreateObject,\
  CreateProperty,\
  CreateRelation,\
  CreateTableDef,\
  CreateUser,\
  CreateWorkspace,\
  CurrentUser,\
  DATABASE,\
  DATE,\
  DATETIME,\
  DELETE,\
  DESC,\
  DISALLOW,\
  DISTINCT,\
  DISTINCTROW,\
  DOUBLE,\
  DROP,\
  Description,\
  Document,\
  EXISTS,\
  Echo,\
  Else,\
  End,\
  Eqv,\
  Error,\
  Exit,\
  FALSE,\
  FLOAT,\
  FLOAT4,\
  FLOAT8,\
  FOREIGN,\
  FROM,\
  FUNCTION,\
  Field,\
  Fields,\
  FillCache,\
  Form,\
  Forms,\
  Full,\
  GENERAL,\
  GROUP,\
  GROUPBY,\
  GUID,\
  GetObject,\
  GetOption,\
  GotoPage,\
  HAVING,\
  IEEEDOUBLE,\
  IEEESINGLE,\
  IGNORE,\
  IN,\
  INDEX,\
  INNER,\
  INSERT,\
  INT,\
  INTEGER,\
  INTEGER1,\
  INTEGER2,\
  INTEGER4,\
  INTO,\
  IS,\
  Idle,\
  If,\
  Imp,\
  Index,\
  Indexes,\
  InsertText,\
  JOIN,\
  KEY,\
  LEFT,\
  LOGICAL,\
  LOGICAL1,\
  LONG,\
  LONGBINARY,\
  LONGTEXT,\
  LastModified,\
  Level,\
  Like,\
  MEMO,\
  MONEY,\
  Macro,\
  Match,\
  Max,\
  Min,\
  Mod,\
  Module,\
  Move,\
  NAME,\
  NO,\
  NULL,\
  NUMBER,\
  NUMERIC,\
  NewPassword,\
  Not,\
  Note,\
  OFF,\
  OLEOBJECT,\
  ON,\
  OPTION,\
  OR,\
  ORDER,\
  OWNERACCESS,\
  Object,\
  OpenRecordset,\
  Orientation,\
  Outer,\
  PARAMETERS,\
  PERCENT,\
  PIVOT,\
  PRIMARY,\
  PROCEDURE,\
  Parameter,\
  Partial,\
  Property,\
  Queries,\
  Query,\
  Quit,\
  REAL,\
  REFERENCES,\
  RIGHT,\
  Recalc,\
  Recordset,\
  Refresh,\
  RefreshLink,\
  RegisterDatabase,\
  Relation,\
  Repaint,\
  RepairDatabase,\
  Report,\
  Reports,\
  Requery,\
  SCREEN,\
  SECTION,\
  SELECT,\
  SET,\
  SHORT,\
  SINGLE,\
  SMALLINT,\
  SOME,\
  SQL,\
  STRING,\
  SetFocus,\
  SetOption,\
  StDev,\
  StDevP,\
  Sum,\
  TABLE,\
  TEXT,\
  TIME,\
  TIMESTAMP,\
  TOP,\
  TRANSFORM,\
  TRUE,\
  TableDef,\
  TableDefs,\
  TableID,\
  Type,\
  UNION,\
  UNIQUE,\
  UPDATE,\
  USER,\
  VALUE,\
  VALUES,\
  VARBINARY,\
  VARCHAR,\
  VERSION,\
  Var,\
  VarP,\
  WHERE,\
  WITH,\
  Workspace,\
  Xor,\
  YES,\
  YESNO,\
  Year

# The character to append to attribute names to avoid exceptions due to
# clashes between keywords and attribute names
KeywordsMaskChar=_

#flags for loading and saving instances using DatabaseLoader/Saver
nominalToStringLimit=50
idColumn=auto_generated_id