I am setting data from node API to angular material datable and added a sort header to a specific column but the problem is sorting I mean when I perform a sort on a specific column it does not give the perfect result
e.g my data is as follows
No. column-1 column-2
- abcd ff sfsfk
- Adcd sd gfdfd
- Asdjf sdffg
- Bddf sdfsf
- bssfsd sfere
- amdfd sdfsf
- Bsdf sdfs
When I am performing a sort operation on column 1 then the result i am getting is as follows
No. column-1 column-2
- Adcd sd gfdfd
- Asdjf sdffg
- Bddf sdfsf
- Bsdf sdfs
- amdfd sdfsf
- abcd ff sfsfk
- bssfsd sfere
But I want exactly as follow (Case insensitive)
No. column-1 column-2
- abcd ff sfsfk
- Adcd sd gfdfd
- amdfd sdfsf
- Asdjf sdffg
- Bddf sdfsf
- Bsdf sdfs
- bssfsd sfere
Please let me know how to archive this result. Note: From API I am getting perfact result as I want but when I set that API data in an angular MUI table and when I sort it performs case-sensitive sorting so I want to perform case-insensitive sorting when the user performs sorting operation on a particular column