cancel
Showing results for 
Search instead for 
Did you mean: 

Import csv with æ ø å

VilladsClaes
Node Clone

To import a csv I used:

//Import csv
LOAD CSV FROM 'file:///spm.csv' AS line FIELDTERMINATOR ';'
CREATE 
(:RED{ name: line[0], creationTime:timestamp()})

But since I am unlucky and live in a country with these letters: æ,ø,å (utf-8) I have not been able to import text correctly - see picture.

3X_e_b_ebf4f57eed8573f41a8c7f5ac81d0f095d64955f.png

So how do I import a CSV and the scandinavian letters into the database?

3 REPLIES 3

Cobra
Ninja
Ninja

Hello @VilladsClaes

Can you check if the strings have the correct format in the CSV file?

Regards,
Cobra

clem
Graph Steward

E.g., try using an UTF-8 checker like: Validate UTF8 - Online UTF8 Tools

Or see: validation - How to check whether a file is valid UTF-8? - Stack Overflow

You might have to convert whatever format you have to UTF-8.

The question mark often means that the code displaying the characters found something unexpected (e.g. violates UTF-8 format), so it gave up and put in diamond ?

Thank you for the link to the UTF-8 checker tool.
The CSV passed the test

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.