E-SQR: Unicode SQL Being Generated For SQR In Non-Unicode Environment
(Doc ID 2314306.1)
Last updated on NOVEMBER 14, 2024
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.55 and laterInformation in this document applies to any platform.
Symptoms
In SQL being generated for an SQR report, it was observed that it included nvarchar conversions, which would have been expected if the database was unicode, however this database was non-unicode.
Observed:
(@P1 nvarchar(7),@P2 nvarchar(4),@P3 nvarchar(23))...
Expected:
(@P1 varchar(7),@P2 varchar(4),@P3 varchar(23))...
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |