Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
4  
Have you read the documentation? postgresql.org/docs/current/static/multibyte.html –  Peter Eisentraut Oct 27 '11 at 17:01
add comment

1 Answer

up vote 2 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
add comment

Your Answer

 
discard

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.