French language collation not working on Synapse Serverless SQL

I'm struggling to get french characters(é, ç, à, ô, etc...) to show up properly in Synapse Serverless SQL. When I created my database, I used the "French_CI_AS" collation. Below is a screenshot of what it looks like on my end.

What can I do to fix this?