Enable UTF-8 in url_logger db

admin
Offline
Administrator
Deeds not Words

More

1 year 10 months ago #24524 by admin

Replied by admin on topic Enable UTF-8 in url_logger db

Please go ahead and upgrade

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

prashant
Topic Author
Offline
Platinum Member

More

1 year 10 months ago #24528 by prashant

Replied by prashant on topic Enable UTF-8 in url_logger db

Upgraded !!

ALTER DATABASE url_logger
COLLATE Latin1_General_100_CI_AS_SC_UTF8;

-- Alter varchar fields to nvarchar(max)
ALTER TABLE event_log
ALTER COLUMN char_field_01 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN char_field_02 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN char_field_03 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN char_field_04 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN char_field_05 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN char_field_06 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN char_field_07 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN char_field_08 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN char_field_09 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN char_field_10 NVARCHAR(MAX);

-- Alter text fields to nvarchar(max)
ALTER TABLE event_log
ALTER COLUMN text_field_01 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN text_field_02 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN text_field_03 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN text_field_04 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN text_field_05 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN text_field_06 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN text_field_07 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN text_field_08 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN text_field_09 NVARCHAR(MAX);

ALTER TABLE event_log
ALTER COLUMN text_field_10 NVARCHAR(MAX);

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

ETL Forum