Re: [GENERAL] case-insensitive database

[Dennis Gearon]

Relaxin wrote:

No, I mean the data.

select * from stocks where symbol = 'AADBX'
and
select * from stocks where symbol = 'aadbx'
would bring up the same result set.

 

Look in the manuals, there are SQL functions like:

STRTOLOWER( ); STRTOUPPER() like those in 'C'

Usage:
-------
SELECT * 
FROM stocks
WHERE
	STRTOLOWER( symbol ) = STRTOLOWER( 'AADBX' );



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster