Re: Encoding problem

[Arnaud Lesauvage <thewild(at)freesurf(dot)fr>]

Albe Laurenz a écrit :
> > I am trying to remove accents from a string. I found a nice 
> > solution for this on postgresqlfr, using the to_ascii() 
> > function.
> >
> > Now, the problem I have is :
> >
> > mydb=# SELECT to_ascii(convert('abcdef', 'LATIN9'));
> > ERROR:  encoding conversion from UTF8 to ASCII not supported
> >
> > Why is the conversion to LATIN9 not working as expected ?
> > My database's encoding is UTF8.
>
> Maybe you actually want to
>
> test=> select to_ascii(convert('ábcdêf', 'LATIN9'), 'LATIN9');
>  to_ascii 
> ----------
>  abcdef
> (1 row)

Indeed !!!
Thanks a lot !
I suppose that not giving the encoding to 'to_ascii' 
defaulted to the database encoding ?
Sorry for this mistake, I did not realize that this setting 
existed for the to_ascii function...

Thanks again !

--
Arnaud