I have migrated couple of schemas from UTF-8 charset DB to WE charset DB in Dev instance and it has been identified that lot of chars have become "¿" after data copy into target schemas.
I would like to know if there is a way to get those chars converted to WE charset while loading into the target database. I am aware that imp command should do this activity by default as we are migrating from superset to subset but not sure if it has really done that.
Do you think it is useful to explicitly specify charset while importing and will that solve the problem?
What is the best way to deal with this. Unfortunately I must migrate the schemas from UTF-8 to WE charset.
Many Thanks fpr your help.