Re: can i use to_ascii function ?

[Please reply to the mailing list so others can participate in and
learn from the discussion.]

On Sat, Feb 24, 2007 at 10:41:51AM +0100, j n wrote:
> maybe one more suggestion ...
> this type
>
> to_ascii(convert(lastname, 'LATIN2'), 'LATIN2')
>
> was not working fine unless i use ./configure --with-perl option i don't
> know if this is real reason ..., but i have not change anything else ...

The above expression has nothing to do with Perl unless perhaps you
have like-named PL/Perl functions in your database and you've set
search_path to find them ahead of the ones in pg_catalog, which is
unlikely. I suspect that the relevant difference between your test
environments is something else.

What exactly do you mean by "not working fine"? What did you do,
what were you expecting to happen, and what did happen? Can you
post a standalone test case?

What version of PostgreSQL are you running? What platform? What
are the server and client encodings? What are the server's locale
settings?

--
Michael Fuhr