T
T
todatasudata2021-03-25 12:48:07
PostgreSQL
todatasudata, 2021-03-25 12:48:07

How to get human readable display of unicode characters?

I have a json blob field in the Postgres database, it stores Russian-language texts in unicode.
I have no problems with their conversion and output.
But I would like, by opening some pgAdmin or DataGrip, to see what is written there with my own eyes, but I see a la "\u0415\u043b\u0435\u043d\u0430"

somehow can this problem be solved?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
V
Vasily Bannikov, 2021-03-25
@vabka

Well, let the one who writes it there writes in a normal way.
PS: It says "Elena"

R
Ross Alex, 2021-03-25
@Wacdis

It's not a problem, it's Unicode. Write your pgAdmin where such fields will be converted...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question