Hi
I have moved an application from MySQL to PgSQL, and after the making changes I thought all was ok.
However, I have just realised that
Where A = ‘STRING’
Is not the same as
Where A =’String’
Is there anyway I can force the PgSQL to accept case equivalence, or must I add upper()/lower() to force the case and then make string tests?
Ie Where upper(A)=upper(‘String’)
Many thanx
Simon
Simon Windsor
Eml: simon.windsor@cornfield.org.uk
Tel: 01454 617689
Mob: 07960 321599
--
This message has been scanned for viruses and
dangerous content by
MailScanner, and is
believed to be clean.
Mailscanner thanks
transtec Computers for their support.
