Case-sentiveness on pgsql

From: Fernando Lozano <fsl(at)centroin(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org, redhat-list(at)redhat(dot)com
Subject: Case-sentiveness on pgsql
Date: 2002-01-31 01:42:51
Message-ID: 3C58A11B.7ACCFAB3@centroin.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there!

Now that the accents problem is solved I have another question regarding
Java and PostgreSQL (maybe just Postgres):

How to make the database permform SORT and LIKE canse-insensitive,
without having to use non-standard or not-guaranteed SQL constructs?
Ideally, treating characters like á, ã, A, á, Ã and a as equivalents.

[]s, Fernando Lozano

Browse pgsql-general by date

  From Date Subject
Next Message arun kv 2002-01-31 04:32:15 keyword search help
Previous Message Fernando Lozano 2002-01-31 01:39:57 Re: pgsql, java and accents