some tables unicode, some ascii?

From: Gene <genekhart(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: some tables unicode, some ascii?
Date: 2007-02-25 04:35:10
Message-ID: 430d92a20702242035o1e661688w92a0a6d407a1292b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm having some issues with being able to use indexes on certain
columns/queries because of the unicode encoding. This table doesn't
really need to use unicode and contains only valid ascii-range
characters but since I have one other table that needs unicode data
the whole database is inited to UTF8 en_US. Is there a way to get the
benefit of using ascii and the "C" locale for index usage on certain
tables and unicode encoding on others (where peformance is not an
issue)? In particular the planner will not use index with Unicode on
"like '123%' " queries.

Thanks,
gene

Responses

Browse pgsql-general by date

  From Date Subject
Next Message RPK 2007-02-25 04:53:51 Inserting a new column in between.
Previous Message Dave Page 2007-02-25 04:27:43 Re: Ruby on Rails for PostgreSQL