Environment
Novell Vibe 3.4 with MySQL database
Novell Vibe 3.3 with MySQL database
Novell Vibe 3.3 with MySQL database
Situation
Scenario I:
User receives an error message stating 'The title Tëst already exists' when they try to add a workspace or folder with title "Tëst" and another workspace or folder already exists at the same level with a similar name such as "Test" (note the difference is the letter e and ë).
Scenario II:
User receives an error message stating 'This folder requires that all uploaded files have unique filenames. A file with this name already exists in entry: test.jpg' when they try to add a file with title "tëst.jpg" and another file already exists at the same level with a similar name such as "test.jpg" (note the difference is the letter e and ë). In this scenario, the folder's setting to enforce unique file names is turned ON.
User receives an error message stating 'The title Tëst already exists' when they try to add a workspace or folder with title "Tëst" and another workspace or folder already exists at the same level with a similar name such as "Test" (note the difference is the letter e and ë).
Scenario II:
User receives an error message stating 'This folder requires that all uploaded files have unique filenames. A file with this name already exists in entry: test.jpg' when they try to add a file with title "tëst.jpg" and another file already exists at the same level with a similar name such as "test.jpg" (note the difference is the letter e and ë). In this scenario, the folder's setting to enforce unique file names is turned ON.
Resolution
This is a known limitation in Novell Vibe when configured with MySQL database. As a workaround, change the name of the new workspace/folder/file and try again.
Cause
This is due to the default collation setting on various columns in the Vibe MySQL database which compares strings in an accent-insensitive way.
Status
Reported to EngineeringAdditional Information
Vibe installations setup with MS-SQL or Oracle databases do not face this problem.