Thread: Insert character codes in PosgreSQL with SQL command

Insert character codes in PosgreSQL with SQL command

From
"Sanjin"
Date:
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

From
Stephan Szabo
Date:
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.