Entering a character code in a query

From: John Gage <jsmgage(at)numericable(dot)fr>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Entering a character code in a query
Date: 2010-03-08 16:19:17
Message-ID: BAB4EE58-D8D3-4CF8-9524-F80B76DDE521@numericable.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Brad Nicholson 2010-03-08 16:25:27 8.3.10 Changes
Previous Message Adrian von Bidder 2010-03-08 16:09:14 DROP column: documentation unclear