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
