I am having problems sending values from a simple FORM to a database.
All is written in ASP, and I am doing some validations before it is
actually saved in my database.
It worked for several years, but now it won't accept international
characters. This means that the Norwegian word for boat "BÅT" ends up
like "BT" since the "Å" isn't sent.
I have done several testings, and it actually looks like the error
occurs immidiately after I hit the submit-button.
Is there a way to change encoding of a message created with CDO.Message, or otherwise send international characters (unicode) in Textbody? The messages I get now show question signs instead of international characters.
I have a problem with special Slavic (CE) and German charaters. On the first ASP page I have a FORM (user data...address...) that is posted to other ASP page. Data is then collected with request.form(item), and then it is written into a DB. Well the problem is that special langauge specific charaters are tranformed into boxes or some other charaters. I tried the response write to see if it is a problem with the DB part, but it isn't. Anyway does anyone have a working solution, since I can't find any on the web. I experimentd with codepage and charset, but with no results. Also I tried to post the data to email script - there problem is there.
On first ASP page there is a FORM that user must fill - personal data & stuff, where users use special language related characters (like Č, š, Ž...). When I post the form results to another ASP page that collects the data with Request.form("field"), special characters usually (90%) disappear, change into boxes or some other characters. This page should then write the results to a DB or send it via email, but since the characters are not encoded properly I did not write the script yet.
I tried to set Codepage and charset, but it does not solve the problem.
I can't seem to find a solution on the web since I am not sure what to look for.
I hope somone can offer some advice. I have built a database accepting information through ASP from clients in UK, Germany France and Russia. I set the ASP codepage to 65001 and the charset to UTF-8 and thought this would be enough to present the information from the different sources correctly.
Russian and English are OK but German and French produse peculiar chars. Set the codepage to 1252 and Russian goes awry. Has anyone some pointers to setup a truly international CMS?
I need to filter the username entry in the field during the registration. If I'm not mistaken, usernames can't consist of special characters, only international alphabet characters (a-z,A-Z), digits(0-9) and underline allowed.
I tried with something like "._[a-z][A-Z][0-9]" but it doesn't work.
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
I have a login form in which i have logins for company as 'National City" But when i capture the login name to give it in my query on some other form as Request.Querystring(username) Its recognises it as National%20City... i dont want to chhange my login names and keep it as NationalCity as one full word.How can i tell ASP to recoginze this as a space in the query ?
I am using mySQL with ASP. I have a trouble with Turkish characters as I am tring to get and display data from mySQL database. However, I can see whole Turkish characters exactly when I use phpMyAdmin.I used the following tags on HTML but I couldn't achieve to display Turkish characters in any way.
mySQL database lang: latin5_turkish_ci <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9"> and
We have an application which uses surname and the date of birth to allow people to login. The SQL gives an error if the user's surname contains the character '
I have a partner sending me by post method to an asp page some text (xml string).
It arrives to my page encoded as follows %9a%2f%Purchaseorder%3....f
The < and > and spaces are replaced by nuùmbers and percentage sign I am using Request.BinaryRead(BytesTotal) and then doing response write and I am getting exactly the same string with the encoding How can tell my asp page to translate the encoded text to normal text?
How do I remove those special characters in a variable? I think there are a dozen special character and so I use a dozen replace object. Is there an object that call this in one call instead of a dozen?
I'm having a problem finding/using an escape character with this ASP/JScript application I'm creating. Basically I have text sometimes that has apostrophes or double quotations in them, but they won't be INSERTED unless I manually take them out.
Ex: INSERT INTO tbl1 (vendor,reason) VALUES (81,"This is only a test, but there is an apostrophe and it's only going to make things worse.")
That apostrophe in "it's" is kiling everything. I've used the replace method to change it to " ' ", but that STILL doesn't work. I can't find MS SQL's ESCAPE CHARACTER. I've tried several directions of the backslash, but no luck.
I am trying to only have a link show if there is a certin value in the DB. This is what I am trying:
<% if (rsWelcome.Fields.Item("access_level").Value) = "admin" then
response.Write("| - <a href="sps_main.asp">Sales Training Support </a>-")
end if %>
BUT... this is the error I get:
Expected ')'
/sta/topnav_test.asp, line 9 response.Write("| - <a href="sps_main.asp">Sales Training Support </a>-") How do I use quotes in a "response" and have the app server ignore them??
The application should have a way of alerting the user if it does not recognize a character used by the website and give the user the ability to make adjustments to the unrecognized characters. The system should then remember the characters that have been adjusted by the user.
how can I add "vbCrLf" after every 80th character of a string. Suppose there is a string containg 600 characters and I want to pass on the string value to some variable, adding "vbCrLf" code after every 80th character.
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?
ive got a string where i woulld like to remove the last character it probably seems simple 2 u but i cant work it out can anyone tell me how to remove it.
IF trim(request(location))="" AND trim(request(FileType))="" AND trim(request(DateMonth)) = "" AND trim(request(DateYear))="" THEN Response.Redirect plmsearch.asp?ac=error END IF
why is the "?" causing the invalid character? everything is coded correctly on the plmsearch.asp page.
I have a ASP/SQL 7 application that displays data from various SQL7 Views onto a ASP page.
A column of this data is displayed in ASP as hyperlinks and the relevent data is put into a URL query string - so that the linked page is based on this data ( a kind of "drill-down" effect) - Code:
I have some text that I recieve from a DB, (it can variable or A text field doesnt metter)No i need to recognize if this text is english or a hebrew.how can i do it?
I have an asp application running with the charset set to windows-1252.Recently, my customer complained about some unknown characters(rectangulars) appeared on the screen.
Later I found out from database that the unknown characters are supposed to be coma (,). I then tried to set the charset in all pages to UTF-8 but it did not solve the problem. I have a problem debuging since my testing machine does not have this problem.Is there a possibility that font selection such as sans-serif can cause this problem?
its there anyway via asp i can get around the 255 character limit for url strings.. its for use in a cms/eshot system. on a mailto: link i want to create a string of email address for the client and then send from there own inbox.
How can i delete the first letter of an asp string.I know i can add up the charactors of a string and then take away one from the ammount of charactors in a string,and then using the right syntax with the ammount of a charactors.
I have a site with a simple admin tool (cut and paste text into a form field etc)henever someone copies in text with quotation marks, dollar/pound signs and then submits it to the database, the text shown on the front end contains ? marks instead.I have read this may be due to special characters or something, is there anyway to stop this happening or filter it out as the admin is for general use by registered people.
