Bigquery use hash sha1 to convert nvarchar data

[bigquerylearner]

Hi,

In SQL Server, the value will be different when using HASHBYTES to compute hash of sha1 in differnet types between varchar and nvarchar. I try to use Bigquery to compute hash of sha1, but the compute result is only same when data type is varchar in SQL server. If I want to use bigquery to get the compute result same as nvarchar in SQL server, how to do this?