With new and old two servers, character set in fact is the same as all is AMERICAN_AMERICA AL32UTF8
But it is not the same as NLS_NCHAR_CHARACTERSET, the old machine is AL16UTF16, new machine is AL32UTF8, just our system data table many are NVARCHAR types of fields, so the data from the old machine is all the code after the migration in the past, the new machine have also been used for a long time, could not heavy, it will encounter a stuck problem, both sides now have the data, and are not compatible with character set field,
Tried exp/imp, SQL, export/import CSV export/import, solve the problem of the garbled
With the copy paste finally want to try, it is directly from a list of copy data to another table, then found a strange question,
When I select * from table1; When the still is garbled, according to
But when I select * from table1 for update. When the display is normal, the code have no,
Repeatedly tried a few times is such, so also in different tools, this is really refresh my understanding of oracle, which can be solved
CodePudding user response:
National character set are generally AL16UTF16,,The situation is really tough
CodePudding user response:
Is ultimately by modifying the field type of table, force guide a success, but the drawback is the core of the upstream system required table field type has been changed, you also need to verify the influence of the new table to the upstream system one by the national character set affects only NCHAR, NVARCHAR, converted into a CHAR, VARCHAR after can eliminate noise problem,