Re: convert string function and built-in conversions - Mailing list pgsql-general

From Stephan Szabo
Subject Re: convert string function and built-in conversions
Date
Msg-id 20031019002651.C60250@megazone.bigpanda.com
Whole thread Raw
In response to convert string function and built-in conversions  ("culley harrelson" <culley@fastmail.fm>)
Responses Re: convert string function and built-in conversions
List pgsql-general
On Sun, 19 Oct 2003, culley harrelson wrote:

> It seems to me that these values should be the same:
>
> select 'lydia eugenia treviño', convert('lydia eugenia treviño' using
> ascii_to_utf_8);
>
> but they seem to be different.  What am I missing?

I don't think the marked n is a valid ascii character (it might be
extended ascii, but that's different and not really standard afaik).
You're probably getting the character associated with the lower 7 bits.

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Dilbert Experiences a 'Database Manager' moment
Next
From: "Net Virtual Mailing Lists"
Date:
Subject: tsearch2 question...