AnsweredAssumed Answered

ExecuteSQL : Sort text fields with accent

Question asked by kvl_al on Apr 8, 2014
Latest reply on Apr 8, 2014 by TSGal

Summary

ExecuteSQL : Sort text fields with accent

Product

FileMaker Pro

Version

13.0v2

Operating system version

Mac / win

Description of the issue

An executeSQL statement on a text field (indexing french), the sort asc / desc didn't work properly due to accent.

Steps to reproduce the problem

ExecuteSQL ( "select CarAccent from test order by CarAccent asc "; " ; " ; "¶" )

Expected result

Pre
Président
Prototype

Actual result

Pre
Prototype
Président

Workaround

Made a calculate field who replace accent by no accent char but we have a lot of text field on our 130 tables :-)

ExecuteSQL ( "select CarAccent from test order by CarNoAccent asc "; " ; " ; "¶" )

Pre
Président
Prototype

ExecuteSQL ( "select Upper(CarAccent) from test order by Upper(CarAccent) asc "; " ; " ; "¶" ) didn't work :

PRE
PROTOTYPE
PRÉSIDENT

SQL Functions like replace translate aren't implemanted

Screen_Shot_2014-04-08_at_14.23.18.png

Outcomes