Home » Developing U++ » U++ TheIDE and Library: Releases and ChangeLogs » One more sql news
| One more sql news [message #16563] |
Thu, 26 June 2008 15:02 |
|
|
Like has now case sensitive parameter (default: false). In fact it works only with postgres which on default is case sesitive (opposite to mysql or mssql) and if a value of this parameter is false postgres uses ilike command. Example:
SQL * Select(ID, NAME)
.From(PERSONS)
.Where(Like(NAME, "%JA%", true))
output:
select id, name from persons where name like '%JA%'
SQL * Select(ID, NAME)
.From(PERSONS)
.Where(Like(NAME, "%JA%"))
output:
select id, name from persons where name ilike '%JA%'
|
|
|
|
Goto Forum:
Current Time: Sat Apr 20 11:38:59 CEST 2024
Total time taken to generate the page: 0.04459 seconds
|
Members
Pages
Help
Register
Login
Home
