How does Oracle handle accents in queries?
<p>I'm using python to execute the following query in Oracle:</p>

<pre><code>SELECT COUNT(*) FROM TABLE WHERE DATA = 'CAMIÃN'
</code></pre>

<p>I'm getting a 0 when I should be getting a value different to 0 because there are rows where DATA is 'CAMIÃN'.</p>

<p>If you execute the query like this:</p>

<pre><code>SELECT COUNT(*) FROM TABLE WHERE DATA = 'CAMIN'
</code></pre>

<p>It will give you 0, so I'm thinking it might be due to the accent because it doesn't give an error, it seems oracle is removing the troubled character.</p>

<p>How does Oracle handle the accents? Does it remove those?</p>

<p>If alternative convention spelling is enabled, then the acents equivalent word will be taken by oracle. </p>

<p>For Example, </p>

<p>Character  Alternative Spelling
Ã¤           ae</p>

<p>You can use ctx_ddl.unset_attribute/ctx_ddl.set_attribute to set or unset alternative spelling conventions. </p>

python oracle