password => $odbc_password,
} : ()),
],
+ preserve_case_mode_is_exclusive => 1,
+ quote_char => [ qw/[ ]/ ],
data_types => {
# http://msdn.microsoft.com/en-us/library/ms187752.aspx
datetime => { data_type => 'datetime' },
# test rewriting getdate() to current_timestamp
'datetime default getdate()'
- => { data_type => 'datetime', default_value => \'current_timestamp' },
+ => { data_type => 'datetime', default_value => \'current_timestamp',
+ original => { default_value => \'getdate()' } },
smalldatetime => { data_type => 'smalldatetime' },
time => { data_type => 'time' },
'time(0)'=> { data_type => 'time', size => 0 },
# string types
char => { data_type => 'char', size => 1 },
'char(2)' => { data_type => 'char', size => 2 },
+ character => { data_type => 'char', size => 1 },
+ 'character(2)' => { data_type => 'char', size => 2 },
'varchar(2)' => { data_type => 'varchar', size => 2 },
nchar => { data_type => 'nchar', size => 1 },
'nchar(2)' => { data_type => 'nchar', size => 2 },