CREATE USER suncode WITH encrypted password 'haslo123';
CREATE DATABASE "PWFL";
GRANT ALL PRIVILEGES ON DATABASE "PWFL" TO suncode;

Uwaga: Baza musi być skonfigurowana jako CI_AI (case insensitive + accent insensitive)

Zapytanie do wyciągnięcia wspieranych przez bazę COLLATE : SELECT name FROM sys.fn_helpcollations() WHERE name LIKE '%Polish%';

Wartość COLLATE na bazie określa kodowanie znaków w kolumnie typu varchar.

Pożądane COLLATE do systemu PlusWorkflow:

USE [master]
GO
CREATE LOGIN suncode WITH PASSWORD = "haslo123";
GO
CREATE DATABASE [PWFL] COLLATE Polish_CI_AI;
GO
USE [PWFL]
GO
CREATE USER suncode FOR LOGIN suncode;
GO
EXEC sp_addrolemember  "db_owner", "suncode";

CREATE USER SUNCODE IDENTIFIED BY "haslo123";
GRANT CONNECT, RESOURCE TO SUNCODE;
GRANT UNLIMITED TABLESPACE TO SUNCODE;