AL32UTF8

building semantic layer
1

I make a connection in BO with an oracle DB, through an oracle instance (thus no ODBC); when I test the connection I receive following error:

CS:Invalid native charset : AL32UTF8

Can someone please explain me what’s the problem? Any suggestions how I could fix this?

keizersoz (BOB member since 2005-12-14)

2

It’s unicode related - which version of Oracle are you using and what was used to create the database? You might have to change the connectivity settings in the BO dataAccess files.

http://www.oracle.com/technology/products/oracle8i/htdocs/faq_combined.htm#characterset6

MikeD :south_africa: (BOB member since 2002-06-18)

3

does anyone know if the cms is approved for a AL32UTF8 characterset. I know the docs require utf8, so it should be ok since its a superset.

Has anyone dealt with this?

Thanks.

maverick976 :us: (BOB member since 2004-07-06)

4

Apologies for dredging up an old post but thought this might be of interest.

I am using Oracle XE 10g for a demo system but got the same error when creating a webi doc. (The error is in the trace files rather than on screen, on screen is the processing dpCommands error).

Oracle XE isn’t a supported platform and this fix is not recommened for any production type system so only use if necessary.

To allow this charset edit the oracle.crs file (on linux) this is under [install]/enterprise115/linux_x86/dataAccess/RDBMS/connectionServer/oracle

at the end you should see,

;
; Unicode configuration
;
UTF8=UTF8

and after this last line add

AL32UTF8=UTF8

I don’t know if this will handle non western characters but so far it seems to work for my small demo system.

rgds

agulland :uk: (BOB member since 2004-03-17)

5

agulland 's sol work for me too, i can now display chinese characters, thx

another solution that work for me is just edit the registry of the oracle client,
by setting NLS_LANG = AMERICAN_AMERICA.UTF8

paulwsc (BOB member since 2009-05-05)

6

Hi All,
One my business user newly installed BO XI R2 client and tried develop Deski report, get the below error message.

“Connection or SQL Sentence error: (DA0005)
Exception: CS, Invalid native charset: AL32UTF8”

In customer machine Oracle client installed version 11.2.0

Please any one assist me to fix this issue.

Thanks,
Bharath

pnb11281 (BOB member since 2010-07-06)

7

Hi everyone,

I got the same problem in oracle 10g, when i wanted to refresh any report i got CS:Invalid native charset : AL32UTF8 error,
but i could solve this by ( regedit>>HKEY_LOCAL_MACHINE>>SOFTWARE>>ORACLE>>KEY>>NSLANG= AMERICAN_AMERICA.WE8MSWIN1252)

make NSLANG value = AMERICAN_AMERICA.WE8MSWIN1252 and the problem will be solved.

sajia (BOB member since 2011-10-10)