Page Comparison

...

Stop TermWeb.
Backup database before update.

Replace old values containing new separator with something else, for example new separator is ; and replacement will be . :

Code Block

language	sql

UPDATE tw_value v 
SET 
    v.value_unicode = REPLACE(v.value_unicode, ';', '.'),
    v.value_normalized = REPLACE(v.value_normalized, ';', '.')
WHERE
    v.field_oid IN (SELECT 
            f.oid
        FROM
            `tw_field` f
        WHERE
            f.cat_id = 'GMULTIVAL');
            
UPDATE tw_picklistitem li 
SET 
    li.name = REPLACE(li.name, ';', '.')
WHERE
    li.field_oid IN (SELECT 
            f.oid
        FROM
            `tw_field` f
        WHERE
            f.cat_id = 'GMULTIVAL');

Replace old separator , with new . ; :

Code Block

language	sql

UPDATE tw_value v 
SET 
    v.value_unicode = REPLACE(v.value_unicode, ',', ';'),
    v.value_normalized = REPLACE(v.value_normalized, ',', ';')
WHERE
    v.field_oid IN (SELECT 
            f.oid
        FROM
            `tw_field` f
        WHERE
            f.cat_id = 'GMULTIVAL');

Edit file termweb.properties in termweb home folder and add or edit property multivalued.separator
Code Block
multivalued.separator=;
Start TermWeb and test results

...

Versions Compared

Old Version 2

New Version 3

Key