Hi Filipus, all!
Filipus Klutiero wrote: > Hi, > an international site has some content in several latin languages, for > example English and French. Sometimes 2 pages, one in English and one in > French, have the same name except for an accent (for example, in > English, Demonstration, in French, Démonstration). The site's database > schema enforces page names to be unique. To me, your approach sounds wrong: What would you do if two languages used the same word with fully identical spelling, no accents involved? For example, "demonstration" is used in both English and German. If you want to have unique names in a multi-language setup, IMO you should take the language (code) as part of the page name. With the example above, you might end up with "DE_demonstration" and "EN_demonstration", and then a (missing) accent in "FR_demonstration" might not matter at all. > [[...]] > HTH, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@oracle.com ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven Amtsgericht Muenchen: HRA 95603 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org