Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Have you read the documentation? – Peter Eisentraut Oct 27 '11 at 17:01
up vote 4 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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