W3C home > Mailing lists > Public > www-international@w3.org > January to March 2002

RE: Updating UTF-8 data into SQL Server 2000 using ASP.net

From: Mohammad Alimohammadi <mohammad@tisri.org>
Date: Sat, 23 Feb 2002 05:01:59 -0500
Message-ID: <191690-22002262310159510@tisri.org>
To: www-international@w3.org
Hi Dear Rajan

using the <% @ %> compiler directive block that can appear at the
beginning of any ASP file.in this case (UTF-8) you mus set :
     <%@ codepage=65001 %>
at the beginning of ASP file.
you can find a valueable source for list of Character Set Recognition
in :
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dht
ml/reference/charsets/charset4.asp


Sincerely Yours
Mohammad Alimohammadi
Head of IT Department
Tehran International Studies & 
Research Institute
www.tisri.org
e-mail: mohammad@tisri.org
phone: +98 21 874 6240
fax: +98 21 874 6225
Address: No.32 Mehmandust St. Sabunchi St.
15336-73911
Tehran-Iran 



---- Original Message ----
From: rajan@calsoftsys.com
To: www-international@w3.org, 
Subject: RE: Updating UTF-8 data into SQL Server 2000   using ASP.net
Date: Fri, 22 Feb 2002 18:36:58 +0900

>Hi All,
>
>I am trying to update a Japanese field to SQL Server 2000 database 
>from a
>web form to use it in other pages. However, when I type Japanese in 
>the
>field and submit the form, the data does not update properly. When 
>the form
>posts, I can see the Japanese text being submitted in the next page, 
>but not
>properly encoded to the database. I see ?????? in the database table 
>and
>also when I retrieve the data later.  It used to work fine when I 
>used OLEDB
>connection with ASP. But does not seem to get it work using 
>Sqlclient in
>ASP.net. However, I can retrieve the Japanese text if I manually 
>enter it in
>the SQL server tables.
>
>Some info on the environment:
>1. ASP.NET in Wndows 2000 Server
>2. Microsoft SQL 2000 Server running in Windows 2000 Server
>3. Using UTF-8 meta tag in ALL the pages.
>4. Saving all pages in UTF-8 format
>
>Could somebody please help me with this. Thanks in advance.
>
>Rajan
>
>
>
Received on Saturday, 23 February 2002 05:05:25 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Tuesday, 2 June 2009 19:16:58 GMT