Solved

character set for European accents

  • 11 October 2023
  • 2 replies
  • 74 views
M
Rank
Userlevel 2
Badge +10
  • MMcK
  • Hero (Customer)
  • 37 replies

Hi

I’m trying to migrate some European addresses which include accents, cedillas and other special characters, for example Île-de-France,  Lérida and straße.

I’m using a standalone migration job reading a CSV file (not the Excel add-in).  The characters are displayed correctly in the cs file when viewed in Excel.

I’ve tried using the WE8ISO8859P1 character set which I’ve previously used successfully for the degree symbol for temperatures, but the addresses don’t display correctly - Ãle-de-France.

Is there a character set which will handle all the main European special characters?

Many thanks,

Marion

icon

Best answer by MMcK 11 October 2023, 17:01

View original

2 replies

M
Rank
Userlevel 2
Badge +10

I’ve just found 

 which says I should use AL32UTF8, and this has worked.

Jens
Rank
Userlevel 4
Badge +8

Hi @MMcK 

when loading OnClient then please use UTF8. That means your csv-file must be saved as UTF8 file.

When using OnServer then you can choose the same character set in your migration job as your csv file is stored. But for OnServer you need access to a folder on the database server.

/Jens

Reply


Terms & ConditionsCookie settings