Oracle11g, a table of data, in the update, all Chinese characters into space, a Chinese a space, but the English letters and English accord with will be retained.
Such as: ABC, 123 Chinese characters Chinese characters will become: "123 ABC"

The second time the same update statement, and no problem
Have met the same problem?

CodePudding user response:

1, this is the only one, other tables do not have the same problem?
2, each session only the first execution has a problem, the second and third executed 345 times, all have no problem?

CodePudding user response:

Multiple tables, it is occasional the problem. We started so that is a question of procedure, has been positioning within reason.
Last week, a colleague from production library derivative according to the company's development libraries, are 11 g. with pl/SQL dev update statement execution, reproduce the problem
After found the problem, the second execute SQL, is normal, now can't recreate the problem again.

CodePudding user response:

refer to the second floor JXC response:

multiple tables, is accidental this problem. We started so that is a question of procedure, has been positioning within reason.
Last week, a colleague from production library derivative according to the company's development libraries, are 11 g. with pl/SQL dev update statement execution, reproduce the problem
After found the problem, the second execute SQL, is normal, now can't recreate the problem again.

1, query the database character set nls_database_parameters confirm
2, use the update when the client operating system under the NLS_LANG environment variable to confirm

CodePudding user response:

First failure and the second success? No other rule?

CodePudding user response:

The client and the server are SIMPLIFIED CHINESE_CHINA. ZHS16GBK character set is the same.
The probability of this problem is very low, and it can be difficult to recreate the problem, only appear problem, after the user feedback

CodePudding user response:

How to update?