PDA

View Full Version : Unicode support in CSV import


yfuser
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
02-14-2019, 03:50 PM
Please send or post the .csv file. Thanks.

yfuser
02-14-2019, 05:08 PM
Hi, I have sent the file to support email. Please check, thanks!

kinook
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 (https://code.visualstudio.com/):

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
02-14-2019, 08:22 PM
Thank you for the help! It's good news to me.