Technology Stack - EBS (MOSC)

MOSC Banner

Is it possible to prevent non-ASCII characters from being entered into self-service fields?

edited Aug 6, 2018 4:13AM in Technology Stack - EBS (MOSC) 1 commentAnswered ✓

Hi.

I have an ERP 12.2.5 environment. During the original installation of the environment I selected "Character Set = US7ASCII", and as a result both the web tier and the database tier are using "Character Set = US7ASCII".

The system has operating fine for years, but I recently discovered that someone had pasted data from a formatted Word Document into one of the Web-based self-service fields, and this included some non-ASCII data.

The web tier converted the non-ASCII data into something like this ---> ���, and this was saved in the database.

Attempting to query this data from the database results in an error;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center