Case of strings
| От | Simon Windsor |
|---|---|
| Тема | Case of strings |
| Дата | |
| Msg-id | E1Awgi6-0007bk-00@gaul.cornfield.org.uk обсуждение |
| Ответы |
Re: Case of strings
Re: Case of strings |
| Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: