confused about NLS_CHARACTERSET
I have two different database: one is running on WE8ISO.... and one is running on UTF8. What I am trying to do is to have the database which is compatitable for Russian language. Any way, when I insert Russian language into WE8ISO and when I do a query on the length of the data I just insert I got the the proper lenght and that's the way it suppose to be. When I insert the databa into UTF8 database and do the LENGTH on these records, to me it had about 28 characters and on the LENGTH it's said only 14 which is incorrect.
I thought for Russian language, UTF8 would be the answer for this but it's not the case.
Anyone has any thoughts????