1 Reply Latest reply on Apr 8, 2014 10:49 AM by TSGal

    ExecuteSQL : Sort text fields with accent

    kvl_al

      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