Обсуждение: Insert character codes in PosgreSQL with SQL command

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

Insert character codes in PosgreSQL with SQL command

От
"Sanjin"
Дата:
Hi,

Is it possible to insert character/s based on their character codes into
PosgreSQL with some SQL command?

i.e. INSERT INTO target_table VALUES 0x61 0x62 0x63 (values of characters
codes, not characters i.e. 'abc').

Thanks in advance

Sanjin



Re: Insert character codes in PosgreSQL with SQL command

От
Stephan Szabo
Дата:
On Thu, 13 Dec 2001, Sanjin wrote:

> Hi,
>
> Is it possible to insert character/s based on their character codes into
> PosgreSQL with some SQL command?
>
> i.e. INSERT INTO target_table VALUES 0x61 0x62 0x63 (values of characters
> codes, not characters i.e. 'abc').

There should be a chr() function that gives back the character with a
given code.