<p dir="auto"><strong>Migrated issue, originally created by Anonymous</strong></p>
<p dir="auto">With the MySQL dialect it is currently possible to specify a collation for a VARCHAR column (as well as for TEXT and CHAR columns??).</p>
<p dir="auto">AFAIK that's not possible with the PostgreSQL dialect. That would be a nice feature to have, as the locale setting is set (in stone) when a Postgres database is created...</p>
<p dir="auto">I've just seen that someone requested the same feature for the SQLite dialect (bug <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="384624241" data-permission-text="Title is private" data-url="https://github.com/sqlalchemy/sqlalchemy/issues/2276" data-hovercard-type="issue" data-hovercard-url="/sqlalchemy/sqlalchemy/issues/2276/hovercard" href="https://github.com/sqlalchemy/sqlalchemy/issues/2276">#2276</a>).<br>
So maybe that collation feature could be implemented in a more generic way inside SQLAlchemy?</p>
<p dir="auto">Thanks a lot!</p>
<p dir="auto">Currently the <code class="notranslate">AsyncEngine</code> implements just the methods <code class="notranslate">begin</code>, <code class="notranslate">connect</code> and <code class="notranslate">raw_connection</code>.</p>
<p dir="auto">It should probably implement also the other api of the engine 2.0. As support for inspection is missing.</p>
<p dir="auto">The api for the engine would be:</p>
<ul dir="auto">
<li>attr <code class="notranslate">uri</code>, <code class="notranslate">pool</code>, <code class="notranslate">dialect</code>, <code class="notranslate">engine</code>, <code class="notranslate">name</code>, <code class="notranslate">driver</code>, <code class="notranslate">echo</code></li>
<li>methods <code class="notranslate">clear_compiled_cache</code>, <code class="notranslate">update_execution_options</code>, <code class="notranslate">execution_options</code>, <code class="notranslate">get_execution_options</code>, <code class="notranslate">dispose</code></li>
</ul>
<p dir="auto">Also the <code class="notranslate">AsyncSession</code> has some part of the api missing (non complete list):</p>
<ul dir="auto">
<li>attr <code class="notranslate">bind</code>, <code class="notranslate">new</code>, <code class="notranslate">deleted</code></li>
<li>methods <code class="notranslate">get</code>, <code class="notranslate">delete</code></li>
</ul>
<p dir="auto">The same may apply to other <code class="notranslate">Async</code> classes that proxy the sync ones, like <code class="notranslate">AsyncConnection</code></p>