Skip site navigation (1) Skip section navigation (2)

Entering a character code in a query

From: John Gage <jsmgage(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Entering a character code in a query
Date: 2010-03-08 16:24:09
Message-ID: cd15286d1003080824r590bcb5exba6af73860dee445@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I would like to use the following query:

SELECT english || '\n' || english || '\x2028' || french AS output FROM
vocab_words_translated;

where \x2028 is the hexadecimal code for a soft carriage return.

However, this does not work.

Can anyone help with this problem?

Thanking you,

John

Pertinent codes:

2028 LINE SEPARATOR * may be used to represent this semantic unambiguously
U+2028, character 
‬, decimal 8232, hex 0x2028, octal \20050, binary
10000000101000 UTF-8: 0xe2 0x80 0xa8

Responses

pgsql-novice by date

Next:From: Joyce Gerald-LGJ002Date: 2010-03-08 21:30:52
Subject: 'database cluster initialization failed' in Linux
Previous:From: Scott MarloweDate: 2010-03-08 07:33:38
Subject: Re: [NOVICE] How to read oracle table's data from postgre

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group