Questions with the special characters

Dear All,On my documentum application (documentum 6.5 sp1), I have noticed that when I copy the followingcharacters " " and - (that are different from "" and - ) from a Word document to an attributevalue in the application, these are changed in ¿ ¿ and ¿ AFTER the object is saved.Has anyone an idea how this problem could be solved?

I thought the problem was due to the DB settings, but they seem to be ok.In the content server dfc.properties I have the following entries:dfc.codepage=ISO_8859-1dfc.locale=enThe nls_database_parameters are:NLS_CHARACTERSET = AL32UTF8NLS_NCHAR_CHARACTERSET = UTF8NLS_LANGUAGE = AMERICANThanks in advance.

Find more posts tagged with

Comments

DavidHaveman

Do you have access to look at the raw values stored in the database? That would let you check for certain if the database is storing the characters correctly. Either the database can't handle the special characters, or Documentum isn't translating them right back to the characters needed.

bulbapeppe

In the DB the valus have the "¿" instead of the correct special characters.

When the characters are copied into the Attribute they are ok, then AFTER I SAVE, the characters into the DB are saved as the "¿".

Any idea?

DavidHaveman

I'm not a database expert, but it looks like the backing character set for your database doesn't accept those characters. I would google for your specific database about how to change the character set if you have the ability/access to do so. Documentum is configured to handle these fields, but when they are saved, they are getting changed.

Another very simple test to confirm this is indeed the case would be to temporarily create a simple table on your database server ( hopefully in a DEV or TEST environment ) and try to manually add the special characters with a SQL insert statement, if they don't get stored properly, it is the databases fault. If they do actually get stored correctly then there must be a Documentum setting that needs to be altered.

Good Luck,

bulbapeppe

Hi,

sorry, but further analysis showed that the problem was a little bit different from the one described.

Indeed, if I create a document and I fill the title with the special characters, these oens are correctly saved and displayed. Therefore the problem doesn't seem to be due to the DB.

The problem (i.e the characters are saved as "¿" ) occurs when the document (a placeholder) is created through a sort of workflow.

I hope now I have been more clear.

You said:"If they do actually get stored correctly then there must be a Documentum setting that needs to be altered".Can you please tell me how to do this?

Many thanks

DavidHaveman

I meant if the values through your raw SQL call we're stored correctly as the special characters and not as ?, then it is working, but it appears that the Database is not your issue. Sounds like the database and documentum are supporting these characters, which is a good thing.

Were all of the activities in the workflow built using an EMC tool such as process builder, or were they custom activities?