X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 21BFD11F60E7 for ; Wed, 26 Apr 2006 17:02:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 97147-02 for ; Wed, 26 Apr 2006 17:01:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.liquidcore.com (mail.liquidcore.com [70.151.60.104]) by postgresql.org (Postfix) with ESMTP id 6D82C11F61EE for ; Wed, 26 Apr 2006 17:01:53 -0300 (ADT) Received: (from root@localhost) by mail.liquidcore.com (8.13.1/8.13.1) id k3QK2406018603 for pgsql-admin@postgresql.org; Wed, 26 Apr 2006 15:02:04 -0500 Received: from [192.168.0.81] (ppasalalinux.nqadmin.com [192.168.0.81]) by mail.liquidcore.com (8.13.1/8.13.1) with ESMTP id k3QK23Kb018517 for ; Wed, 26 Apr 2006 15:02:03 -0500 Message-ID: <444FD1A8.7060306@nqadmin.com> Date: Wed, 26 Apr 2006 15:01:44 -0500 From: Prasanth Reply-To: dbadmin@nqadmin.com User-Agent: Thunderbird 1.5 (X11/20060313) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: UTF-8 vs ASCII Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-scanner: Scanned for malicious content X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/281 X-Sequence-Number: 21450 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.