special characters are not being exported in the data dump file
The following values are there in a source table "CGHS - HRT-Heidelberg’s Retinal Tomogram"
but when it gets exported as a mysql data dump it gets exported like this "CGHS - HRT-Heidelberg’s Retinal Tomogram" .
I need the same as source data to be imported into target database.
Source settings:
• DEFAULT_CHARACTER_SET_NAME = 'latin1'
• DEFAULT_COLLATION_NAME = 'latin1_swedish_ci'
Target settings:
utf8mb4
utf8mb4_0900_ai_ci
charset & collation details also have been changed to latin1 & latin1_swedish_ci same as source database in schema, tables & columns. But I don't see them exported as it is. I even used these scripts to export --default-character-set=latin1 --default-character-set=utf8mb4 but no luck. what else I need to do, in order to import the same "’" in target database as well?
Subject
Written By
Posted
special characters are not being exported in the data dump file
December 06, 2024 01:24AM
December 06, 2024 04:28PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.