How is the Unicode support of PostgreSQL?

If I want to save Unicode data does it have to go through the conversion process while storing and retrieving? If yes then what is the performance of such conversion?

If there is such a conversion, will it come into play when storing simple ASCII data?


1 Answer 1


Unicode encoding support in PostgreSQL is stellar and is implemented using the UTF-8 character encoding.

If the client uses a different encoding than the server, automatic character set conversion occurs, paying a negligible performance penalty.

ASCII data does not require conversion to the UTF-8 character encoding, so no performance penalty there.

Please refer to the PostgreSQL Localization documentation for further information.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.