Re: convert string function and built-in conversions

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: culley harrelson <culley(at)fastmail(dot)fm>
Cc: pg-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: convert string function and built-in conversions
Date: 2003-10-19 07:31:43
Message-ID: 20031019002651.C60250@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Net Virtual Mailing Lists 2003-10-19 14:23:22 tsearch2 question...
Previous Message Dennis Gearon 2003-10-19 01:21:28 Dilbert Experiences a 'Database Manager' moment