Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unicode fonts not displaying in recordset

Status
Not open for further replies.
jim68

jim68

Programmer
Sep 8, 2002
16
GB
I was using Frontpage to display my data from MS Access, but am now writing the ASP myself. I find when I use Frontpage my Unicode font displays correctly, but not when I write my own code (using Getrows). Why is this? Here is the sort of code that does not work (displaying the field 'Greekword' ina form textbox):

<% 'Establish recordset for form population
DIM mySQL, myDSN, conntemp, objConn, objRS
' Put SQL next
mySQL = &quot;SELECT HeadwordID, Headword, Greekword, DescriptionID FROM tblHeadword Where HeadwordID=&quot; &Request(&quot;HeadwordID&quot;)
' Connect to DB
Set conntemp = Server.CreateObject(&quot;ADODB.Connection&quot;)
myDSN = Application(&quot;Database2_ConnectionString&quot;)
conntemp.Open myDSN
'Establish RS
set objRS = conntemp.execute (mySQL)
%>

<align=&quot;center&quot;><align=&quot;center&quot;>
<form METHOD=&quot;POST&quot; action=&quot;<%=Request(&quot;SCRIPT_NAME&quot;)%>?a=v&quot;>
<input TYPE=&quot;Hidden&quot; NAME=&quot;DescriptionID&quot; VALUE=&quot;<%=objRS(&quot;DescriptionID&quot;)%>&quot;>
<table BORDER=&quot;0&quot; width=&quot;643&quot;>
<tr>
<td width=&quot;131&quot;><B>Word ID:</B></td>
<td width=&quot;178&quot;>
<input NAME=&quot;HeadwordID&quot; SIZE=&quot;4&quot; VALUE=&quot;<%=objRS(&quot;HeadwordID&quot;)%>&quot; tabindex=&quot;1&quot;></td>
<td width=&quot;320&quot;>
<B>Semantic field:  
<A href=&quot;newsemantics.asp?&quot; onclick=&quot;NewWindow(this.href,'newsemantics','500','300','no','center');return false&quot; onfocus=&quot;this.blur()&quot;>
<FONT size=&quot;2&quot;>Add to list</FONT></A></B>
</td>
</tr>

<tr>
<td width=&quot;131&quot;><B>Greek word:</B></td>
<td width=&quot;178&quot;>
<align=&quot;center&quot;>
<input NAME=&quot;Greekword&quot; SIZE=&quot;40&quot; VALUE=&quot;<%=objRS(&quot;Greekword&quot;)%>&quot; style=&quot;font-size:10pt; font-family:Arial Unicode MS&quot;></td>
<form>

Thanks for any help!
 
Sort by date Sort by votes
have you tried setting the page charset in the head of the page.
I'm not sure what the greek charset is.

Try finding out the relevant greek charset and replace the following with it.

<pre>
<head>
<META HTTP-EQUIV=&quot;Content-Type&quot; content=&quot;text/html; charset=iso-8859-1&quot; />
</head>
</pre>

hope this is some help
 
Upvote 0 Downvote
Thanks for the suggestion but unfortunately that does not work. The Greek does display on the pages built by frontpage, but not when I write the code myself.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
iis woos (not displaying pages correctly)
Replies
1
Views
169
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
First execute an input command and only then proceed with displaying the next record of the table
Replies
0
Views
136
leifoet
leifoet
leifoet
  • Locked
  • Question
Wrong code in a href ?
Replies
1
Views
174
leifoet
leifoet
Swi
  • Locked
  • Question
PDF Interrogation
Replies
0
Views
103
Swi
Swi
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
172
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top