|
yaronbb -> Insert Into with hebrew (10/24/2007 8:29:51)
|
Hi,
When I try to insert into the db true post form with Hebrew language, the first time will insert in Hebrew the other gibrish.
When I try true the form DRW it is working good. And I try in Israel servers and it is working but on usa server I get some record in gibrish and some in Hebrew.
I asked the sys admin in my hosting in usa and he said that he set the 1255 Charest to work.
This is my code any idle?
<html dir="rtl">
<%@Language=VBScript codepage=1255%>
<head>
<meta http-equiv="Content-Language" content="he">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1255">
<title></title>
</head>
<body>
<% If Request("NName") = "" Then Response.redirect "AddPersonal.asp?Error=1&NName="&Request("NName")&"&FName="&request("FName")&"&Day="&Request("BDay")&"&Month="&Request("BMonth")&"&Year="&Request("BYear")&"&Height="&Request("Height")&"&Weight="&Request("Weight")&"&User="&Request("User")&"&State="&Request("State")&"&Address="&Request("Address")&"&EMail="&Request("EMail")&"&Phone="&Request("Phone")&"&About="&Request("About") End If%>
<% SDate = Request("BDay") & "/" & Request("BMonth") & "/" & Request("BYear") %>
<% Gil = Year(Date()) - Year(SDate)%>
<!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>לרכיב תוצאות מסד נתונים בדף זה אין אפשרות להציג את תוכן מסד הנתונים. הדף חייב לכלול שם קובץ עם סיומת '.asp', והאתר צריך להתארח בשרת התומך ב- Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="Insert Into Costumer(NName, FName, DDate, Height, Weight, UserName, Pass, State, Address, EMail, Phone, BDate, About, Gil) Values ('::NName::', '::FName::', #"&Date()&"#, '::Height::', '::Weight::', '::User::', '::Pass::', '::State::', '::Address::', '::EMail::', '::Phone::', #"&DateFormat(SDate)&"#, '::About::', "&Gil&")"
fp_sDefault="NName=&FName=&Height=&Weight=&User=&Pass=&State=&Address=&EMail=&Phone="
fp_sNoRecords=""
fp_sDataConn="db"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<dl>
</dl>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</body></html>
|
|
|
|
