|
| |
|
|
yaronbb
Posts: 40
Joined: 10/5/2006
Status: offline
 |
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>
|
|
|
|
Tailslide
Posts: 5972
Joined: 5/10/2005
From: Out here on the raggedy edge
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 8:55:41
It's likely to be a mismatch of the charset somewhere down the line. The charset suggested should work for you but you'll need to check that it's the same:
1. on the web page itself
2. in the database (how the table is saved)
3. how the web hosts are actually serving the page which might be a different charset even if you specify what you want.
You can check what the web server is actually serving by looking in firefox using the web developer toolbar, Go to Information and then click on View Response Headers. At the bottom of the list of stuff will be the encoding.
If you can't do that then post the link here and we can check for you.
_____________________________
"My strategy is so simple an idiot could have devised it"
Little Blue Plane Web Design | Blood, Sweat & Rust - A Land Rover restoration project
| |
|
|
|
yaronbb
Posts: 40
Joined: 10/5/2006
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 9:26:13
Hi, thanks for replaying
I don’t have firefox and I will be glad if you can check it for me.
This is the link for the form that post the information to the insert page.
http://www.yaronb.net/scouter/AddPersonal.asp
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 10:01:11
It seems right near the bottom (in the HTML source) there is a extra <HTML> , <BODY> elements and charset is 1252
_____________________________
William Lee
| |
|
|
|
yaronbb
Posts: 40
Joined: 10/5/2006
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 10:07:06
Hi, thanks for helping me.
You are talking on the form page or the insert page?
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 10:08:32
The page that you showed.
This means the same error may be present in the other pages.
_____________________________
William Lee
| |
|
|
|
yaronbb
Posts: 40
Joined: 10/5/2006
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 10:12:23
Ok, I checked but did not find the Charest you told me, here is the hole code :
<html dir="rtl">
<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>
<!--#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="SELECT Error FROM Error Where ID = ::Error::"
fp_sDefault="Error=0"
fp_sNoRecords=""
fp_sDataConn="db"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="HEBName"
fp_sMenuValue="ID"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<% Error =FP_FieldHTML(fp_rs,"Error")%>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="790">
<tr>
<td width="788" style="border: 10px solid #FFFFFF">
<img border="0" src="images/5.jpg"></td>
</tr>
<tr>
<td width="788" bgcolor="#FFFFFF" style="border: 10px solid #FFFFFF">
<blockquote>
<p class="MsoNormal" dir="RTL">
<b><font face="Tahoma" size="2" color="#C00001">
<br>
<%=Error%></font></b></p>
<p class="MsoNormal" dir="RTL">
<font size="2">
<b>
<span lang="HE" style="font-family: Tahoma">۰• </span>
</b>
<span style="font-family: Tahoma" lang="he"><b>פרטים אישיים :</b><br>
</span></font><span style="font-family: Tahoma" lang="he">
<font style="font-size: 6pt">
* שדות חובה.</font></span></p>
<form method="GET" action="AddPart1.asp">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="80%">
<tr>
<td width="27%"><font face="Tahoma" size="2">*שם פרטי : </font>
</td>
<td width="39%">
<input type="text" AUTOCOMPLETE="OFF" name="NName" size="20" style="border:2px inset <% If Request("Error") = "1" Then %>#FF0000 <%End If %>; font-family: Tahoma; font-size: 10px; " dir="rtl" value="<%=Request("NName")%>"><span lang="en-us">
<% If Request("Error") = "1" Then %><img border="0" src="images/8.jpg" align="absmiddle"><% End If %></span></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"> </td>
<td width="39%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"><font face="Tahoma" size="2">*שם משפחה : </font>
</td>
<td width="39%">
<input type="text" AUTOCOMPLETE="OFF" name="FName" size="20" style="border:2px inset <% If Request("Error") = "2" Then %>#FF0000 <%End If %>; font-family: Tahoma; font-size: 10px; " dir="rtl" value="<%=Request("FName")%>"> <span lang="en-us"><% If Request("Error") = "2" Then %><img border="0" src="images/8.jpg" align="absmiddle"><% End If%></span></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"> </td>
<td width="39%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"><font face="Tahoma" size="2">*תאריך לידה :
</font></td>
<td width="39%">
<font size="2" color="#17375F"><span lang="en-us">
<select size="1" name="BYear" style="font-family: Tahoma; font-size: 10px">
<% If Request("Error") <> "" Then %><option><%=Request("Year")%></option><% End If %>
<option>1950</option>
<option>1951</option>
<option>1952</option>
<option>1953</option>
<option>1954</option>
<option>1955</option>
<option>1956</option>
<option>1957</option>
<option>1958</option>
<option>1959</option>
<option>1960</option>
<option>1961</option>
<option>1962</option>
<option>1963</option>
<option>1964</option>
<option>1965</option>
<option>1966</option>
<option>1967</option>
<option>1968</option>
<option>1969</option>
<option>1970</option>
<option>1971</option>
<option>1972</option>
<option>1973</option>
<option>1974</option>
<option>1975</option>
<option>1976</option>
<option>1977</option>
<option>1978</option>
<option>1979</option>
<option>1980</option>
<option>1981</option>
<option>1982</option>
<option>1983</option>
<option>1984</option>
<option>1985</option>
<option>1986</option>
<option>1987</option>
<option>1991</option>
<option>1992</option>
<option>1988</option>
<option>1989</option>
<option>1990</option>
<option>1991</option>
<option>1992</option>
<option>1993</option>
<option>1994</option>
<option>1995</option>
<option>1996</option>
<option>1997</option>
<option>1998</option>
<option>1999</option>
<option>2000</option>
<option>2001</option>
<option>2002</option>
<option>2003</option>
<option>2004</option>
<option>2005</option>
<option>2006</option>
<option>2007</option>
</select><select size="1" name="BMonth" style="font-family: Tahoma; font-size: 10px">
<% If Request("Error") <> "" Then %><option><%=Request("Month")%></option><% End If%>
<option value="1">ינואר(1)</option>
<option value="2">פברואר(2)</option>
<option value="3">מרץ(3)</option>
<option value="4">אפריל(4)</option>
<option value="5">מאי(5)</option>
<option value="6">יוני(6)</option>
<option value="7">יולי(7)</option>
<option value="8">אוגוסט(8)</option>
<option value="9">ספטמבר(9)</option>
<option value="10">אוקטובר(10)</option>
<option value="11">נובמבר(11)</option>
<option value="12">דצמבר(12)</option>
</select><select size="1" name="BDay" style="font-family: Tahoma; font-size: 10px">
<% If Request("Error") <> "" Then %><option><%=Request("Day")%></option> <% End If %>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select></span></font></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"> </td>
<td width="39%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"><font face="Tahoma" size="2">*גובהה : </font>
</td>
<td width="39%" dir="rtl">
<input type="text" AUTOCOMPLETE="OFF" name="Height" size="4" style="border:2px inset <% If Request("Error") = "3" Or Request("Error") = "4" Then %>#FF0000 <%End If %>; font-family: Tahoma; font-size: 10px; " dir="ltr" value="<%=Request("Height")%>"><font face="Tahoma" style="font-size: 9pt">:1 </font><span lang="en-us"><% If Request("Error") = "3" Or Request("Error") = "4" Then %><img border="0" src="images/8.jpg" align="absmiddle"><%End If%></span></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"> </td>
<td width="39%" dir="rtl"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"><font face="Tahoma" size="2">*משקל : </font>
</td>
<td width="39%" dir="rtl">
<input type="text" AUTOCOMPLETE="OFF" name="Weight" size="6" style="border:2px inset <% If Request("Error") = "5" Or Request("Error") = "6" Then %>#FF0000 <%End If %>; font-family: Tahoma; font-size: 10px; " dir="rtl" value="<%=Request("Weight")%>"><font face="Tahoma" style="font-size: 9pt">ק"ג </font><span lang="en-us"><% If Request("Error") = "5" Or Request("Error") = "6" Then %><img border="0" src="images/8.jpg" align="absmiddle"><% End If %></span></td>
<td width="34%"> </td>
</tr>
</table>
</center>
</div>
<p class="MsoNormal">
<b>
<font size="2">
<span lang="HE" style="font-family: Tahoma">۰• </span>
<span style="font-family: Tahoma">פרטי חשבון באתר</span><span style="font-family: Tahoma" lang="he">
:</span></font></b></p>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="80%">
<tr>
<td width="27%"><font face="Tahoma" size="2">*שם משתמש רצוי :
</font></td>
<td width="39%">
<input type="text" AUTOCOMPLETE="OFF" name="User" size="20" style="border:2px inset <% If Request("Error") = "7" Or Request("Error") = "8" Then %>#FF0000 <%End If %>; font-family: Tahoma; font-size: 10px; " dir="ltr" value="<%=Request("User")%>"> <span lang="en-us"><% If Request("Error") = "7" Or Request("Error") = "8" Then %><img border="0" src="images/8.jpg" align="absmiddle"><% End If %></span></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"> </td>
<td width="39%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"><font face="Tahoma" size="2">*סיסמה : </font>
</td>
<td width="39%">
<input type="password" AUTOCOMPLETE="OFF" name="Pass" size="20" style="border:2px inset <% If Request("Error") = "9" Or Request("Error") = "10" Then %>#FF0000 <%End If %>; font-family: Tahoma; font-size: 10px; " dir="ltr" value="<%=Request("Pass")%>"> <span lang="en-us"><% If Request("Error") = "9" Or Request("Error") = "10" Then %><img border="0" src="images/8.jpg" align="absmiddle"><% End If %></span></td>
<td width="34%"> </td>
</tr>
</table>
</center>
</div>
<p class="MsoNormal">
<b>
<font size="2">
<span lang="HE" style="font-family: Tahoma">۰• </span>
<span style="font-family: Tahoma">פרטי מיקום</span><span style="font-family: Tahoma" lang="he">
:</span></font></b></p>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="80%">
<tr>
<td width="27%"><font face="Tahoma" size="2">*מדינה : </font>
</td>
<td width="39%">
<nobr>
<!--#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="SELECT * FROM State ORDER BY HEBName ASC"
fp_sDefault=""
fp_sNoRecords=""
fp_sDataConn="db"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="HEBName"
fp_sMenuValue="ID"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<select NAME="State" SIZE="1" style="font-family: Tahoma; font-size: 10px">
<% If Request("Error") <> "" Then %><option><%=Request("State")%></option><% End If%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<option VALUE="<%=FP_FieldHTML(fp_rs,"Val")%>">
<%=FP_FieldHTML(fp_rs,"HEBName")%></option>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</select></nobr></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"> </td>
<td width="39%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"><font face="Tahoma" size="2">*כתובת : </font>
</td>
<td width="39%">
<input type="text" AUTOCOMPLETE="OFF" name="Address" size="40" style="border:2px inset <% If Request("Error") = "11" Then %>#FF0000 <%End If %>; font-family: Tahoma; font-size: 10px; " dir="rtl" value="<%=Request("Address")%>"> <span lang="en-us"><% If Request("Error") = "11" Then %><img border="0" src="images/8.jpg" align="absmiddle"><% End If %></span></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"> </td>
<td width="39%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"><font face="Tahoma" size="2">דואר אלקטרוני :
</font></td>
<td width="39%">
<input type="text" AUTOCOMPLETE="OFF" name="EMail" size="40" style="border:2px inset <% If Request("Error") = "12" Then %>#FF0000 <%End If %>; font-family: Tahoma; font-size: 10px; " dir="ltr" value="<%=Request("EMail")%>"> <span lang="en-us"><% If Request("Error") = "12" Then %><img border="0" src="images/8.jpg" align="absmiddle"><% End If %></span></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"> </td>
<td width="39%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="27%"><font face="Tahoma" size="2">*טלפון : </font>
</td>
<td width="39%">
<input type="text" AUTOCOMPLETE="OFF" name="Phone" size="20" style="border:2px inset <% If Request("Error") = "13" Then %>#FF0000 <%End If %>; font-family: Tahoma; font-size: 10px; " dir="rtl" value="<%=Request("Phone")%>"> <span lang="en-us"><% If Request("Error") = "13" Then %><img border="0" src="images/8.jpg" align="absmiddle"><% End If %></span></td>
<td width="34%"> </td>
</tr>
</table>
</center>
</div>
<p class="MsoNormal">
<b>
<font size="2">
<span lang="HE" style="font-family: Tahoma">۰• </span>
<span style="font-family: Tahoma">קצת על עצמך</span><span style="font-family: Tahoma" lang="he">
:</span></font></b></p>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="80%">
<tr>
<td width="25%"> </td>
<td width="68%">
<textarea rows="6" name="About" cols="72" style="font-family: Tahoma; font-size: 10px" dir="rtl"><%=Request("About")%></textarea></td>
</tr>
</table>
</center>
</div>
<p class="MsoNormal" align="left">
<Input type=image src="images/6.jpg" name="I6" alt="Send This Form"></p>
</form>
</blockquote>
</td>
</tr>
<tr>
<td width="788" style="border: 10px solid #FFFFFF">
<p align="left"> </td>
</tr>
</table>
</center>
</div>
</body>
</html>
| |
|
|
|
yaronbb
Posts: 40
Joined: 10/5/2006
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 10:18:48
I found some include page that was in 1252 can you check it now because it steel in gibrish
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 10:18:57
quote:
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
:
:
</body>
</html></td>
<td width="20" style="background-image: url('images/1.jpg'); background-repeat: repeat-y; background-position: center"> </td>
:
</body>
</html>
This is not normal.
< Message edited by William Lee -- 10/24/2007 11:43:20 >
_____________________________
William Lee
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 10:21:05
quote:
ORIGINAL: yaronbb
I found some include page that was in 1252 can you check it now because it steel in gibrish
No wonder!! If you are using asp include, remove the <html> and <body> elements inside the include file otherwise they will repeat like what I showed you.
_____________________________
William Lee
| |
|
|
|
Tailslide
Posts: 5972
Joined: 5/10/2005
From: Out here on the raggedy edge
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 10:23:14
On the live page you've got a bit of duplication which may or may not be causing a problem but should be dealt with -
You've got:
<html dir="rtl">
<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 bgcolor="#E9E9E9" topmargin="0" leftmargin="0">
<div align="center">
<center>
<table border="0" cellspacing="0" width="790" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0">
<tr>
<td width="20" style="background-image: url('images/1.1.jpg'); background-repeat: repeat-y; background-position: center"> </td>
<td width="750" align="justify" bgcolor="#FFFFFF">
<p align="center"><html dir="rtl">
<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 topmargin="0">
<div align="center">
So you'd probably want to remove that second chunk from the second <head> tag to the <div align="center"> tag.
The page is properly encoded and appears to be served properly by the webserver so any issue isn't there.
All I can think of is to check in the DB that the encoding is correct there in case the problem's there.
_____________________________
"My strategy is so simple an idiot could have devised it"
Little Blue Plane Web Design | Blood, Sweat & Rust - A Land Rover restoration project
| |
|
|
|
yaronbb
Posts: 40
Joined: 10/5/2006
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 10:32:51
Ok now I now that with include to remove all html and body but I try direct true the page without the include and it is the same.
I am using access db.
The funny is that when I try this code the same code in Israeli server it working great only in the usa server.
In the insert page I have if then to check if the user doesn't send me any blank text is it can do problem?
| |
|
|
|
Tailslide
Posts: 5972
Joined: 5/10/2005
From: Out here on the raggedy edge
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 12:07:06
quote:
ORIGINAL: yaronbb
The funny is that when I try this code the same code in Israeli server it working great only in the usa server.
As said, I don't know ASP so I'm really just guessing here - but is it possible that the DB setup on the Israeli web space uses the correct encoding by default whereas the US web space DB setup is using a western encoding? I might be way off though.
_____________________________
"My strategy is so simple an idiot could have devised it"
Little Blue Plane Web Design | Blood, Sweat & Rust - A Land Rover restoration project
| |
|
|
|
yaronbb
Posts: 40
Joined: 10/5/2006
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 13:34:28
i will try again.
thanks for trying.
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 13:36:14
Show me the printscreen of the gibberish.
thanks.
_____________________________
William Lee
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Insert Into with hebrew - 10/24/2007 21:11:16
I am very sure it has got to do with the output from db written to that page.
Is the gibberish you showed me on the page when the user is successful in logging in? What is suppose to be shown there and from which field of the db table? Check the data inside the field, does it look okay?
Since you are using DRW, can you check the asp page whether any code generated by FP has reference to CodePage?
_____________________________
William Lee
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
So I don't know what gibberish is on the other page. Can you show a printscreen of the gibberish, or could it be some Error msg that can tell us some clue? 
