Hi people. I have a very interesting issue here, or it is interesting from my point of view. I have a database with a lot of names and some of them are german or french or any other language that has special characters. let's say we want to add "Jádson" to the database. when added,in the database I find "J_25;dson" instead of "Jádson". It is quite OK because when I try to echo each field, in any browser, I see "Jádson" not "J_25;dson",and this is what I want. The problem is when I try to search something in the database. If I make a link,something like www.site.com/$name and each time $name changes,when I get to $name="Jádson" it dosen't find any entry in the database with that name, because in the database it is actually "J_25;dson", so I can't use any information for this guy. I guess everyone sees my problem. I need 2 things. 1 - First of all I need a way, an algorithm to parse back from "J_25;dson" to "Jádson", that workes for any kind of characters,not just this. For example, if I input in a field "Jádson" I should get back this string -> "J_25;dson". 2 - Secondly, I need a way, an algorithm that can change any name like "Jádson" or "Jérémy" or "Tomić" to "Jadson" and "Jeremy" or "Tomic" . Cheers and thank you for banging your head along with me. Please NOTE something important. The string "J_25;dson" is actually without "_" in the middle, I had to insert it there because DP parses it and I would get Jádson again.
Hey. I am going to assume you have some sort of database preparation function. In your search try preparing the variable for the database, but instead of inserting it select from the database with it. e39m5