SQL Anywhere

SQL Anywhere
Database background

SAP SQL Anywhere is a relational database management system from SAP. It was known as Sybase SQL Anywhere until SAP acquired Sybase. Originally the product was called Watcom SQL (created by Watcom International Corporation).

SQL Anywhere runs on many operating systems. Its database files are OS-agnostic and, like SQLite, can be copied to any platform and immediately be usable as databases. SQL Anywhere is well-suited as an embedded database. It’s used in Intuit QuickBooks, for example. It can also be used as a database server for small and medium businesses. SQL Anywhere scales from an embedded database engine to thousands of users in client/server mode.

SQL Anywhere data types we support

Integral:
bigintintegersmallinttinyintunsigned bigintunsigned intunsigned smallintunsigned tinyint
Decimal:
decimal (numeric)doublefloat (real)
Text:
charlong nvarcharlong varchar (text)ncharnvarcharvarchar
Binary:
binarybitvarbinary (long varbit)
Date/Time:
datedatetimetimetimestamp (timestamp with time zone)
Large objects:
long binarylong nvarcharlong varchar (text)xml
Other:
uniqueidentifier