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?

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 <(E-Mail Removed)> wrote:

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