If your column is defined as VarChar then the encoding will be WindowsANSI and you can use the method shared at https://forum.xojo.com/t/mssqlstringvalue-extension-method/68251.
If the column is defined as nVarChar then the encoding could be anything but most likely UTF8 - the n is for national.