Обсуждение: Entering a character code in a query

Поиск
Список
Период
Сортировка

Entering a character code in a query

От
John Gage
Дата:
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 10000000101000UTF-8: 0xe2 0x80 0xa8 

Re: Entering a character code in a query

От
"Albe Laurenz"
Дата:
John Gage wrote:
> 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?

If you have PostgreSQL 8.4 with standard_conforming_strings = on,
you could write:

english || E'\n' || english || U&'\2028' || french

Otherwise, you have to resort to

english || E'\n' || english || chr(8232) || french

(provided your server_encoding is UTF8).

Yours,
Laurenz Albe

Re: Entering a character code in a query

От
John Gage
Дата:
I would just like to thank Albe and Jasen for their responses.  What an extraordinary environment Postgres is!  Human and computing.

On Tue, Mar 9, 2010 at 1:32 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
John Gage wrote:
> 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?

If you have PostgreSQL 8.4 with standard_conforming_strings = on,
you could write:

english || E'\n' || english || U&'\2028' || french

Otherwise, you have to resort to

english || E'\n' || english || chr(8232) || french

(provided your server_encoding is UTF8).

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general