A
A
Alexander2021-01-25 23:58:52
PostgreSQL
Alexander, 2021-01-25 23:58:52

Why is the Cyrillic alphabet not output to the console when encoding the utf-8 base?

Good evening, I have the following database:
600f2e020e4ba444602466.png
As you can see, the utf-8 encoding, by googling they will also look at the following variable:
600f2e6559361026184072.png
When I make a simple request from the console, for example, Cyrillic is displayed in a different encoding in the state field - the json field type, in other fields it is normally displayed, which just character.
select state from users;
600f310a6c5bf434067415.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Daniil Vasilyev, 2021-01-26
@AlexMine

According to the utf standard, characters are written as codes during serialization.
So the behavior is correct. Copy the JSON and deserialize.
https://tools.ietf.org/html/rfc7159#section-8.2

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question