MySQL Forums
Forum List  »  Newbie

special characters are not being exported in the data dump file
Posted by: Ravishankar Rajagopalan
Date: December 06, 2024 01:24AM

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?

Options: ReplyQuote


Subject
Written By
Posted
special characters are not being exported in the data dump file
December 06, 2024 01:24AM


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.