Sybase¶

Support for the Sybase database.

The following table summarizes current support levels for database release versions.

DBAPI Support¶

The following dialect/DBAPI options are available. Please refer to individual DBAPI sections for connect information.

Note

The Sybase dialect functions on current SQLAlchemy versions but is not regularly tested, and may have many issues and caveats not currently handled.

Support for the Sybase database via the Python-Sybase driver.

Documentation and download information (if applicable) for Python-Sybase is available at: http://python-sybase.sourceforge.net/

Connect String:

sybase+pysybase://<username>:<password>@<dsn>/[database name]

The python-sybase driver does not appear to support non-ASCII strings of any kind at this time.

Support for the Sybase database via the PyODBC driver.

Documentation and download information (if applicable) for PyODBC is available at: http://pypi.python.org/pypi/pyodbc/

Connect String:

sybase+pyodbc://<username>:<password>@<dsnname>[/<database>]

The pyodbc driver currently supports usage of these Sybase types with Unicode or multibyte strings:

CHAR
NCHAR
NVARCHAR
TEXT
VARCHAR

Currently not supported are:

UNICHAR
UNITEXT
UNIVARCHAR

Support for the Sybase database via the mxODBC driver.

Documentation and download information (if applicable) for mxODBC is available at: http://www.egenix.com/

Connect String:

sybase+mxodbc://<username>:<password>@<dsnname>

Note

This dialect is a stub only and is likely non functional at this time.