<!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 1.2 Documentation </title> <!-- begin iterate through site-imported + 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/changelog.css" type="text/css" /> <link rel="stylesheet" href="../_static/sphinx_paramlinks.css" type="text/css" /> <!-- end iterate through site-imported + sphinx environment css_files --> <!-- begin layout.mako headers --> <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 1.2 Documentation" href="../index.html" /> <link rel="up" title="Dialects" href="index.html" /> <link rel="next" title="Frequently Asked Questions" href="../faq/index.html" /> <link rel="prev" title="Firebird" href="firebird.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">1.2.19</span> | Release Date: April 15, 2019 </div> <h1>SQLAlchemy 1.2 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 1.2 Documentation</a></h3> <p id="sidebar-topnav"> <a href="../contents.html">Contents</a> | <a href="../genindex.html">Index</a> </p> <div id="sidebar-search"> <form class="search" action="../search.html" method="get"> <label> Search terms: <input type="text" placeholder="search..." name="q" size="12" /> </label> <input type="hidden" name="check_keywords" value="yes" /> <input type="hidden" name="area" value="default" /> </form> </div> </div> <div id="docs-sidebar"> <div id="sidebar-banner"> </div> <div id="docs-sidebar-inner"> <h3> <a href="index.html" title="Dialects">Dialects</a> </h3> <ul> <li><span class="link-container"><a class="reference external" href="postgresql.html">PostgreSQL</a></span></li> <li><span class="link-container"><a class="reference external" href="mysql.html">MySQL</a></span></li> <li><span class="link-container"><a class="reference external" href="sqlite.html">SQLite</a></span></li> <li><span class="link-container"><a class="reference external" href="oracle.html">Oracle</a></span></li> <li><span class="link-container"><a class="reference external" href="mssql.html">Microsoft SQL Server</a></span></li> <li><span class="link-container"><a class="reference external" href="firebird.html">Firebird</a></span></li> <li class="selected"><span class="link-container"><strong>Sybase</strong><a class="paramlink headerlink reference internal" href="#">¶</a></span><ul> <li><span class="link-container"><a class="reference external" href="#dialect-sybase">Support for the Sybase database.</a></span></li> <li><span class="link-container"><a class="reference external" href="#module-sqlalchemy.dialects.sybase.pysybase">python-sybase</a></span><ul> <li><span class="link-container"><a class="reference external" href="#dialect-sybase-pysybase-url">DBAPI</a></span></li> <li><span class="link-container"><a class="reference external" href="#dialect-sybase-pysybase-connect">Connecting</a></span></li> <li><span class="link-container"><a class="reference external" href="#unicode-support">Unicode Support</a></span></li> </ul> </li> <li><span class="link-container"><a class="reference external" href="#module-sqlalchemy.dialects.sybase.pyodbc">pyodbc</a></span><ul> <li><span class="link-container"><a class="reference external" href="#dialect-sybase-pyodbc-url">DBAPI</a></span></li> <li><span class="link-container"><a class="reference external" href="#dialect-sybase-pyodbc-connect">Connecting</a></span></li> <li><span class="link-container"><a class="reference external" href="#id1">Unicode Support</a></span></li> </ul> </li> <li><span class="link-container"><a class="reference external" href="#module-sqlalchemy.dialects.sybase.mxodbc">mxodbc</a></span><ul> <li><span class="link-container"><a class="reference external" href="#dialect-sybase-mxodbc-url">DBAPI</a></span></li> <li><span class="link-container"><a class="reference external" href="#dialect-sybase-mxodbc-connect">Connecting</a></span></li> </ul> </li> </ul> </li> </ul> </div> </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><p><a class="reference external" href="#module-sqlalchemy.dialects.sybase.pysybase">Python-Sybase</a></p></li> <li><p><a class="reference external" href="#module-sqlalchemy.dialects.sybase.pyodbc">PyODBC</a></p></li> <li><p><a class="reference external" href="#module-sqlalchemy.dialects.sybase.mxodbc">mxODBC</a></p></li> </ul> </p> </div> <div class="admonition note"> <p class="admonition-title">Note</p> <p>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-default notranslate"><div class="highlight"><pre><span></span><span class="n">sybase</span><span class="o">+</span><span class="n">pysybase</span><span class="p">:</span><span class="o">//<</span><span class="n">username</span><span class="o">></span><span class="p">:</span><span class="o"><</span><span class="n">password</span><span class="o">>@<</span><span class="n">dsn</span><span class="o">>/</span><span class="p">[</span><span class="n">database</span> <span class="n">name</span><span class="p">]</span></pre></div> </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-default notranslate"><div class="highlight"><pre><span></span><span class="n">sybase</span><span class="o">+</span><span class="n">pyodbc</span><span class="p">:</span><span class="o">//<</span><span class="n">username</span><span class="o">></span><span class="p">:</span><span class="o"><</span><span class="n">password</span><span class="o">>@<</span><span class="n">dsnname</span><span class="o">></span><span class="p">[</span><span class="o">/<</span><span class="n">database</span><span class="o">></span><span class="p">]</span></pre></div> </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-default notranslate"><div class="highlight"><pre><span></span><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-default notranslate"><div class="highlight"><pre><span></span><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-default notranslate"><div class="highlight"><pre><span></span><span class="n">sybase</span><span class="o">+</span><span class="n">mxodbc</span><span class="p">:</span><span class="o">//<</span><span class="n">username</span><span class="o">></span><span class="p">:</span><span class="o"><</span><span class="n">password</span><span class="o">>@<</span><span class="n">dsnname</span><span class="o">></span></pre></div> </div> </p> </div> <div class="admonition note"> <p class="admonition-title">Note</p> <p>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, withsidebar"> Previous: <a href="firebird.html" title="previous chapter">Firebird</a> Next: <a href="../faq/index.html" title="next chapter">Frequently Asked Questions</a> <div id="docs-copyright"> © <a href="../copyright.html">Copyright</a> 2007-2019, the SQLAlchemy authors and contributors. Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 2.0.1. </div> </div> </div> <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: '../', VERSION: '1.2.19', COLLAPSE_MODINDEX: false, FILE_SUFFIX: '.html' }; </script> <script type="text/javascript" id="documentation_options" data-url_root="../" src="../_static/documentation_options.js"></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> <script type="text/javascript" src="../_static/language_data.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> </body> </html>