<h3 dir="auto">Describe the bug</h3>
<p dir="auto">When a model has a <code class="notranslate">LargeBinary</code> column, and I try to  <code class="notranslate">first()</code> or <code class="notranslate">one()</code> a query, a TypeError is raised.<br>
Please see the error message below.</p>
<h3 dir="auto">To Reproduce</h3>
<p dir="auto">The model looks like this:</p>
<div class="highlight highlight-source-python notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    username = Column(String(20), unique=True)
    email = Column(String(100), unique=True)
    password_hash = Column(LargeBinary(length=100))
    
    # added init
    def __init__():
       ..."><pre class="notranslate"><span class="pl-k">class</span> <span class="pl-v">User</span>(<span class="pl-v">Base</span>):
    <span class="pl-s1">__tablename__</span> <span class="pl-c1">=</span> <span class="pl-s">'users'</span>

    <span class="pl-s1">id</span> <span class="pl-c1">=</span> <span class="pl-v">Column</span>(<span class="pl-v">Integer</span>, <span class="pl-s1">primary_key</span><span class="pl-c1">=</span><span class="pl-c1">True</span>)
    <span class="pl-s1">username</span> <span class="pl-c1">=</span> <span class="pl-v">Column</span>(<span class="pl-v">String</span>(<span class="pl-c1">20</span>), <span class="pl-s1">unique</span><span class="pl-c1">=</span><span class="pl-c1">True</span>)
    <span class="pl-s1">email</span> <span class="pl-c1">=</span> <span class="pl-v">Column</span>(<span class="pl-v">String</span>(<span class="pl-c1">100</span>), <span class="pl-s1">unique</span><span class="pl-c1">=</span><span class="pl-c1">True</span>)
    <span class="pl-s1">password_hash</span> <span class="pl-c1">=</span> <span class="pl-v">Column</span>(<span class="pl-v">LargeBinary</span>(<span class="pl-s1">length</span><span class="pl-c1">=</span><span class="pl-c1">100</span>))
    
    <span class="pl-c"># added init</span>
    <span class="pl-k">def</span> <span class="pl-en">__init__</span>():
       ...</pre></div>
<p dir="auto">The code:</p>
<div class="highlight highlight-source-python notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="session = SessionLocal()
user = User('username', 'email', 'password')
session.add(user)
session.commit()

user = session.query(User).filter(User.username=='username').one()
# the error also occurs with 'first()'"><pre class="notranslate"><span class="pl-s1">session</span> <span class="pl-c1">=</span> <span class="pl-v">SessionLocal</span>()
<span class="pl-s1">user</span> <span class="pl-c1">=</span> <span class="pl-v">User</span>(<span class="pl-s">'username'</span>, <span class="pl-s">'email'</span>, <span class="pl-s">'password'</span>)
<span class="pl-s1">session</span>.<span class="pl-en">add</span>(<span class="pl-s1">user</span>)
<span class="pl-s1">session</span>.<span class="pl-en">commit</span>()

<span class="pl-s1">user</span> <span class="pl-c1">=</span> <span class="pl-s1">session</span>.<span class="pl-en">query</span>(<span class="pl-v">User</span>).<span class="pl-en">filter</span>(<span class="pl-v">User</span>.<span class="pl-s1">username</span><span class="pl-c1">==</span><span class="pl-s">'username'</span>).<span class="pl-en">one</span>()
<span class="pl-c"># the error also occurs with 'first()'</span></pre></div>
<h3 dir="auto">Error</h3>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="Traceback (most recent call last):
  File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;
  File &quot;/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py&quot;, line 2865, in one
    return self._iter().one()
  File &quot;/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py&quot;, line 1417, in one
    return self._only_one_row(
  File &quot;/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py&quot;, line 559, in _only_one_row
    row = onerow(hard_close=True)
  File &quot;/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py&quot;, line 1281, in _fetchone_impl
    return self._real_result._fetchone_impl(hard_close=hard_close)
  File &quot;/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py&quot;, line 1684, in _fetchone_impl
    row = next(self.iterator, _NO_ROW)
  File &quot;/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/loading.py&quot;, line 147, in chunks
    fetch = cursor._raw_all_rows()
  File &quot;/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py&quot;, line 393, in _raw_all_rows
    return [make_row(row) for row in rows]
  File &quot;/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py&quot;, line 393, in &lt;listcomp&gt;
    return [make_row(row) for row in rows]
  File &quot;/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/sqltypes.py&quot;, line 993, in process
    value = bytes(value)
TypeError: string argument without an encoding"><pre class="notranslate"><code class="notranslate">Traceback (most recent call last):
  File "&lt;stdin&gt;", line 1, in &lt;module&gt;
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2865, in one
    return self._iter().one()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1417, in one
    return self._only_one_row(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 559, in _only_one_row
    row = onerow(hard_close=True)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1281, in _fetchone_impl
    return self._real_result._fetchone_impl(hard_close=hard_close)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 1684, in _fetchone_impl
    row = next(self.iterator, _NO_ROW)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 147, in chunks
    fetch = cursor._raw_all_rows()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 393, in _raw_all_rows
    return [make_row(row) for row in rows]
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/result.py", line 393, in &lt;listcomp&gt;
    return [make_row(row) for row in rows]
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/sqltypes.py", line 993, in process
    value = bytes(value)
TypeError: string argument without an encoding
</code></pre></div>
<h3 dir="auto">Versions</h3>
<ul dir="auto">
<li>OS: macOS</li>
<li>Python: 3.10</li>
<li>SQLAlchemy: 1.4.37</li>
<li>Database: MariaDB (MySQL)</li>
<li>DBAPI (eg: psycopg, cx_oracle, mysqlclient): pymysql</li>
</ul>
<h3 dir="auto">Additional context</h3>
<p dir="auto"><em>No response</em></p>
<p dir="auto"></p><div class="Box Box--condensed my-2">
  <div class="Box-header f6">
    <p class="mb-0 text-bold">
      <a href="https://github.com/sqlalchemy/sqlalchemy/blob/5881fd274015af3de37f2ff0f91ff6a7c61c1540/lib/sqlalchemy/sql/sqltypes.py#L945">sqlalchemy/lib/sqlalchemy/sql/sqltypes.py</a>
    </p>
    <p class="mb-0 color-fg-muted">
         Line 945
      in
      <a data-pjax="true" class="commit-tease-sha" href="/sqlalchemy/sqlalchemy/commit/5881fd274015af3de37f2ff0f91ff6a7c61c1540">5881fd2</a>
    </p>
  </div>
  <div itemprop="text" class="Box-body p-0 blob-wrapper blob-wrapper-embedded data">
    <table class="highlight tab-size mb-0 js-file-line-container" data-tab-size="8" data-paste-markdown-skip="">

        <tbody><tr class="border-0">
          <td id="L945" class="blob-num border-0 px-3 py-0 color-bg-default" data-line-number="945"></td>
          <td id="LC945" class="blob-code border-0 px-3 py-0 color-bg-default blob-code-inner js-file-line"> <span class="pl-s1">value</span> <span class="pl-c1">=</span> <span class="pl-en">bytes</span>(<span class="pl-s1">value</span>) </td>
        </tr>
    </tbody></table>
  </div>
</div>
<br>
value = bytes(value)<br>
改为<br>
value = bytes(value, 'utf8')<p></p>
<p dir="auto">fix</p>