Home » Developer & Programmer » Reports & Discoverer » getting different laguage output in reports
getting different laguage output in reports [message #631417] Tue, 13 January 2015 23:52 Go to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi ,

Getting output in oracle reports, what are steps to do this?
1 Μαχκ Απενυε

29−θΥΛ−11


Thanks

Report message to a moderator

Re: getting different laguage output in reports [message #631425 is a reply to message #631417] Wed, 14 January 2015 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 

SQL> select to_char(sysdate,'fmDD Month YYYY','NLS_DATE_LANGUAGE=German') date1,
  2         to_char(sysdate,'DD-MON-YYYY','NLS_DATE_LANGUAGE=American') date2
  3  from dual;
DATE1             DATE2
----------------- -----------
14 Januar 2015    14-JAN-2015

Report message to a moderator

Re: getting different laguage output in reports [message #631428 is a reply to message #631425] Wed, 14 January 2015 01:12 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
In my Database 

  1  select PARAMETER,value  from nls_database_parameters
  2* where value='AMERICAN'
SQL> /

PARAMETER                      VALUE
------------------------------ -----------------
NLS_LANGUAGE                   AMERICAN
NLS_DATE_LANGUAGE              AMERICAN

Report message to a moderator

Re: getting different laguage output in reports [message #631429 is a reply to message #631428] Wed, 14 January 2015 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

And?

Report message to a moderator

Re: getting different laguage output in reports [message #631430 is a reply to message #631429] Wed, 14 January 2015 01:13 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
what and? sorry

Report message to a moderator

Re: getting different laguage output in reports [message #631436 is a reply to message #631430] Wed, 14 January 2015 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

What do you mean with your post?

Report message to a moderator

Re: getting different laguage output in reports [message #631440 is a reply to message #631436] Wed, 14 January 2015 01:49 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
What do you mean with your post?

Getting output in another languages ,i need in US Language ( American English)

Report message to a moderator

Re: getting different laguage output in reports [message #631441 is a reply to message #631440] Wed, 14 January 2015 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

What you post is completely meaningless.
You said:

mist598 wrote on Wed, 14 January 2015 06:52
Hi ,

Getting output in oracle reports, what are steps to do this?
1 Μαχκ Απενυε

29−θΥΛ−11


Thanks


and

Quote:
i need in US Language ( American English)


Do you need the first or the last thing?

Report message to a moderator

Re: getting different laguage output in reports [message #631444 is a reply to message #631441] Wed, 14 January 2015 01:56 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Oh sorry Michel.. Smile That is my mistake
Quote:
Do you need the first or the last thing?

Last thing that is i need the out put in US Language ( American English)

Report message to a moderator

Re: getting different laguage output in reports [message #631445 is a reply to message #631444] Wed, 14 January 2015 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

And my query told you how to do it: see date2.

Report message to a moderator

Re: getting different laguage output in reports [message #631447 is a reply to message #631445] Wed, 14 January 2015 02:03 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Gives me the same result
  1* select to_char(sysdate,'DD-MON-YYYY','NLS_DATE_LANGUAGE=American') date2 from dual
SQL> /

DATE2
--------------------
14-JAN-2015

Ok fine, but what about the characters? please see my post#1

Report message to a moderator

Re: getting different laguage output in reports [message #631454 is a reply to message #631447] Wed, 14 January 2015 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

What characters?
You have the date in American, this is what you asked, isn't it?

Report message to a moderator

Re: getting different laguage output in reports [message #631458 is a reply to message #631454] Wed, 14 January 2015 02:36 Go to previous message
cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you've got foreign language data in a varchar (or any other string type) column oracle can't translate it.

Report message to a moderator

Previous Topic: Unable to see 2nd and 3rd pages on the report
Next Topic: Integration Error ..invalid parameter list in oracle report 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 04 18:35:08 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.