大家好，請問一個問題，從MSSQL 2008資料庫中讀取轉入MYSQL里，當有特殊字符保存時就失敗，提示如下： SQLSTATE = S1000
[MySQL][ODBC 5.1 Driver][mysqld-5.5.48]Incorrect string value: '\xFC\xAD\xBC\xC3\xB4\xE5...' for column 'PDETAIL' at row 1
No changes made to 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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) MYSQL建表時字符編碼已經是utf8， 在網上搜索類似的解決方法，是修改字符集為utf8mb4。MySQL 版本是Server 5.5 ，但改了一直還是不行，請問有哪里大哥有處理過型別的問題，請指點，謝謝
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/11651.html
標籤：DataWindow
上一篇：程式打開久了卡頓