|
-
Sep 5th, 2012, 09:34 PM
#1
Thread Starter
Member
[RESOLVED] How to handle foreign characters in write to database (e.g. é, ç, etc)
I am creating a database from an ASCII text file that contains French language characters such as "é" and "ç", which are represented in the ASCII file as bytes with decimals 130 and 135 respectively. I use a StreamReader to read a line into a String, but when I write the string to the database using an SQLCommand Insert (via code), all these characters are replaced by "?". How do I preserve the original? The relevant database field is of type varchar.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|