hwo to use ASP to handle chinese characters output? I have try two ways.store the string in a text file(unicode file) . store the string in an access database
The first method got an error:
Active Server Pages error 'ASP 0239'
Cannot process file
UNICODE ASP files are not supported.
The second method output "???" on the browser.
How do I Pass chinese characters, charset GB2312 and BIG5, from Form to SQL using asp?
My field in SQL is already set to nvarchar.
I've built a simple asp website with sql 7.0 backend. There's
a form based screens to save info to the database. I'm having problems for
some of our Chinese customers - they are saving information in Chinese
characters and they are being translated into weird characters. For
example: Code:
I have the following URL that was HTML encoded in my web page:
<a HREF="transfer/rad0/﨨.jpg" TARGET="_blank">﨨.jpg</a>
I am attempting to download this file which is simply one chinese character followed by .jpg. For IE, Netscape, Safari I right click on this URL and attempt to download the file. If the name contains only ASCII characters it works. I also cannot cut and paste this URL directly into IE and retrieve my image either. What do I need to do to be able to use Chinese (unicode) characters in URL's?
Through javascript i am forming a dynamic sql based on some selection criteria entered by the user. If i am trying to have an alias with '&', then on executing this through an ADODB object , the statement fails and i get an error as "from keyword not found"
For ex: If i have a SQL as
select emp_name as "Emp&Mgr" from emp;
on executing this i get the above mentioned error.
But SQL's with other special characters do work.
For ex: select emp_name as "Emp,Mgr" from emp;
select emp_name as "Emp/Mgr" from emp;
select emp_name as "Emp*Mgr" from emp;
How do i solve this problem.
we have the following code :
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
</head>
<body>
<form name="frm" action="mailto:srivaths_balasubramanian@satyam.com" method="POST" enctype="text/plain">
<input name="name1" value="">
<input type=submit>
</form>
</body>
</html>
which is used to send mails.while we put some chinese characters inside the text box and then click on submit button in the mail,chinese characters are appearing as garbage.
could anyone please help to resolve this issue so that it doesnt come as garbage?
Can anyone explain why the expression "AscW(ChrW(38321))" is equal to -27215 ?
(38321 is the Unicode code for one of the Chinese traditional characters)
AscW is supposed to return a Long value, isn't it?
This also happens in VB6
When we send a mail using the code below,we do not get simplified chinese characters if they are present in the body but we get junk in the mail and we need to change the mails encoding to simplified chinese to see the Chinese characters.
'CDONTS object
set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.MailFormat = 0
objMail.SetLocaleIDs(65001)
objMail.From = sFromEmail
objMail.To = sToEmail
objMail.Subject = sSubject
objMail.Body = sMessage
objMail.Send
set objMail = Nothing
I had came across an error known as "Bad Request (Invalid URL)" when i was trying to input chinese characters into MS SQL database using my asp written page. For your info, I'm currently working on Windows Server 2003 and running IIS 6 on this server.
Hereby i enclosed my asp request method tat i'm using
<%
sCategory = request.querystring("txtCategory")
....
%>
the txtCategory textbox contains chinese characters, and after that I'll insert the sCategory string value into MS SQL database.
I have a 3 layer system, SQL Server 2000 database, COM+ dll's (VC++ 6) and
ASP frontend, this system has been in production for quite some time using
english, spanish and portuguese versions. Now I've been asked to test the
system to function with Simplified chinese. The development of the system
was outsourced and we don't have communication with the company (some sort
of legal problems i think).
Now, I've been reviewing the code and recompiled one of the core DLL's for
unicode support with no problems, I've tested the database (SQL Server 2000)
inserting Simplified Chinese characters and the DB supports it fine (the DB
fields are NVARCHAR), in the ASP frontend, the retrievel process (calling
the COM+ DLL functions) works fine displaying this data I inserted directly
in the DB.
I developed a site in English but need it to be viewed in chinese.
Is it possible if so how do i go about it.
I've tried various ways but i can't get it to work.
I've done the following but it yieled no results.
<body lang="zh-TW" xml:lang="zh-TW">
Is there anything else i can do....
I have this program we use at work that keeps track of everyones hours and its what they use to clock in and out.
the whole this is in .asp and theres alot of bugs and things that need to be fixed but we cannot get much support on it so I was thinking of going in and fixing those things myself. but the thing is they seem to be in chinese is there a way i can convert the pages to english?
some one cuts and pastes the chinese charcters.
they are saved in DB as
---- case1 : ----
& # 6 5 3 9 6 ; & # 6 5 4 2 7 ; & # 6 5 4 1 9 ;
----
i used the space above as it is converting the characters while posting..
but i noticed some few records which are saved as
-- case 2 --
ÓÀÀÖ´óµäÏ·ÎÄÈýÖÖУ
---
if values are stored as case1 then i have no problem.
but with the case2 .the chinese characters are shown good in few pages and at few pages they are shown as it like symbols.
when i cheked the its the same.what shd i do to see that in a html page these character codes display correctly?
I am having a probem with asp, xml, com while using chinese chars. The chinese letters come out of com fine and they are also fine when i use asp to write to a text file.
When i load the chinese chars into an xml dom they become invalid Chinese chars show as this æˆ'çš,,模æ?¿. but when i doa xsl translation then some of the chinese chars are displayed and some are shown as garbage chars. My ASP Page has the following headers
<%@Language=VBScript CodePage="65001"%>
<%
Response.CharSet = "UTF-8"
Response.ContentType = "text/html"
%>
My XSL has the following header <?xml version="1.0" encoding="UTF-8"?> ..
I'm currently having trouble with porting our classic ASP web app for Chinese users - in any web form, the Del key on a chinese keyboard clears all of the fields in the form, which is not ideal.
View Replies View RelatedI've got an english site designed that I need to translate into Chinese.
I've got the Chinese wording to work with but I can't figure out how to get it into my code.
I thought I could simply paste the chinese characters from a Word document into my html editor between <P> tags using the PMingLiU or SimSun font but it just enters like this:
公司简介: turns into ????:
I am writing an asp page which reads an access 2000 database. In the access database, there is data containing the simplied chinese characters. I used the following connection string to connect to the access database.
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & GetServerPath & "..myDB.mdb;Persist Security Info=False"
When I use "Response.write(rs.fields("theField"))", I cannot get the original string which I can see in the Access. In fact, I have tried to use charset=gb2312, charset=big5, charset=utf-8 to encode the string, but all fails. (I am using tradition chinese OS). Can anyone help me?
due to my 'Language for non-Unicode Setting' in Regional Settings,my ASP page keeps outputing the date format as Chinese Simplified characters when issuing say, <%=Now()%>. In addition, my client script also interpret it as Chinese characters, which I don't want it to behave this way.
However, I can't remove my 'Chinese (PRC)' settings in control panel as I need it for other Chinese version software. Does anyone knows how can I display the date in my ASP page in normal English? I did try out the META tag Content Type and put in several charset to try out, but seems like it doesn't work at all.
I have been add the vb script:
......codePage=65001%>
and html document add the followings
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
But I cannot correctly received the chinese data (request.querystring) from other asp page, which data are the user input from it.
I've got an english site designed that I need to translate into Chinese. I've got the Chinese wording to work with but I can't figure out how to get it into my code.
I thought I could simply paste the chinese characters from a Word document into my html editor between <P> tags using the PMingLiU or SimSun font but it just enters like this:
????: turns into ????:
I use asp to develop a web page to read an excel file containing Chinese Character then display it in the web page. Unfortunately, I cant display it!!! it will display (?????????). Code:
View Replies View RelatedI have an asp to display data in database, the data is in big5 encoding
(chinese characters)
I haven't specify the codepage in the asp and placed the file into 2 machine.
When I browse the file in NT machine the chinese characters can display
correctly, but doesn't for the page in my winxp machine. Both OS is english
version. Since the file is actually the same (by copy and paste), so any
setting in the OS or IIS level cause the problem?
I having problem in displaying chinese character with asp.net mobile control. what configuration or settings should i set in Pocket IE or PC IE in order to display correct code page??
View Replies View RelatedGot a chinese website (has both chinese character and english), got to code search function for it, search for keywords in the webpages (htm/asp)
search in english it works, no problem
search in chinese it doesn't - it always return "nothing found"
you guys any idea?
I have a simple ASP form in which I am reading and showing the data from SQL Server database. This database has a nVarchar field, which stores some data in Chinese language. When reading and printing the data using a SELECT query it shows ??? (Question Marks) instead of the Chinese data. I have checked using Query Analyzer that the data is correctly stored in Chinese only.
I have looked up for this problem and it looks like many have faced the same before. But the only solution which seems to be provided for this is using the FORMS 2.0 controls, because VB converts the Unicode to ASCII and that corrupts the data. But is there any other solution to this?
I am using Dreamweaver to write the ASP pages. Dreamweaver is capable of showing the Unicode data, but can’t do much if it gets corrupted data from the VB itself.
So Please any help will be highly appreciated.
That’s the sample code which I am using if it helps: .....
I am trying to create a popup page to print little cards to Avery labels. I can get the page to work out but it always prints the margins to far over so it doesn't fit in the cells. I was wondering if any one new any resources to give details on how to accomplish this or of another method?I have also tried creating a dynamic word doc but then the user could change the text values which wouldn't work.
View Replies View RelatedI have a page with multiple SSI to content that is managed by other people in the organization. However, occassionally, one of the content managers accidently deletes a file or messes it up, which throws an .ASP error for the whole page. This is not good. I need to display the page, even if some of the include links are broken.
I tried using:
Code:
<%
On Error resume Next
%>
I need to let one person view certain things without having this perons
login. This person is logged in to the microsoft network. How do I get
that info into a variable?
if i have a recordset which contains a variable call remarks(which can be of any value)
how to i store this in an array? wat is the synatx?
array=rs1.Fields("REMARKS").value ???????
the need it cos i need to count the specific number of character inside this REMARKS. meaning say i output char 1 to 100 at box 1... and char 101 to 200 at box 2.
i'm about to built a budget DB driven site for someone. access is the cheapest option for me, as my host charges for mysql, plus i aint used it before! [:I]
they anticipate around 250 visitors per day. would access on a dsn-less jet connection hold up? how many consecutive users would it handle before it fell over.. ?
I've tried inserting this code, but it doen't work. I guess it must be something to do with the byVal keyword used in the constructor for the function?
Code:
'Handle a Null date
If (strDate = "" ) Or (Len(strDate) < 1) Or (strDate = Null) Then
fncFmtDate = "N/A"
Exit Function
End If
I created a web site for a local government office to handle their procurement. When the city modifies a solicitation, all of the respondants need to be notified. Unfortunately, the city wants the email sent to each respondant to be individualized, so I can't just CC or BCC it to several hundred email addresses.
After about 200 emails, the server usually times out. The city is hosting with Verio and Verio won't change the timeout values since it's "virtually hosted". Is there a way to spawn a background task to send the emails? If not, what's the best method for batch send?
How do i handle a subtraction between 2 entries in a table? they each belong to 2 tables. my code is below. I wish to subtract ordereditems_quantity from product_stock but i have no idea how to do it in asp. pls advise.
sqlString="SELECT * FROM products, ordereditems "
sqlString = sqlString & "WHERE product_id=ordereditems_productID"
RS.OPEN sqlString
product_stock = RS( "product_stock" )
ordereditems_quantity = RS( "ordereditems_quantity" )