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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
String comparision	rajesh_css	Java Basics	3	April 21st, 2009 08:41 AM
how t do comparision of elements in xsl	suji	XSLT	2	February 28th, 2008 12:27 PM
Code comparision	ayazhoda	Access VBA	2	June 27th, 2007 05:35 AM
comparision of two word documents	anuradhad	VB How-To	1	July 24th, 2004 04:10 PM
comparision of two documents	anuradhad	Access VBA	0	July 22nd, 2004 12:26 AM