UTF-8 and SQL-ASCII Encoding Differences

Posted on 2007-10-09
Last Modified: 2010-10-05
I need to know what the differences are between the following for a PostgreSQL database:
Encoding = UTF-8
Encoding = SQL-ASCII
Question by:FreightTrain
    1 Comment
    LVL 10

    Accepted 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

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: ( This requires some add-o…
    Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
    Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
    This video discusses moving either the default database or any database to a new volume.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now