SQL loader import data, according to the interval of xx bytes into each column, the column OB_INFO is a column with the words, I looked at the successful introduction of row, column OB_INFO value is no problem, but there are many columns OB_INFO suggest this kind of mistake, beg bosses solutions (feel local segmentation in bytes is correct, but the server code in Chinese, so to change the coding of the server Settings???? )

CodePudding user response:

I look at the generated, bad file, belt is all wrong? Line, that is, the existence of the question, prompt multi-byte character errors,,, that how to solve

CodePudding user response:

Modify the client and server side code and set the environment variable utf-8 try

CodePudding user response:

refer to the second floor qq_28538637 response:

modify the client and server side code and set the environment variable utf-8 try

Found the problem, because in bytes segmentation, cut in the half of the Chinese characters, so the recognition would be a question mark, and, in fact half coding disorder, so read a import it will go wrong, and now write c + + programs, designed to handle errors generated file, processed guide go in again

CodePudding user response:

It is better to unify separator to shard data