Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA01805 for ; Sun, 13 Jun 1999 13:25:53 -0400 (EDT) (envelope-from lockhart@alumni.caltech.edu) Received: from localhost (root@hectic-1.jpl.nasa.gov [128.149.68.203]) by trends.net (8.8.8/8.8.8) with ESMTP id LAA12776 for ; Sun, 13 Jun 1999 11:59:40 -0400 (EDT) Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1]) by localhost (8.8.7/8.8.7) with ESMTP id PAA23454; Sun, 13 Jun 1999 15:53:49 GMT Sender: lockhart@trends.net Message-ID: <3763D40D.72D0972F@alumni.caltech.edu> Date: Sun, 13 Jun 1999 15:53:49 +0000 From: Thomas Lockhart X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Hannu Krosing CC: phd2@earthling.net, "'Oleg Bartunov'" , "'hackers@postgresql.org'" , Tatsuo Ishii Subject: Re: [HACKERS] Postgres 6.5 beta2 and beta3 problem References: <3762A415.BC415D4C@trust.ee> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > Well, the problem is that while I do occasionally need cyrillic chars, > I also need English, Estonian, Finnish/Swedish, Latvian and Lithuanian. > The only two of them that don't have overlapping character codes are > Russian (all chars >127) and English (all < 128) > My current solution is to run without --enable-locale and do all the > sorting > in the client. But it would be often useful to have language specific > columns. Great! You're our representative for multi-charset usage :) Perhaps you can think about and comment on the SQL92 features which support this, and whether that kind of capability would suit your needs. Of course, we would need to start getting specific about how to map those generic features into a Postgres implementation... btw, istm that we could make things somewhat backward compatible by allowing the backend to be built with CHAR and NCHAR always mapped to NCHAR. - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California