French character comparision

itHighway · August 18th, 2009, 04:59 AM

I have a website which is in French. Many of the values stored in website database are in French.

For Example countries table in database has following values
AlgÃ©rie
BÃ©nin
CÃ´te d'Ivoire etc.

When I try to compare DATABASE values (having French charaters) in if-then-else condition, it does not work.
Exmaple:

Quote:

if rs("CountryName") = "AlgÃ©rie" then
'#do something
elseif rs("CountryName") = "BÃ©nin" then
'#do something
end if

Any idea..
Any help..
Will be appriciated...

Thanks!

aspless · August 20th, 2009, 11:12 AM

The only way i can see is to search using the chr associated with the accent.

Code:

if rs("CountryName") = "Alg"&chr(233)&"rie" then
'#do something
elseif rs("CountryName") = "B"&chr(233)&"nin" then
'#do something 
end if

Hope this helps..

Cheers

Aspless