Re: ODBC Driver stability

--- Benjamin Riefenstahl
<Benjamin(dot)Riefenstahl(at)epost(dot)de> escribió:
> 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
>

Just for me to understand this right. when i use vb
with the odbc i got these changes in non-ASCII
characters but NO when using EMS pgmanager nor when
selecting directly from psql.

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com