<div>
try this:<br />
<br />
convert ('João', 'US7ASCII', 'WE8ISO8859P1')
</div>


try this:

convert ('João', 'US7ASCII', 'WE8ISO8859P1')

<div>
The only problem of this function is that it doesn't convert the signal ~ <br />
<br />
Example: <br />
joão -&gt; jo?o<br />
Joáo -&gt; Joao<br />
<br />
It has another skill to I convert the words that use the signal ~ &nbsp;????<br />
<br />
Thank´s
</div>


The only problem of this function is that it doesn't convert the signal ~

Example:
joão -> jo?o
Joáo -> Joao

It has another skill to I convert the words that use the signal ~  ????

Thank´s

<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
Question: You know some function (pl/sql) to remove accents of strings?<br />
example: string &quot;João&quot; - &quot;Joao&quot;. In this in case, you can use the function traslate (), but it isn't ideal resource.<br />
<br />
Thank´s<br />
Rafael Schardosin<br />
Porto Alegre - Brazil<br />

</div>
</div>


hi,

Question: You know some function (pl/sql) to remove accents of strings?
example: string "João" - "Joao". In this in case, you can use the function traslate (), but it isn't ideal resource.

Thank´s
Rafael Schardosin
Porto Alegre - Brazil


function (pl/sql) to remove accents of strings

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.