Hi Jaime,
Jaime Casanova writes:
> The database has sql_ascii
>
>> What Spanish character do you mean?
>
> ñ, Ñ, á, é, í, ó, ú
Just to support and emphasize what Dave already said:
Because there are no Spanish characters in ASCII (ASCII is a 7 bit
encoding), a database in SQL_ASCII may do anything with those
characters. Change the database encoding to LATIN9 (if you only need
Spanish plus the Euro character) or UNICODE (if you may need to
support other languages in the future).
> matrícula become matr||ula
> peña become pe°a
IOW, the database or the ODBC driver has replaced the non-ASCII
characters with ASCII characters that have the same code point but
modulo 128 (throwing away the highest bit). That is a common
behaviour for ASCII-only systems, e.g. also often seen in email. This
behaviour can not be reversed after it has happened.
benny