Home > mailing lists

Re: Re: [GENERAL] can postgresql supported utf8mb4 character sets? - Mailing list pgsql-general

From	lsliang
Subject	Re: Re: [GENERAL] can postgresql supported utf8mb4 character sets?
Date	March 6, 2015 05:55:05
Msg-id	201503061055293002598@pconline.com.cn Whole thread Raw
In response to	can postgresql supported utf8mb4 character sets ? ("lsliang" <lsliang@pconline.com.cn>)
Responses	Re: can postgresql supported utf8mb4 character sets? Re: Re: Re: [GENERAL] can postgresql supported utf8mb4 character sets?
List	pgsql-general

2015-03-06

发件人：Adrian Klaver

发送时间：2015-03-05 21:31:39

收件人：lsliang; pgsql-general

抄送：

主题：Re: [GENERAL] can postgresql supported utf8mb4 character sets?

On 03/05/2015 01:45 AM, lsliang wrote:

> can postgresql supported utf8mb4 character set?

> today mobile apps support 4-byte character and utf8 can only

> support 1-3 bytes character

The docs would seem to indicate otherwise:

http://www.postgresql.org/docs/9.3/interactive/multibyte.html

http://en.wikipedia.org/wiki/UTF-8

> if load string to database which contain a 4-byte character

> will failed .

Have you actually tried to load strings in to Postgres?

If so and it failed what was the method you used and what was the error?

> mysql since 5.5.3 support utf8mb4 character sets

> I don't find some information about postgresql

> thanks

Adrian Klaver

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

thanks for your help .

postgresql can support 4-byte character

test=> select * from utf8mb4_test ;

ERROR: character with byte sequence 0xf0 0x9f 0x98 0x84 in encoding "UTF8" has no equivalent in encoding "GB18030"

test=> \encoding utf8

test=> select * from utf8mb4_test ;

content

---------

ðŸ˜„

pcauto=>

From: Jim Nasby
Date: 06 March 2015, 04:51:53
Subject: Re: autovacuum worker running amok - and me too ;)

From: Medhavi Mahansaria
Date: 06 March 2015, 07:35:12
Subject: #PERSONAL# Reg: date going as 01/01/0001