SQL Order By and string fold

Post Reply
josmani
Posts: 53
Joined: Tue Jun 03, 2003 3:38 am

SQL Order By and string fold

Post by josmani »

I have table column with accented characters and when sorting by "order by" sql clause, they are placed at the bottom.

Is there a way to ignore diacritics at the SQL level? We are using Texis Commercial Version 6.01.1342629243 20120718 (i686-intel-winnt-64-32)

Thanks.
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

SQL Order By and string fold

Post by John »

Yes, you can set the stringcomparemode to ignore diacritics: http://www.thunderstone.com/site/vortex ... hmode.html


E.g. <apicp stringcomparemode "+ignorediacritics">

If there is an index on that field you should make sure the stringcomparemode is set before creating the index.
John Turnbull
Thunderstone Software
Post Reply