Caracter set problem between SM9.30 and Oracle (9790 Views)
Reply
Advisor
Wizz-bell
Posts: 25
Registered: ‎07-20-2011
Message 1 of 3 (9,790 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,

Please use plain text.
Advisor
moep233
Posts: 14
Registered: ‎10-31-2011
Message 2 of 3 (9,685 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.

Please use plain text.
HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 3 of 3 (9,683 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."
Please use plain text.
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