Click here to Skip to main content
15,392,636 members
Articles / Web Development / ASP.NET
Posted 24 Mar 2004


57 bookmarked

Using Character Encoding in ASP.NET

Rate me:
Please Sign up or sign in to vote.
4.08/5 (19 votes)
15 Apr 20042 min read
Submit your data to the OS or database server which does not support the character set.


This sample shows how to put your text completely into the operation system or database which does not support the text's character set.


In web application development, frequently I have to connect each kind of old database and OS from customers such as SCO5.05 which does not support UTF-8, GB2312 and other character sets. So, how to completely store or take out my text data has became an important job.

Once on a project, I needed to put some Chinese words in UTF-8 into the system of SCO5.05 + Informix7.3. But when I check the database, found that all characters were changed into "->" (\0x7F) in fact. Many ways I tried, but ever could not solve this problem.


I found the answer later: this is the trouble of character encoding.

Open the file named web.config in the ASP.NET project. The value of requestEncoding attribute in globalization element is "utf-8". It means the requested texts were encoded as UTF-8 character set. Because SCO5.05 does not support UTF-8, therefore the requested texts where changed.

I got it. The texts should be encoded into the western language (iso8859-1) which SCO5.05 can distinguish from UTF-8 before saving, and converted back after loading.

Solution code

For example, to put the message "ÄãºÃPi(\u03a0)", means "Hello Pi(¦°)", into "memo" field of database, use the following code:

// message "Hello pi(¦°)" in Chinese
string unicodeStr = "ÄãºÃPi(\u03a0)";

OdbcConnection conn = new OdbcConnection();
System.Data.IDbCommand cmd = conn.CreateCommand();

conn.ConnectionString = "your connection string";
cmd.Connection = conn;

// Encoding here
cmd.CommandText = "INSERT INTO encoding VALUES ('" 
  + CEncoding.unicode_iso8859(unicodeStr) + "')";
cmd.Connection = conn;

I used the function unicode_iso8859() above. It can convert the texts from UTF-8 to ISO8859-1.

public static string unicode_iso8859(string src) {
  Encoding iso = Encoding.GetEncoding("iso8859-1");
  Encoding unicode = Encoding.UTF8;
  byte[] unicodeBytes = unicode.GetBytes(src);
  return iso.GetString(unicodeBytes);
public static string iso8859_unicode(string src) {
  Encoding iso = Encoding.GetEncoding("iso8859-1");
  Encoding unicode = Encoding.UTF8;
  byte[] isoBytes = iso.GetBytes(src);
  return unicode.GetString(isoBytes);

Select your database and take a look. Is that all the texts converted into ISO symbol which you do not recognized?

Then you can convert back reversely by using iso8859_unicode() function. Of course, you can convert back with other encodings as you want.

If you are using an adapter and binding a DataSet to a DataGrid, it is easy to encode the data with these two methods, too. But you will pay the cost of more time. Use it or not? It is under your own judgment. J

OdbcAdapter adapter = new OdbcAdapter(); 
DataSet1 ds = new DataSet1(); 
DataGrid grid = new DataGrid(); 
OdbcConnection conn = new OdbcConnection(); 

// conn, adapter, dataset and datagrid were initialized 
conn.ConnectionString = "your connection string"; 
adapter.Connection = conn;

string xml = ds.GetXml();

// encoding here
ds.ReadXml(new System.IO.StringReader(CEncoding.iso8859_unicode(xml)));


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

Samuel Chen
Team Leader
China China

Comments and Discussions

GeneralMy vote of 2 Pin
shankar.koppella7-Apr-10 0:08
Membershankar.koppella7-Apr-10 0:08 
Generalunicode_iso8859 method returns nulls for some Unicode chars, this works better Pin
maestroboomer31-Jan-08 14:29
Membermaestroboomer31-Jan-08 14:29 
AnswerRe: unicode_iso8859 method returns nulls for some Unicode chars, this works better Pin
Gokhan Mamaci11-May-09 4:54
professionalGokhan Mamaci11-May-09 4:54 
QuestionProblem in displaying devanagri characters stored in postgres database Pin
Simmi Kapoor3-Apr-07 19:13
MemberSimmi Kapoor3-Apr-07 19:13 
GeneralI need help Pin
realnaimi26-Aug-06 23:03
Memberrealnaimi26-Aug-06 23:03 
QuestionIs there other workaround other than using your approach? Pin
kpchan221-Jun-06 1:01
Memberkpchan221-Jun-06 1:01 
AnswerRe: Is there other workaround other than using your approach? Pin
Steven M Hunt27-Mar-07 6:26
MemberSteven M Hunt27-Mar-07 6:26 
QuestionChinese characters Pin
mrajanikrishna19-May-06 0:07
Membermrajanikrishna19-May-06 0:07 
QuestionRe: Chinese characters Pin
Samuel Chen19-May-06 21:12
MemberSamuel Chen19-May-06 21:12 
AnswerRe: Chinese characters Pin
mrajanikrishna19-May-06 22:12
Membermrajanikrishna19-May-06 22:12 
AnswerRe: Chinese characters Pin
Samuel Chen20-May-06 0:24
MemberSamuel Chen20-May-06 0:24 
GeneralRe: Chinese characters Pin
mrajanikrishna21-May-06 15:05
Membermrajanikrishna21-May-06 15:05 
GeneralThank you! Pin
quitchat5-Apr-06 6:57
Memberquitchat5-Apr-06 6:57 
Generalhelp Pin
viketo21-Mar-05 6:50
Memberviketo21-Mar-05 6:50 
GeneralRe: help Pin
Samuel Chen22-Mar-05 16:08
MemberSamuel Chen22-Mar-05 16:08 
GeneralRe: help Pin
Anonymous23-Mar-05 17:24
MemberAnonymous23-Mar-05 17:24 
GeneralRe: help Pin
Samuel Chen13-Apr-05 17:23
MemberSamuel Chen13-Apr-05 17:23 
QuestionISO 8859-6 Pin
Nisha G20-Mar-06 19:23
MemberNisha G20-Mar-06 19:23 
AnswerRe: ISO 8859-6 Pin
Samuel Chen22-Mar-06 19:11
MemberSamuel Chen22-Mar-06 19:11 
GeneralGreat stuff !!! Pin
Yovav23-Apr-04 10:09
MemberYovav23-Apr-04 10:09 
GeneralRe: Great stuff !!! Pin
Samuel Chen24-Apr-04 6:45
MemberSamuel Chen24-Apr-04 6:45 
GeneralRe: Great stuff !!! Pin
Yovav24-Apr-04 7:08
MemberYovav24-Apr-04 7:08 
GeneralRe: Great stuff !!! Pin
Samuel Chen24-Apr-04 8:26
MemberSamuel Chen24-Apr-04 8:26 
GeneralRe: Great stuff !!! Pin
Yovav24-Apr-04 9:32
MemberYovav24-Apr-04 9:32 
GeneralRe: Great stuff !!! Pin
Samuel Chen24-Apr-04 17:29
MemberSamuel Chen24-Apr-04 17:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.