UTF-8 vs ASCII

From: Prasanth <dbadmin(at)nqadmin(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: UTF-8 vs ASCII
Date: 2006-04-26 20:01:44
Message-ID: 444FD1A8.7060306@nqadmin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Seems like by default database is created using UTF-8 when we use
createdb in 8.1.3.

Is there any big advantage of using UTF-8 rather than ASCII? Will there
be any performance difference when performing string operations?

Does the string functions convert every thing to UTF-8 before performing
the operations?

Surely it is going to increase by database size if we switch to UTF-8.

All the characters in my database should be ASCII. I use JDBC so will
there be any performance gain as the JDBC does not have to perform the
conversion?

Thanks,
-Prasanth.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gregory Maxwell 2006-04-26 20:11:47 UTF-8 vs ASCII
Previous Message Benjamin Krajmalnik 2006-04-26 17:50:12 Tale partitioning