Caracter set problem between SM9.30 and Oracle (16739 Views)
Reply
Advisor
Wizz-bell
Posts: 25
Registered: ‎07-20-2011
Message 1 of 3 (16,739 Views)

Caracter set problem between SM9.30 and Oracle

[ Edited ]

Hi,

We have a problem with several truncated error.

We think it's due to caracter set but the caracter set seem ok.

 

Previously in SC, SC only supported ISO caracter set. We use few accents (à, è,é ,...) sometime, this caused few problem in SC. Those special caracter count as 2 char in SC but 1 char in Oracle causing a small mismatch. A small warning appeared. No big deal.

 

Those mismatch seem to still occur in SM and this should not be the case with a caracter set UTF-8 or 16.

 

In sm.ini, language is set to utf-8 but seem to ignore it (language:utf-8)

 

In SM log, I can see AL16UTF16 VS UTF16. I don't think there is a problem here.

 16514( 16659) 08/08/2013 10:28:13  RTE I Oracle server settings for language, territory and character set: AMERICAN_AMERICA.WE8ISO8859P1 (AL16UTF16)
 16514( 16659) 08/08/2013 10:28:13  RTE I OCI Client settings for language, territory and character set: AMERICAN_AMERICA.AL32UTF8 (UTF16)

 

And for the truncate error, the message become this in SM:

API=OCIStmtExecute [in sqociSelect], Statement=SELECT * FROM ocmom1 WHERE "NUMBERPRGN"=:Y (display,show.rio)
SQL code=1406 message=ORA-01406: fetched column value was truncated  (display,show.rio)
API=OCIStmtFetch [in sqociSelectSome], Statement=SELECT * FROM ocmom1 WHERE "NUMBERPRGN" IN (:Y,:Y,:Y,:Y)  (display,show.rio)
SQL code=1406 message=ORA-01406: fetched column value was truncated  (display,show.rio)
API=OCIStmtExecute [in sqociSelect], Statement=SELECT * FROM ocmom1 WHERE "NUMBERPRGN"=:Y (format.cque,calc.queries.2.select)
SQL code=1406 message=ORA-01406: fetched column value was truncated  (format.cque,calc.queries.2.select)
API=OCIStmtExecute [in sqociSelect], Statement=SELECT * FROM ocmom1 WHERE "NUMBERPRGN"=:Y (format.cque,calc.queries.2.select)
SQL code=1406 message=ORA-01406: fetched column value was truncated  (format.cque,calc.queries.2.select)

 

No way to figure out what record or which fields are wrong.

We also get those error on any VJ files linked... so it's become really hard to just debug or fix mismatch fields in the data.

 

Did someone have an idea how to fix this?

 

Thank you,

Advisor
moep233
Posts: 14
Registered: ‎10-31-2011
Message 2 of 3 (16,634 Views)

Re: Caracter set problem between SM9.30 and Oracle

were you ever able to get resolution to this?  i am seeing the same issue.  thanks.

HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 3 of 3 (16,632 Views)

Re: Caracter set problem between SM9.30 and Oracle

Hi

 

Can you post part of your log  that seeing the error in ?

 

Thank you

 

 

"HP Support
If you find that this post or any post resolves your issue, please make sure to mark it as an accepted solution."
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.