on 01-16-2008 2:23 PM
Hi@all,
I have set up MDM together with Oracle Database 64-bit, patchset and patches. Right, this all is running on
Windows Enterprise 2003 64-bit. Everything is ok so far but there is one thing that is strange to me:
The following special characters Ú, É, Ó, Í, Ö, Ä, Ü, Å, Õ, Û are diesplayed like U´, E´, O´, I´, O¨, A¨, U¨, A°, O~, U^ in
each field they appear in the Data Manager. I checked the character set of the database which was AL32UTF8 which should
be correct. But if I unarchive the same repository on MSSQL database I do not have this probloem!
So, what else could I do or adjust on the database in order to fix the special character problem?
Thanks in advance!
BR,
Erdal
Hi Herdal,
this solution regards MDM 5.5 SP5. Please, read the following installation Guide:
In par. 4.1.2 Oracle DBMS you read:
"If you are creating a database during a complete installation, you can accept the default. To createan Oracle database using the Oracle tools, select one of the following character sets:
National Character Set: UTF8 or UTF16
Character Set: Any can be used"
So you need to launch
select VALUE from NLS_DATABASE_PARAMETERS where
PARAMETER='NLS_CHARACTERSET'
must return UTF8, so it's different, you need to reinstall the Oracle DB spcifing that character set.
Hope this help you.
Regards,
Vito
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vito,
all settings in the database are actually correct. But the reason why the special character problem occured was probably the fact that we have created some new repository in a differen system environment loaded it there and transported that repository like this in our current environment without considering that it was already corrupted when unarchiving and loading it in new environment here.
So we updated the records in the with the correct ones (Import Manager) and now everything is fine!
Thanks a lot anyway!
BR,
Erdal
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.