| Author |
Message |
Claydson
Forum Member
Joined: 06 May 2009
Posts: 17
Location: Brazil
|
 Posted: Wed May 06, 2009 3:23 pm
Post subject: Search Dictionary doesn't work on oracle |
|
|
I have two test enviroments.
Enviroment 1 - With DQ and SQL Server 2005 as Metadata repository.
Enviroment 2 - With DQ and Oracle EE 10g as Metadata repositoy.
The Search Dictionary tool (Dictionary->Search...) used to look for Primary entries and add or edit them doesn't work on Enviroment 2. It work only on Enviroment 1. Why?????
Tks! |
|
| Back to top |
|
|
dawizard
Senior Member
Joined: 07 Mar 2009
Posts: 47
|
Posted: Thu May 07, 2009 12:04 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
| Oracle requires some codepage settings. You'll have to modify the NLS_LANG registry entry and check codepage on your Server (refer to the docs regarding CP requirements) |
|
| Back to top |
|
|
Claydson
Forum Member
Joined: 06 May 2009
Posts: 17
Location: Brazil
|
Posted: Thu May 07, 2009 10:43 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
| dawizard wrote: | | Oracle requires some codepage settings. You'll have to modify the NLS_LANG registry entry and check codepage on your Server (refer to the docs regarding CP requirements) |
I think this is my problem dawizard, but I didn't find any information about NLS_LANG in the DQ documentation that came within the product. Could anyone tell me where I can find a documentation about this problem?
Tks! |
|
| Back to top |
|
|
dawizard
Senior Member
Joined: 07 Mar 2009
Posts: 47
|
Posted: Fri May 08, 2009 9:48 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
Here you go:
set NLS_LANG entry in registry to AMERICAN_AMERICA.AL32UTF8
Use this on Oracle SQL Scratchpad to determine the codepage settings of the server:
Select * from nls_database_parameters WHERE PARAMETER = 'NLS_CHARACTERSET' OR PARAMETER = 'NLS_NCHAR_CHARACTERSET'
You should get back:
NLS_CHARACTERSET - AL32UTF8
NLS_NCHARSET - AL16UTF16 |
|
| Back to top |
|
|
Claydson
Forum Member
Joined: 06 May 2009
Posts: 17
Location: Brazil
|
Posted: Fri May 08, 2009 11:34 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
| dawizard wrote: | Here you go:
set NLS_LANG entry in registry to AMERICAN_AMERICA.AL32UTF8
Use this on Oracle SQL Scratchpad to determine the codepage settings of the server:
Select * from nls_database_parameters WHERE PARAMETER = 'NLS_CHARACTERSET' OR PARAMETER = 'NLS_NCHAR_CHARACTERSET'
You should get back:
NLS_CHARACTERSET - AL32UTF8
NLS_NCHARSET - AL16UTF16 |
I set the NLS_LANG in registry to AMERICAN_AMERICA.AL32UTF8
But this select is still returning this:
NLS_CHARACTERSET
WE8MSWIN1252
NLS_NCHAR_CHARACTERSET
AL16UTF16
How can I change the NLS_CHARACTERSET of oracle database from WE8MSWIN1252 to AL32UTF8? |
|
| Back to top |
|
|
Claydson
Forum Member
Joined: 06 May 2009
Posts: 17
Location: Brazil
|
Posted: Fri May 08, 2009 2:20 pm
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
| Claydson wrote: | | dawizard wrote: | Here you go:
set NLS_LANG entry in registry to AMERICAN_AMERICA.AL32UTF8
Use this on Oracle SQL Scratchpad to determine the codepage settings of the server:
Select * from nls_database_parameters WHERE PARAMETER = 'NLS_CHARACTERSET' OR PARAMETER = 'NLS_NCHAR_CHARACTERSET'
You should get back:
NLS_CHARACTERSET - AL32UTF8
NLS_NCHARSET - AL16UTF16 |
I set the NLS_LANG in registry to AMERICAN_AMERICA.AL32UTF8
But this select is still returning this:
NLS_CHARACTERSET
WE8MSWIN1252
NLS_NCHAR_CHARACTERSET
AL16UTF16
How can I change the NLS_CHARACTERSET of oracle database from WE8MSWIN1252 to AL32UTF8? |
Thanks dawizard!
The search dictionary is now working nice. I create a new oracle database with AL32UTF8 charset. |
|
| Back to top |
|
|
wdaehn
Forum Groupie
Joined: 17 Dec 2004
 *6
