• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Data exported from CSV flat file to SQL Server mis-encodes diacritical marks?

Participant ,
Feb 04, 2023 Feb 04, 2023

Copy link to clipboard

Copied

Hello

I need to keep the accent marks in the SQL Server database.

My imported data (4000 + records) from a CSV in Excel contains hundreds of French diacriticals:

  • é –  (l'accent aigu)
  • à/è/ì/ò/ù – (l'accent grave)
  • â/ê/î/ô/û –  (l'accent circonflexe)
  • ç – (la cédille)
  • ë/ï/ü –  (l'accent tréma)

Each instance in the strings have changed to ? diamonds no matter what they were supposed to be. Is there a way to repair them after they have been imported or do I need to do this in the CSV file before the import, if possible?  What character encoding will SQL Server keep?

Thanks for any help with this.

Views

92

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Participant , Feb 04, 2023 Feb 04, 2023

I will change the character encoding to UTF-8 when saving xlsx to CSV I think I solved the issue-

Thanks for looking.

Votes

Translate

Translate
Participant ,
Feb 04, 2023 Feb 04, 2023

Copy link to clipboard

Copied

I will change the character encoding to UTF-8 when saving xlsx to CSV I think I solved the issue-

Thanks for looking.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 08, 2023 Feb 08, 2023

Copy link to clipboard

Copied

LATEST

UTF-8, that's the one! 🙂

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation