Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1O4HBx47676 for ; Fri, 23 Feb 2001 23:17:11 -0500 (EST) (envelope-from pgsql-general-owner@postgresql.org) Received: from depesz.pl ([212.244.29.5]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1M7w0x12375; Thu, 22 Feb 2001 02:58:00 -0500 (EST) (envelope-from depesz@depesz.pl) Received: (from depesz@localhost) by depesz.pl (8.11.2/8.11.2) id f1M7Kjs01688; Thu, 22 Feb 2001 08:20:45 +0100 Date: Thu, 22 Feb 2001 08:20:45 +0100 From: hubert depesz lubaczewski To: pgsql-general@postgresql.org Cc: PGSQL-SQL Subject: creating tables with different character set? Message-ID: <20010222082045.B1657@depeszws.depesz.pl> Reply-To: depesz@depesz.pl Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.5i X-Archive-Number: 200102/1231 X-Sequence-Number: 5181 hi, i have a problem. i'm living in poland, which has its national characters. of course they work great under postgresql, but: when i use non-C locale all ~ '^xxx' and like 'xxx%' searches are not using index scan. this is paintful. for some of the tables i dont need all national characters. in fact i use only a-z0-9 characters which are subset of standard C-locale character set. so my question is. is it possible to make a table that way, that it will allow using indexing when searching for first x characters of string. at the moment the only solution i got is to make another database (with another postmaster process), but this is definetly not easy way. any other options? depesz -- hubert depesz lubaczewski http://www.depesz.pl/ ------------------------------------------------------------------------ najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo, jest niesamowita wręcz łatwość unikania kontaktów z nim ...