1. Hibernate Criteria Searches and MS SQL Server Case Insens. forum.hibernate.orgHi All, When I do a search using a Criteria and Example objects, it of course ignores letter case due to MS SQL Server case-insensitiviy by default. For example, the following code: Criteria c = s.createCriteria(Invoice.class); Invoice exampleInvoice = new Invoice(); exampleInvoice.setName("Denis"); c.add(Example.create(exampleInvoice)); c.list() will also return invoices with names "denis" or "DENIS". However, this kinda affects Hibernate's cross-database portability and ... |
2. Criteria Searches and Case Insens. in MS SQL Server forum.hibernate.orgHi All, When I do a search using a Criteria and Example objects, it of course ignores letter case due to MS SQL Server case-insensitiviy by default. For example, the following code: Criteria c = s.createCriteria(Invoice.class); Invoice exampleInvoice = new Invoice(); exampleInvoice.setName("Denis"); c.add(Example.create(exampleInvoice)); c.list() will also return invoices with names "denis" or "DENIS". However, this kinda affects Hibernate's cross-database portability and ... |