File: //usr/share/doc/python-sqlalchemy-0.9.8/doc/dialects/sybase.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>
Sybase
—
SQLAlchemy 0.9 Documentation
</title>
<!-- begin iterate through SQLA + sphinx environment css_files -->
<link rel="stylesheet" href="../_static/pygments.css" type="text/css" />
<link rel="stylesheet" href="../_static/docs.css" type="text/css" />
<link rel="stylesheet" href="../_static/sphinx_paramlinks.css" type="text/css" />
<link rel="stylesheet" href="../_static/changelog.css" type="text/css" />
<!-- end iterate through SQLA + sphinx environment css_files -->
<!-- begin layout.mako headers -->
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT: '../',
VERSION: '0.9.8',
COLLAPSE_MODINDEX: false,
FILE_SUFFIX: '.html'
};
</script>
<!-- begin iterate through sphinx environment script_files -->
<script type="text/javascript" src="../_static/jquery.js"></script>
<script type="text/javascript" src="../_static/underscore.js"></script>
<script type="text/javascript" src="../_static/doctools.js"></script>
<!-- end iterate through sphinx environment script_files -->
<script type="text/javascript" src="../_static/detectmobile.js"></script>
<script type="text/javascript" src="../_static/init.js"></script>
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
<link rel="copyright" title="Copyright" href="../copyright.html" />
<link rel="top" title="SQLAlchemy 0.9 Documentation" href="../index.html" />
<link rel="up" title="Dialects" href="index.html" />
<link rel="next" title="Changes and Migration" href="../changelog/index.html" />
<link rel="prev" title="SQLite" href="sqlite.html" />
<!-- end layout.mako headers -->
</head>
<body>
<div id="docs-container">
<div id="docs-top-navigation-container" class="body-background">
<div id="docs-header">
<div id="docs-version-header">
Release: <span class="version-num">0.9.8</span> | Release Date: October 13, 2014
</div>
<h1>SQLAlchemy 0.9 Documentation</h1>
</div>
</div>
<div id="docs-body-container">
<div id="fixed-sidebar" class="withsidebar">
<div id="docs-sidebar-popout">
<h3><a href="../index.html">SQLAlchemy 0.9 Documentation</a></h3>
<p id="sidebar-paginate">
<a href="index.html" title="Dialects">Up</a> |
<a href="sqlite.html" title="SQLite">Prev</a> |
<a href="../changelog/index.html" title="Changes and Migration">Next</a>
</p>
<p id="sidebar-topnav">
<a href="../index.html">Contents</a> |
<a href="../genindex.html">Index</a>
</p>
<div id="sidebar-search">
<form class="search" action="../search.html" method="get">
<input type="text" name="q" size="12" /> <input type="submit" value="Search" />
<input type="hidden" name="check_keywords" value="yes" />
<input type="hidden" name="area" value="default" />
</form>
</div>
</div>
<div id="docs-sidebar">
<h3><a href="#">
Sybase
</a></h3>
<ul>
<li><a class="reference internal" href="#">Sybase</a><ul>
<li><a class="reference internal" href="#dialect-sybase">Support for the Sybase database.</a></li>
<li><a class="reference internal" href="#module-sqlalchemy.dialects.sybase.pysybase">python-sybase</a><ul>
<li><a class="reference internal" href="#dialect-sybase-pysybase-url">DBAPI</a></li>
<li><a class="reference internal" href="#dialect-sybase-pysybase-connect">Connecting</a></li>
<li><a class="reference internal" href="#unicode-support">Unicode Support</a></li>
</ul>
</li>
<li><a class="reference internal" href="#module-sqlalchemy.dialects.sybase.pyodbc">pyodbc</a><ul>
<li><a class="reference internal" href="#dialect-sybase-pyodbc-url">DBAPI</a></li>
<li><a class="reference internal" href="#dialect-sybase-pyodbc-connect">Connecting</a></li>
<li><a class="reference internal" href="#id1">Unicode Support</a></li>
</ul>
</li>
<li><a class="reference internal" href="#module-sqlalchemy.dialects.sybase.mxodbc">mxodbc</a><ul>
<li><a class="reference internal" href="#dialect-sybase-mxodbc-url">DBAPI</a></li>
<li><a class="reference internal" href="#dialect-sybase-mxodbc-connect">Connecting</a></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<div id="docs-body" class="withsidebar" >
<div class="section" id="module-sqlalchemy.dialects.sybase.base">
<span id="sybase"></span><span id="sybase-toplevel"></span><h1>Sybase<a class="headerlink" href="#module-sqlalchemy.dialects.sybase.base" title="Permalink to this headline">¶</a></h1>
<div class="section" id="dialect-sybase">
<p>Support for the Sybase database.</p>
<h2>DBAPI Support<a class="headerlink" href="#dialect-sybase" title="Permalink to this headline">¶</a></h2>
<p>The following dialect/DBAPI options are available. Please refer to individual DBAPI sections for connect information.<ul class="simple">
<li><a class="reference external" href="#module-sqlalchemy.dialects.sybase.pysybase">Python-Sybase</a></li>
<li><a class="reference external" href="#module-sqlalchemy.dialects.sybase.pyodbc">PyODBC</a></li>
<li><a class="reference external" href="#module-sqlalchemy.dialects.sybase.mxodbc">mxODBC</a></li>
</ul>
</p>
</div>
<div class="admonition note">
<p class="first admonition-title">Note</p>
<p class="last">The Sybase dialect functions on current SQLAlchemy versions
but is not regularly tested, and may have many issues and
caveats not currently handled.</p>
</div>
<div class="section" id="module-sqlalchemy.dialects.sybase.pysybase">
<span id="python-sybase"></span><h2>python-sybase<a class="headerlink" href="#module-sqlalchemy.dialects.sybase.pysybase" title="Permalink to this headline">¶</a></h2>
<p>Support for the Sybase database via the Python-Sybase driver.</p>
<div class="section" id="dialect-sybase-pysybase-url">
<h3>DBAPI<a class="headerlink" href="#dialect-sybase-pysybase-url" title="Permalink to this headline">¶</a></h3>
<p>Documentation and download information (if applicable) for Python-Sybase is available at:
<a class="reference external" href="http://python-sybase.sourceforge.net/">http://python-sybase.sourceforge.net/</a></p>
</div>
<div class="section" id="dialect-sybase-pysybase-connect">
<h3>Connecting<a class="headerlink" href="#dialect-sybase-pysybase-connect" title="Permalink to this headline">¶</a></h3>
<p>Connect String:<div class="highlight-python"><pre>sybase+pysybase://<username>:<password>@<dsn>/[database name]</pre>
</div>
</p>
</div>
<div class="section" id="unicode-support">
<h3>Unicode Support<a class="headerlink" href="#unicode-support" title="Permalink to this headline">¶</a></h3>
<p>The python-sybase driver does not appear to support non-ASCII strings of any
kind at this time.</p>
</div>
</div>
<div class="section" id="module-sqlalchemy.dialects.sybase.pyodbc">
<span id="pyodbc"></span><h2>pyodbc<a class="headerlink" href="#module-sqlalchemy.dialects.sybase.pyodbc" title="Permalink to this headline">¶</a></h2>
<p>Support for the Sybase database via the PyODBC driver.</p>
<div class="section" id="dialect-sybase-pyodbc-url">
<h3>DBAPI<a class="headerlink" href="#dialect-sybase-pyodbc-url" title="Permalink to this headline">¶</a></h3>
<p>Documentation and download information (if applicable) for PyODBC is available at:
<a class="reference external" href="http://pypi.python.org/pypi/pyodbc/">http://pypi.python.org/pypi/pyodbc/</a></p>
</div>
<div class="section" id="dialect-sybase-pyodbc-connect">
<h3>Connecting<a class="headerlink" href="#dialect-sybase-pyodbc-connect" title="Permalink to this headline">¶</a></h3>
<p>Connect String:<div class="highlight-python"><pre>sybase+pyodbc://<username>:<password>@<dsnname>[/<database>]</pre>
</div>
</p>
</div>
<div class="section" id="id1">
<h3>Unicode Support<a class="headerlink" href="#id1" title="Permalink to this headline">¶</a></h3>
<p>The pyodbc driver currently supports usage of these Sybase types with
Unicode or multibyte strings:</p>
<div class="highlight-python"><div class="highlight"><pre><span class="n">CHAR</span>
<span class="n">NCHAR</span>
<span class="n">NVARCHAR</span>
<span class="n">TEXT</span>
<span class="n">VARCHAR</span></pre></div>
</div>
<p>Currently <em>not</em> supported are:</p>
<div class="highlight-python"><div class="highlight"><pre><span class="n">UNICHAR</span>
<span class="n">UNITEXT</span>
<span class="n">UNIVARCHAR</span></pre></div>
</div>
</div>
</div>
<div class="section" id="module-sqlalchemy.dialects.sybase.mxodbc">
<span id="mxodbc"></span><h2>mxodbc<a class="headerlink" href="#module-sqlalchemy.dialects.sybase.mxodbc" title="Permalink to this headline">¶</a></h2>
<p>Support for the Sybase database via the mxODBC driver.</p>
<div class="section" id="dialect-sybase-mxodbc-url">
<h3>DBAPI<a class="headerlink" href="#dialect-sybase-mxodbc-url" title="Permalink to this headline">¶</a></h3>
<p>Documentation and download information (if applicable) for mxODBC is available at:
<a class="reference external" href="http://www.egenix.com/">http://www.egenix.com/</a></p>
</div>
<div class="section" id="dialect-sybase-mxodbc-connect">
<h3>Connecting<a class="headerlink" href="#dialect-sybase-mxodbc-connect" title="Permalink to this headline">¶</a></h3>
<p>Connect String:<div class="highlight-python"><pre>sybase+mxodbc://<username>:<password>@<dsnname></pre>
</div>
</p>
</div>
<div class="admonition note">
<p class="first admonition-title">Note</p>
<p class="last">This dialect is a stub only and is likely non functional at this time.</p>
</div>
</div>
</div>
</div>
</div>
<div id="docs-bottom-navigation" class="docs-navigation-links">
Previous:
<a href="sqlite.html" title="previous chapter">SQLite</a>
Next:
<a href="../changelog/index.html" title="next chapter">Changes and Migration</a>
<div id="docs-copyright">
© <a href="../copyright.html">Copyright</a> 2007-2014, the SQLAlchemy authors and contributors.
Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 1.2b1.
</div>
</div>
</div>
</body>
</html>