Perl Supported Datatypes

The Perl driver currently supports string, numeric, and date and time datatypes.

String types	Numeric types	Date and time datatypes
`char` `varchar` `binary` `varbinary` `text` `image` `unichar` `univarchar`	`integer` `smallint` `tinyint` `money` `smallmoney` `float` `real` `double` `numeric` `decimal` `bit` `bigint`	`datetime` `date` `time` `bigtime` `bigdatetime`

String types

Numeric types

Date and time datatypes

char

varchar

binary

varbinary

text

image

unichar

univarchar

integer

smallint

tinyint

money

smallmoney

float

real

double

numeric

decimal

bit

bigint

datetime

date

time

bigtime

bigdatetime

Note: Perl returns numeric and decimal types as strings. Other datatypes are returned in their respective formats.

The default time/date format used by the Sybase ASE driver is the short format, for example, Aug 7 2011 03:05PM.

This format is based on the C (default) locale. See Default Date Conversion and Display Format for other date and time formats supported.