[RESOLVED] [2005] Unicode variable

[Ivenesco]

I'm trying to download few movie names and save it to database. But when I'm reading title from page sourcecode, and there is for eg. french symbol, i have in database something like this: "è" (it works on forum... I have "& # 232;"). How can I get right name?
Code is like this:

strSource = myClient.DownloadString(strUrl)
strTitle = Functions.GetTitle(strSource)
strTitle = strTitle.Replace("'", "''")
comCommenda.CommandText = "INSERT INTO IMDB_list (Name, Url, [File]) VALUES ('" & strTitle & "','" & strUrl & "','" & strFile & "')"
comCommenda.ExecuteNonQuery()

GetTitle is simple function to get title from source code.

-------------------------------------------------------------
I found, that in source code is "& # 232;"
So other question, how to display it in MS Sql 2005 as è ?