• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3335
  • Last Modified:

UTF-8 and SQL-ASCII Encoding Differences

I need to know what the differences are between the following for a PostgreSQL database:
Encoding = UTF-8
Encoding = SQL-ASCII
1 Solution
UTF-8 is a unicode character set using 1-4 bytes and can be used for all the languages.
SQL-ASCII is a characters set using 1 byte and can be used for any language.

This means that UTF-8 can store any set of characters you want, while SQL-ASCII is primarily for ASCII characters. You will be able to store other characters in SQL-ASCII but the results of some of string functions might be incorrect since PostgreSQL will not know that it may be manipulating a multi-byte characters.

UTF-8 is safer to use and it allows for scalability. However, there is a certain performance cost associated with a character set.

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now