Posts: 7627
Location: Germany
|
Posted: Sat May 09, 2009 8:02 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
Why do we need that characterset? Why are those columns where Unicode is required varchars and not nvarchars?
_________________
Werner Daehn
Product Manager Data Integrator
SAP Business Objects
PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here. |
|
| Back to top |
|
|
Claydson
Forum Member
Joined: 06 May 2009
Posts: 17
Location: Brazil
|
Posted: Mon May 11, 2009 8:26 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
| wdaehn wrote: | | Why do we need that characterset? Why are those columns where Unicode is required varchars and not nvarchars? |
I don't know why do we need that characterset wdaehn. I working on 11.7.0.0 version, I don't know if in newer versions this charset are not needed. I only know that without AL32UTF8 charset configured on oracle 10g database the dictionary search primary entry doesn't work. |
|
| Back to top |
|
|
dawizard
Senior Member
Joined: 07 Mar 2009
Posts: 47
|
Posted: Tue May 12, 2009 8:46 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
| wdaehn wrote: | | Why do we need that characterset? Why are those columns where Unicode is required varchars and not nvarchars? |
I believe the dictionary contents are encrypted in the DB (could be a reason this specific codepage was required and varchar is used?). |
|
| Back to top |
|
|
Claydson
Forum Member
Joined: 06 May 2009
Posts: 17
Location: Brazil
|
Posted: Tue May 12, 2009 9:53 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
| I think you can be right dawizard. There is a table in the metadata repository called "DC_<LG>_PRIMARYENTRY". In this table we can see a field called "ENTRY". This field is a nvarchar (used to store unicode data which is used to store multilingual data in the database tables) and its content is unreadable. It's can be some kind of encrypt. |
|
| Back to top |
|
|
kingbudz
Forum Member
Joined: 06 Aug 2009
Posts: 1
|
Posted: Thu Aug 06, 2009 10:07 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
using the Oracle could be a great idea..
________________
Where |
|
| Back to top |
|
|
Torkuato38
Forum Member
Joined: 19 Sep 2009
Posts: 1
|
Posted: Sat Sep 19, 2009 1:15 pm
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
Is the Oracle you discuss here is the Oracle Database 10g is the first database designed for grid computing, the most flexible and cost-effective way to manage enterprise information? Well, It cuts costs of management while providing the highest possible quality of service. When you add providing numerous quality and performance enhancements, this Oracle Database 10g significantly reduces the costs of managing the IT environment, with a simplified install, greatly reduced configuration and management requirements, and automatic performance diagnosis and SQL tuning. 
________________
Freelance writing |
|
| Back to top |
|
|
wdaehn
Forum Groupie
Joined: 17 Dec 2004
*6
Posts: 7627
Location: Germany
|
Posted: Sun Sep 20, 2009 10:31 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
And the point is.....???
_________________
Werner Daehn
Product Manager Data Integrator
SAP Business Objects
PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here. |
|
| Back to top |
|
|
sunair
Forum Member
Joined: 24 Jan 2010
Posts: 1
|
Posted: Sun Jan 24, 2010 6:43 am
Post subject: Re: Search Dictionary doesn't work on oracle |
|
|
Check if environment 1 has a bridge to #2.
_________________
For outdoor home office: Sunair Awnings Guide |
|
| Back to top |
|
|
|
