Last post Dec 23, 2006 04:59 PM by Caddre
Dec 21, 2006 08:57 AM|thtang|LINK
string content = File.ReadAllText(SaveLocation);
Dec 21, 2006 10:11 PM|Caddre|LINK
You need to save the CVS file in note pad as Unicode and not ASCII and use the correct Chinese collation in the database and in 2005 use collation precedence in your query. The correct collations are in the link below, post again if you still have questions.
Hope this helps.
Dec 22, 2006 09:13 AM|thtang|LINK
Thank you for your answer.
It really waorks if i use notepad to make a csv file.
However, using notepad is really not convenience to the user. I would like to know how i can use excel to do this. It seems that Excel doesn't really care about the encodng.
Dec 22, 2006 01:36 PM|Caddre|LINK
Excel actually makes it easier just change your encoding code to the one I posted in the thread below. Hope this helps.
Dec 23, 2006 04:27 PM|thtang|LINK
Since I would like to import the CSV files to the gridview and database, I have prepared the CSV files through Excel. I would like to create the excel file using Microsoft Excel instead of exporting the data from gridview. Is there any way to set the encoding
Dec 23, 2006 04:59 PM|Caddre|LINK