I've fixed the problem by converting all the varchar in the stored procedure to nvarchar.