Unable to add workspace, folder or file in Vibe if the name variation is due to an extended character

  • 7014541
  • 11-Feb-2014
  • 14-Feb-2014

Environment

Novell Vibe 3.4 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.

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 Engineering

Additional Information

Vibe installations setup with MS-SQL or Oracle databases do not face this problem.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.