search engine/strange characters.

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

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

Expressi&#111;n 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. 

Edited by Badaboem