Re: Storing Special Characters

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Storing Special Characters
Date: 2013-05-14 22:31:43
Message-ID: CAPTjJmpynL8Eueki1Kz8oWeGPxxaNgsWw0JZQaYLBBLXjg30fQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 15, 2013 at 8:20 AM, CR Lender <crlender(at)gmail(dot)com> wrote:
> On 2013-05-14 19:32, Paul Jungwirth wrote:
>> The UTF-8 encoding for a pound sign is 0xc2a3, not just 0xa3. You
>> might want to make sure your PHP file is correct.
>
> Just for the record, the Unicode code point for the pound symbol (£) is
> actually 0x00A3. 0xC2A3 is the Hangul syllable Syuh (슣).

Which, in UTF-8, is represented by the byte sequence C2 A3. (The
latter would be represented as EC 8A A3.)

ChrisA

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2013-05-14 22:35:02 Re: How to convert numbers into words in postgresql
Previous Message Merlin Moncure 2013-05-14 22:27:46 Re: How to convert numbers into words in postgresql