0

In my iPhone app, I am importing CSV file into SQlite database using CHCSV parser.

My CSV file contains data in European Languages containing special characters like umlaut, etc.

Which encoding should I use?

Should it be UTF8StringEncoding or some other encoding scheme?

halfer
  • 19,824
  • 17
  • 99
  • 186
Parth Bhatt
  • 19,381
  • 28
  • 133
  • 216

1 Answers1

1

What encoding is the original file in? Because that's the encoding you should use. CSV doesn't define any specific encoding, so it really depends on how the file was created.

Lily Ballard
  • 182,031
  • 33
  • 381
  • 347
  • Ballard: Thanks for the input. Original encoding is UTF8. I tried importing CSV using UTF8 encoding scheme but the data is not imported from CSV in that case. What could be wrong? – Parth Bhatt Jan 17 '11 at 04:25
  • I really can't begin to try and debug a third-party software that I've never seen. If the file is loaded using the correct encoding, and if you can verify that the file data is actually being read by your program and looks correct, then I would assume it's an issue with CHCSV itself. – Lily Ballard Jan 17 '11 at 06:30
  • Nope Kevin CHCSV is fine. It was my mistake at one of the places I didnt put the encoding value and hence i was missing out on some data. Thanks for the input though. :) – Parth Bhatt Jan 22 '11 at 17:48