Accented characters

[gsauns]

I have an ASP.NET app in which I import from a comma-delimited text
file, put all that data in a GridView, and then insert the records
into multiple related tables in my SQL Server database.

I got one text file which contains accented characters. When I bring
them into the GridView, the accented characters show up as boxes, the
universal unrecognized character. And since I am inserting into the DB
by iterating thru the rows of the GridView, those records do not get
inserted correctly.

I tried some UTF-8 tricks I found on the net, but to no avail. Can
anyone point me in the right direction?

 

[Samuel R. Neff]

How are you reading the csv file? Do you know at which point the
characters are getting mixed up.

If you're using oledb to read the csv file I would suggest this csv
reader instead--it's 100% .NET and may handle extended characters
better.

http://www.codeproject.com/cs/database/CsvReader.asp

HTH,

Sam