How to add "COLLATE latin1_general_ci" in DataSource file or in Advanced Criteria

[mayankrjain]

I want to know that how I add "COLLATE latin1_general_ci" statement in DataSource (*.ds.xml) or in Criteria/ Advance Criteria Statment.

My query is as follows.

select * from students where student_name like 'A%' COLLATE latin1_general_ci;


Thanks.

[Isomorphic]

Take a look at the QuickStart Guide, Server Framework chapter, specifically the various sections on SQL Templating.