Обсуждение: Disabling case sensitivity
Hi I would like to know if there is some way how to disable case sensitivity in PostgreSQL server. With some varaiable or some setting in configuration file or how? So after this would be the same 'Good' and 'GOOD' or 'GoOd' in some SELECT from table where username='Good'. I wanna get the same row with: SELECT from table where username='GoOd'; Exactly like in MS SQL server. Thanks a lot for any help
On Wed, 2002-07-10 at 00:11, igor wrote: > I would like to know if there is some way how to disable case > sensitivity in PostgreSQL server. With some varaiable or some setting > in configuration file or how? > So after this would be the same 'Good' and 'GOOD' or 'GoOd' in some > SELECT from table where username='Good'. I wanna get the same row > with: > SELECT from table where username='GoOd'; > Exactly like in MS SQL server. You can use ILIKE, or search for a match to lower('GoOd') (or upper()).
On Tue, Jul 09, 2002 at 04:11:38PM -0700, igor <linux_211@hotmail.com> wrote a message of 12 lines which said: > I would like to know if there is some way how to disable case > sensitivity in PostgreSQL server. Always remember that case-INsensitivity is properly defined only for US-ASCII. Many PostgreSQL users store data in other scripts like Latin-1. > Exactly like in MS SQL server. What does MS SQL server does with Unicode? Does it map 'Stéphane' to 'STEPHANE'?