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.
vBulletin® v3.8.11, Copyright ©2000-2024, vBulletin Solutions Inc.