[A-Legre]

Hi,

we have devlopped a report in pdf with report builder but some accentued french character did not display correctly.

the NLS_LANG of my database :
PARAMETER VALUE
--------------------------------------- ---------------------------
NLS_LANGUAGE FRENCH
NLS_TERRITORY FRANCE
NLS_CURRENCY €
NLS_ISO_CURRENCY FRANCE
NLS_NUMERIC_CHARACTERS ,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/RR
NLS_DATE_LANGUAGE FRENCH
NLS_CHARACTERSET UTF8
NLS_SORT FRENCH
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY €
NLS_NCHAR_CHARACTERSET UTF8
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE

the NLS_LANG variable of my system :
FRENCH_AMERICA.UTF8

I have try NLS_LANG=FRENCH_FRANCE.UTF8
but this dosen't work.

did you get any idea ?
Regards,
Antoine

[chrisplough]

Antoine,

First - I'd run the SQL query that the report utilizes manually and see if the DB is correctly returning the characters (it should). As long as that works, then the issue is with the Oracle Reports Server. In order for it to operate correctly, both your OS and Oracle Reports need to be setup correctly to interpret and display the extended characters. In past experience with customers in APAC - we found that this can be difficult if the Oracle Reports server is running on a platform other than Win32.

I'd recommend searching Metalink for known issues with Oracle Reports and extended character sets. I'd also appreciate any updates you can post to this thread, as you find more details.

--Chris

[sprabhakar]

Hi Antoine,
The character set for the report server is set in the startup script of the report server. Please set this to the same as your database characterset and you should be able to see french characters in the reports.

Regards

Prabhakar

[A-Legre]

I am on windows box so the report is start with a service

where did I need to search for this information