French character comparision

itHighway · #1 (**permalink**) 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 · #2 (**permalink**) 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

Need to download code?

Navigation