Home > database >  Read from the MSSQL database in 2008 transferred to MYSQL, when there are special characters to save
Read from the MSSQL database in 2008 transferred to MYSQL, when there are special characters to save

Time:10-08

Everybody is good, can you tell me a question, and read from the MSSQL database in 2008 transferred to MYSQL, when there are special characters to save failed, tips are as follows: SQLSTATE=S1000
[MySQL] [ODBC Driver 5.1] [mysqld - 5.5.48] Incorrect string value: '\ xFC \ xAD \ xBC \ xC3 \ xB4 \ xE5... 'for column' PDETAIL 'at row 1

No changes made to the database.

INSERT INTO fdcp_source.PATIENT ( clinic_organ_code, clinic_organ_name, patient_domain_id, patient_domain_name, patient_local_id, patient_organ_id, outpatient_no, inpatient_no, id_type, id_number, health_file_no, idcard, health_card_no, name, birth_date, age, age_unit, gender, gender_name, pub_card_division, patient_type, nationality_code, nationality_name, hometown_province, hometown_city, birth_province, birth_city, birth_country, nation, nation_name, marriage_code, marriage_name, education, education_name, occupation_code, occupation_name, phone_number, email, paprovince, pacity, pacounty, patown_ship, pastreet, pahouse_number, papost_code, pdetail, hrprovince, hrcity, hrcounty, hrtown_ship, hrstreet, hrhouse_number, hrpost_code, hdetail, unit_name, uaprovince, uacity, uacounty, uatown_ship, uastreet, uahouse_number, unit_post_code, udetail, unit_phone, contact_name, contact_relation_code, contact_relation_name, caprovince, cacity, cacounty, catown_ship, castreet, cahouse_number, ca_post_code, cdetail, contact_phone, death_date, create_date, update_date, idcard_farm, idcard_hos, revise_sign, ID ) VALUES ( ? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? Built) MYSQL table character encoding has been utf8, online search a similar solution, is to modify the character set for the utf8mb4, MYSQL version is Server 5.5, but changed or not, where do you have brother have treated types of questions, please give directions, thank you
  • Related