Stop using VARCHAR, and use NVARCHAR instead.
VARCHAR is basically 8 bit ASCII text, NVARCHAR is 16 bit Unicode:
DECLARE @Query1 NVARCHAR(MAX)
SET @Query1 = N'SELECT PersonName AS ''નામ'', DateOfBirth AS ''જન્મ તારીખ'' FROM Person'
And you don't need a WHERE clause if the condition is always true ...