Php code-to-code: import data from oracle to mysql. the data section in oracle displays Incorrectstringvalue: xE6xBBx9AxE5x8AxA8... forcolumnintroatrow1 during insertion. How can we implement effective encoding conversion? such iconv and mb_convert... all require character parameters. Mb_detect php transcoding
Import data from oracle to mysql. the data section in oracle shows the Incorrect string value: '\ xE6 \ xBB \ x9A \ xE5 \ x8A \ xa8... for column 'Intro' at row 1.
How can we implement effective encoding conversion? such iconv and mb_convert... all require character parameters. The mb_detect_encoding detection is also inaccurate. how can this problem be solved?
------ Solution --------------------
What type is intro? I think iconv is very useful.
------ Solution --------------------
Your data is UTF-8
What is your oracle code?
------ Solution --------------------
However, \ xE6 \ xBB \ x9A \ xE5 \ x8A \ xA8 is UTF-8 encoded.
ScrollTwo words
Have you set the character set for connecting to oracle?
------ Solution --------------------
The encoding of both your databases is UTF-8, so you do not need to read the data before encoding and conversion.
1. is the operation page UTF-8?
2, access the oracle database, the connection character set to be set to UTF-8
3. operate the MYSQL database.