Enable UTF-8 in url_logger db

Hellos,

I am having writing characters such as ₹ to url_logger records , upon enquiring with chatgpt we found below. It's given me a command on how to change it myself as well , but I don't want to run into compatibility issue in future . Kindly advise 

Your database collation is SQL_Latin1_General_CP1_CI_AS, which does not support UTF-8. UTF-8 support requires a collation ending with _UTF8, such as Latin1_General_100_CI_AS_SC_UTF8.

I am advised below

To change the database collation to UTF-8, run:

ALTER DATABASE url_logger
COLLATE Latin1_General_100_CI_AS_SC_UTF8;
Change Column Collation to UTF-8:

To change the collation of specific columns to UTF-8, you can run:
ALTER TABLE event_log
ALTER COLUMN text_field_02 VARCHAR(255) COLLATE Latin1_General_100_CI_AS_SC_UTF8;

ALTER TABLE event_log
ALTER COLUMN text_field_03 VARCHAR(255) COLLATE Latin1_General_100_CI_AS_SC_UTF8;

Are you working with MS SQL Server?

A think all you need to do is to change field type to NVARCHAR 

Are you working with MS SQL Server?
Yes MSSQL 2019

Ideally text_field_01 are text and char_field_01 are varchar , both now ideally to be upgraded to nVARCHAR(MAX) 

admin wrote:

A think all you need to do is to change field type to NVARCHAR 

Should I upgrade or I wait for you to update it properly ?