CODEWITHSUNDEEP
utf-8coldfusioncoldfusion-9verity
Njna Grimsdottir
Njna Grimsdottir

Reputation: 71

How to create a cfcollection / verity collection with a UTF-8 character in the name?

I'd just like to be able to use a UTF-8 character in the name of the collection. We base our code logic on the names of the collections which are related to a given company. This new company has an abbreviation of XØZ3, and both the CFAdminstrator and cfcollection seem to have issues with using the ø in the collection name.

The errors presented are:

Unable to create collection peoplexscvdocsXØZ3.
Unable to create collection peoplexscvdocsxøz3.
An error occurred while creating the collection: com.verity.api.administration.ConfigurationException: Fail to create the index. (-6220)

Upvotes: 0

Views: 146

Answers (1)

Jarede
Jarede

Reputation: 3488

If verity doesn't accept UTF-8 and there isn't a work around, I guess you'll have to

  • have 2 fields, one with ascii based version of the character, one with the html/xml version of the character
  • pass through the ascii version of the characters when searching the collection to match

so you'd have:

plaintext: XOZ3

XMLText: X&#216Z3;

And a function that takes Ø and changes it to O when searching verity on the plaintext field and return the matching XMLText field

Upvotes: 1

Related Questions