Database Discussion - search engine/strange characters.

Print Page | Close Window

search engine/strange characters.

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11307
Printed Date: 30 March 2026 at 4:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: search engine/strange characters.

Posted By: Badaboem
Subject: search engine/strange characters.
Date Posted: 26 July 2004 at 10:35pm

I'm done building a search engine for a link/download directory, but came across an issue. When submitting a download, some text fields are entered in the mssql database with strange characters and they aren't picked up by the search engine.

For example, i entered a field with the test text:
Expression Download Blot
and it's displayed in the database as
Expression Download Blot

I'm not sure why text is entered into the database with these characters. Is there a way to insert text fields into the database without? (the database table type = nvchar)

Here's the insert SQL used.



strSQL = "INSERT INTO " & strDbTable &
"Downloads(Download_Name, Download_Link, D_Url, Download_Preview,
Download_Preview_Movie, Download_SubCat, Submitter, DComments, D_Added,
D_Size, D_Short, Download_Version, D_DownloadLink, D_FreeCommercial,
D_ReportBad) " _

        & "Values('" & strDName
& "','" & strDLink & "','" & strDUrl & "','" &
strDPreview & "','" & strDPreviewMovie & "'," & scid
& "," & lngLoggedInUserID & ",'" & strDLong & "',"
& strDate & ",'" & strDSize & "','" & strDShort
& "','" & strDVersion & "','" & strDownloadORLink &
"','" & strFreeCommercial & "'," & blnReportBad & ")"



    adoCon.Execute(strSQL)

Response.write on all strings don't display these character issues.

Either the search engine has to be fixed somehow or in this case the way the database handles text, but I don't know what to look for or change. Is it the table type I use? Or perhaps the insert statement?

Thanks in advance for your help.

Replies:

Posted By: ljamal
Date Posted: 27 July 2004 at 12:20am

WWF replaces some characters with HTML entities. They will appear correctly when display but unless you run your search query through the correct translator it will not return the correct results. Take a look at the search page code for the forum to see where the translation takes place.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: Badaboem
Date Posted: 27 July 2004 at 5:15am

Thanks Ljamal!

Does anybody know what filter (name) is used to covert certain strings to proper html entity formats in wwf?

Posted By: Badaboem
Date Posted: 27 July 2004 at 11:44am

Never mind, found out what the issue was.
Seems there's a small bug in the forum search and because i duplicated some search script i encountered the same issue.