How about adding each variant as a record to your look up table:
french | english
R�p�tez | repeat
Repetez | repeat
fran�ais | french
francais | french
etc.
Cheers,
Bill
In a message dated 6/15/01 11:48:11 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> Howdy all!
>
> I have a simple query question:
>
> Suppose you have this table:
>
> french | english
> R�p�tez | repeat
> fran�ais | french
>
> And you want people to be able to type in a French word, and received the
> English translation.
>
> But you can't assume they can type in characters like � or �
> So whether they type in R�p�tez or Repetez, you want to return "repeat"
>
> So I need to use something like
> <cfset FrenchWithoutAccents = "#ReplaceList(french, "�,�", "c,e")#">
>
> But how do I incorporate that into the query?
>
> Thanks in advance!
> -J
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
