TO_DATE: NLS_DATE_LANGUAGE=URDU does not parse values which work in Oracle

SELECT TO_DATE('15 اپریل 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=URDU') AS x FROM DUAL;

X

15-APR-24

MariaDB [test]> SELECT TO_DATE('15 اپریل 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=URDU') AS x FROM DUAL;

+------+

| x    |

+------+

| NULL |

+------+

1 row in set, 1 warning (0.001 sec)

MariaDB [test]> show warnings;

+---------+------+---------------------------------------------------------------------+

| Level   | Code | Message                                                             |

+---------+------+---------------------------------------------------------------------+

| Warning | 1411 | Incorrect datetime value: '15 اپریل 2024' for function to_date      |

+---------+------+---------------------------------------------------------------------+

1 row in set (0.000 sec)