SQL collate, can i not have multiple collates on a column?

Question

Using Microsoft SQL Server Management Studio. I am having an issue with inserting some characters into a database.

I read that you have to add a collate to the column to allow for some characters.

I need some characters from the Czech language. so I added the Czech collate (Czech_100_CI_AS) to the column but then some French characters were removed and can not be entered.

Can I not have multiple collates on a column? this seems would be a weird limitation

I tried this, with a "," but this gives an error on the comma

ALTER TABLE dbo.TestingNames 
ALTER COLUMN NameTesting VARCHAR(50) COLLATE Czech_100_CI_AS|, French_CS_AS

Edit: Ah I misunderstood what collate was meant to do, I didn't realize it was a codepage, i thought it was just an include.

Thanks, Changing it to Nvarchar seemed to have worked :) I actually thought I was using nvarchar /facepalm Thank you for pointing that out to me.