Handling SEO Friendly URL with Non-English Character

Question

Hi, i have urls like this: ex: .com/topic.php?id=6 then i converted to: .com/topic/5.html it works but i want to convert .com/topic/title.html the "title" is dynamic(for example: "çağdaş") and can contain non english chars like Ş, Ğ or Ü in this case firstly i converter chars to acceptable equivalents like Ş to S or Ü to U. In short of i convertert "çağdaş" to "cagdas" and my url look like .com/topic/cagdas.html

I have use cagdas information in sql query for select proper row but in database it stored as çağdaş not cagdas. Please give me suggestions, thanks.

Answer 1

The simplest solution is to store both çağdaş and cagdas in the database table.