sorry, there is a typo in the sql-batch (copy&paste error): CREATE COLLATION public.case_insensitive (provider = icu, locale = 'und-u-ks-level2', deterministic = false); ALTER TABLE guacamole_entity ALTER COLUMN name TYPE varchar(128) COLLATE "case_insensitive";
Am 2025-05-06 13:59, schrieb Peter Kronfuss: > Hi there again! > > I may have found a workaround, but I am not sure if it has any side effects. > > I have changed the collation of the name column in the guacamole_entity table > to be case-insensitive, so that logging in with different usernames will > result in the same entry. > > Maybe someone can check this solution and give me some feedback. > > CREATE COLLATION public.case_insensitive (provider = icu, locale = > 'und-u-ks-level2', deterministic = false); > > ALTER TABLE guacamole_entity ALTER COLUMN name TYPE varying(128) COLLATE > "case_insensitive"; > > Regards, > Peter > > [...]
