How can I determine which character encoding is being used internally?
380441Sep 2 2004 — edited Sep 2 2004Dear list.
a) How can I find out what character encoding is being used inside of our datbase, using Enterprise manager. I have tried looking under database initalisation parameters, but could only find things like NLS_language settings etc. (please dont tell me this is determined by locale...!)
b) is their a way of viewing "real" data inside of oracle, guaranteeing correct display. I realise this is probably a flawed questions. e.g When I use SQLplus on my machine to view the data it shows differently from that of Enterprise Manager.
c) I want to change our database to use utf-8. what would be the best way to change this setting? Do I have to re-install, or can I change this in the init.ora file ?
I would appreciate any adivce.
regards,
Ben Bookey