Database Administration (MOSC)

MOSC Banner

Wrong characterset

edited Oct 22, 2009 10:01AM in Database Administration (MOSC) 1 commentAnswered
I've a Form Web aplication in which the NLS_LANG is set ITALIAN_ITALY.WE8MSWIN1252 which writes data in a DB in which the NLS is set to AMERICAN_AMERICA.WE8ISO8859P1. Forms applications works well.

If i try to see data from a different tool (SqlPlus, Toad, SqlDeveloper) I see my data containing reversed question marks or other strange characters I don't see when I use Forms.
I tried setting registry to ITALIAN_ITALY.WE8MSWIN1252  on my client, I tried to set the win environment variable to ITALIAN_ITALY.WE8MSWIN1252 but nothing changed.
Data are contained in a CLOB.

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