pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
UTF-8 vs ASCII
2+ messages / 2 participants
[nested] [flat]

* UTF-8 vs ASCII
@ 2006-04-26 20:01 Prasanth <dbadmin@nqadmin.com>
  2006-04-26 20:11 ` UTF-8 vs ASCII Gregory Maxwell <gmaxwell@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Prasanth @ 2006-04-26 20:01 UTC (permalink / raw)
  To: 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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* UTF-8 vs ASCII
  2006-04-26 20:01 UTF-8 vs ASCII Prasanth <dbadmin@nqadmin.com>
@ 2006-04-26 20:11 ` Gregory Maxwell <gmaxwell@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Gregory Maxwell @ 2006-04-26 20:11 UTC (permalink / raw)
  To: pgsql-admin

On 4/26/06, Prasanth <dbadmin@nqadmin.com> wrote:
> 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?

Perhaps you are confusing UTF-8 and UTF-16?

UTF-8 is a strict superset of ASCII with the same physical encoding
for ASCII characters.

See:
http://en.wikipedia.org/wiki/ASCII
and
http://en.wikipedia.org/wiki/UTF-8

(and BTW, your email address bounced)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-04-26 20:11 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-26 20:01 UTF-8 vs ASCII Prasanth <dbadmin@nqadmin.com>
2006-04-26 20:11 ` Gregory Maxwell <gmaxwell@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox