ExecuteSQL : Sort text fields with accent
Mac / win
An executeSQL statement on a text field (indexing french), the sort asc / desc didn't work properly due to accent.
ExecuteSQL ( "select CarAccent from test order by CarAccent asc "; " ; " ; "¶" )
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 "; " ; " ; "¶" )
ExecuteSQL ( "select Upper(CarAccent) from test order by Upper(CarAccent) asc "; " ; " ; "¶" ) didn't work :
SQL Functions like replace translate aren't implemanted
Thank you for your post.
I have sent your post to our Development and Testing departments for review. When I receive any feedback, I will let you know.