Problems with strings in the CSV file

Question

I have an application that reads information from a CSV file to write it to the database. But some characters (example: º ç) are appearing problems Gravalos base. Anyone know how to fix this problem? Thank you.

I'm using these lines of code to read the information from the CSV file:

string directory = @"C:\test.csv";
StreamReader stream = new StreamReader(directory);
string line = "";
line = stream.ReadLine();
string[] column = line.Split(';');

There is a csv parser in .NET. link I suggest you use it instead of trying to roll your own — ManyRootsofAllEvil
– ManyRootsofAllEvil, Commented Mar 20, 2014 at 20:19

Kevin · Accepted Answer · 2014-03-20 20:44:35Z

2

StreamReader defaults to UTF8 encoding and your file is in a different encoding. Try specifying it like this...

    var encoding = Encoding.UTF16;
    StreamReader stream = new StreamReader(directory, encoding);

Note that you need to know what encoding the file is in to properly read it... I'm just guessing that it might be UTF16 but obviously I can't know what it is.

edited Mar 20, 2014 at 20:44

answered Mar 20, 2014 at 20:16

Kevin

4,63625 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zmbq · Accepted Answer · 2014-03-20 20:15:44Z

1

You should specify the right encoding when reading the file. The default is UTF-8. Your file is probably encoded with a different encoding.

answered Mar 20, 2014 at 20:15

zmbq

39.1k15 gold badges109 silver badges189 bronze badges

Comments

Markus · Accepted Answer · 2014-03-20 20:18:19Z

This is most likely related to the Encoding that is used when reading the file. By default, UTF8 is assumed as the Encoding. In order to read the file correctly, you need to specify the right encoding, e.g.:

string directory = @"C:\test.csv";
using(StreamReader stream = new StreamReader(directory, Encoding.ASCII))
{
    string line = "";
    line = stream.ReadLine();
    string[] column = line.Split(';');
}

You can try the following encodings (see this link for a complete list):

Encoding.Default for ANSI encoding based in the current windows code page.
Encoding.ASCII for ASCII encoding.
Encoding.UTF* for different Unicode encodings.

Please note that I enclosed the StreamReader in a using block so that it is disposed when it is not needed anymore.

Collectives™ on Stack Overflow

Problems with strings in the CSV file

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related