Accented characters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gsauns - 27 Sep 2007 00:21 GMT

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?

Reply to this Message

Samuel R. Neff - 27 Sep 2007 04:08 GMT

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.

>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
[quoted text clipped - 8 lines]
>I tried some UTF-8 tricks I found on the net, but to no avail. Can
>anyone point me in the right direction?

Reply to this Message

Accented characters

Free Magazines