password => $odbc_password,
} : ()),
],
+ preserve_case_mode_is_exclusive => 1,
+ quote_char => [ qw/[ ]/ ],
data_types => {
# http://msdn.microsoft.com/en-us/library/ms187752.aspx
money => { data_type => 'money' },
smallmoney => { data_type => 'smallmoney' },
bit => { data_type => 'bit' },
- real => { data_type => 'float', size => 24 },
- 'float(14)' => { data_type => 'float', size => 24 },
- 'float(24)' => { data_type => 'float', size => 24 },
+ real => { data_type => 'real' },
+ 'float(14)' => { data_type => 'real' },
+ 'float(24)' => { data_type => 'real' },
'float(25)' => { data_type => 'double precision' },
'float(53)' => { data_type => 'double precision' },
float => { data_type => 'double precision' },
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 },
'nvarchar(2)' => { data_type => 'nvarchar', size => 2 },
# binary types
- 'binary(2)' => { data_type => 'binary', size => 2 },
- 'varbinary(2)' => { data_type => 'varbinary', size => 2 },
+ 'binary' => { data_type => 'binary', size => 1 },
+ 'binary(2)' => { data_type => 'binary', size => 2 },
+ 'varbinary(2)' => { data_type => 'varbinary', size => 2 },
# blob types
'varchar(max)' => { data_type => 'text' },