OraFAQ Forum: Reports & Discoverer » Need to write French character

Home » Developer & Programmer » Reports & Discoverer » Need to write French character (Oracle Reports, 10G,Win 7 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to write French character [message #641365]

Thu, 13 August 2015 11:44

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Hi All
I'm trying to write one of the French character but no luck, any help will be highly appreciate. See attached for details.
Note:= I already try ALT+226 but no luck. Thanks

Attachment: ascii.JPG
(Size: 13.44KB, Downloaded 1689 times)

Report message to a moderator

Re: Need to write French character [message #641374 is a reply to message #641365]

Thu, 13 August 2015 15:54

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not very good at different character sets and national language settings, but: did you use font which allows you to write that character? Can you type it - using the same font - in MS Word, for example? Note that - as Reports 10g runs on an application server - server also has to have the same font installed.

Furthermore, do you want to write that character as a boilerplate object (so the above suggestion applies), or do you want to store it (and read) from the database (i.e. you want to insert strings using French characters into a column and then display it in Reports)? In the second case, your database must support French character set.

Check whether CHR function does any good in your case. Here's a SQL*Plus example:

SQL> select 'A' || chr(226) || 'B' from dual;

'A'
---
AÔB

SQL>

If nothing of the above helps, PM Michel Cadot and ask him to review this topic. He is French, I'm sure he'll be able to help (much better than I can).

Report message to a moderator

Re: Need to write French character [message #641387 is a reply to message #641365]

Fri, 14 August 2015 01:08

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You must have:
1) A program which is able to display this character
2) a NLS_LANG set to a value that a) matches with your OS and b) supports this character.

Report message to a moderator

Re: Need to write French character [message #641484 is a reply to message #641387]

Sun, 16 August 2015 19:22

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Thanks for your replies, I solved this problem and used Alt+0212 and got the exact character but don't know why I cant see that code if I use Alt+226.
I tried to use boiler object to write this character. Thanks again for your replies...

Report message to a moderator

Previous Topic:	Numeric seperators in delimited output
Next Topic:	Delimiteddata ??????

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 16:43:14 CST 2025