Oracle Database Discussions

Hi,

I had an requirement to store Spanish character and also need to fileter the records based on the Spanish character.

Kindly guide me for below.

To filter the Records which contains spanish characters?
To get the ASCII Values for the particular column?

E.g. we can find out the ASCII value of 'a' by using the syntax select ASCII('a') from dual.

But I want to find the ASCII Values for the particular column value. Ie. name.
E.g., Client name is "Suresh", I want to the ASCII Values for entire name of "Suresh".

Kindly do the needful help / Guidance on this.

Thanks,
Orahar