| From: | "Marko Kreen" <markokr(at)gmail(dot)com> |
|---|---|
| To: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org> |
| Cc: | Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>, pgsql-hackers(at)postgresql(dot)org, eg(at)cybertec(dot)at |
| Subject: | Re: Bug with UTF-8 character |
| Date: | 2006-05-26 14:16:59 |
| Message-ID: | e51f66da0605260716j7d9b13c9y271974e031f11b61@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 5/26/06, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> On Fri, May 26, 2006 at 08:21:56AM +0200, Hans-Jürgen Schönig wrote:
> > I got a bug request for the following unicode character in PostgreSQL
> > 8.1.4: 0xedaeb8
> >
> > ERROR: invalid byte sequence for encoding "UTF8": 0xedaeb8
> Your character converts to char DBB8. According to the standard,
> characters in the range D800-DFFF are not characters but surrogates.
> They don't mean anything by themselves and are thus rejected by
> postgres.
>
> http://www.unicode.org/faq/utf_bom.html#30
>
> This character should be preceded by a low surrogate (D800-DBFF). You
> should combine the two into a single 4-byte UTF-8 character.
You are talking about UTF16, not UTF8.
--
marko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2006-05-26 14:17:08 | Re: XLogArchivingActive |
| Previous Message | Martijn van Oosterhout | 2006-05-26 13:48:33 | Re: Bug with UTF-8 character |