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

Reply via email to