Unicode support in CSV import

yfuser · #1 02-13-2019, 11:53 AM

I have a CSV file that contains unicode characters. After I imported the CSV file, it display weird characters for those unicode characters. Haven't found a setting to correct this without changing my OS setting. Will be nice if it can be fixed. I can provide more details if needed. Thank you!

kinook · #2 02-14-2019, 03:50 PM

Please send or post the .csv file. Thanks.

yfuser · #3 02-14-2019, 05:08 PM

Hi, I have sent the file to support email. Please check, thanks!

kinook · #4 02-14-2019, 05:54 PM

You need to save the file in UTF-8 encoding with a BOM (byte order mark). One way to do this is using Visual Studio Code:

1) Open the .csv file
2) Choose command (Ctrl+Shift+P) Change File Encoding -> Reopen with Encoding -> UTF-8
3) Choose command Change File Encoding -> Save with Encoding -> UTF-8 with BOM

Then you can import into UR with the correct encoding.

yfuser · #5 02-14-2019, 08:22 PM

Thank you for the help! It's good news to me.