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

------------------------------------------------------------
We're hiring! B-Line Medical is seeking .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.
On Wed, 26 Sep 2007 16:21:20 -0700, gsauns <gs****@gmail.comwrote:

>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?