get Unicode value [PostgreSQL]

Question

If you see this link

Its all about unicode code range

example :

U+0644  ل   d9 84   ARABIC LETTER LAM

In PostgreSQL its easy to get hex value :

select encode('ل','hex')

it will return the hex value, d9 84.

but how to get the unicode code point ?

Thanks

Anders Lindahl · Accepted Answer · 2011-08-07 09:58:24Z

1

If your input string is in UTF-8, you can use the ascii function:

ascii(string) int

ASCII code of the first character of the argument. For UTF8 returns the Unicode code point of the character. For other multibyte encodings. the argument must be a strictly ASCII character.

answered Aug 7, 2011 at 9:58

Anders Lindahl

43.3k9 gold badges93 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Thessa Over a year ago

I tried select ascii('ل')::int but the result is '1604', not 644. Thanks

Anders Lindahl Over a year ago

1604 is the decimal representation of the hexadecimal value 0x644 - if you want the hexadecimal value, run to_hex(ascii('ل')).

Thessa Over a year ago

Hi Andres i have new problem using running this query select decode(to_hex(ascii('ل')::int),'hex'); i got error "ERROR: invalid hexadecimal data: odd number of digits"

Anders Lindahl Over a year ago

Hmm, why would you want to do that? It seems backwards, as you already have a character?

sayap Over a year ago

@Thessa, if you want to reverse the process, you can use chr(), e.g. chr(1604) will give 'ل'

Collectives™ on Stack Overflow

get Unicode value [PostgreSQL]

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related