Converting foreign accents

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Converting foreign accents

Message

17/02/2017 12:48:12

Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada

17/02/2017 11:35:47

Colin Northway
Colin Northway Associates
London, Royaume Uni

Information générale

Forum:

Visual FoxPro

Catégorie:

Visual FoxExpress

Titre:

Re: Converting foreign accents

Divers

Thread ID:

01648083

Message ID:

01648088

Vues:

Here is an example of a select which converts into some of that:

SELECT Member.Numero
 FROM Member
 WHERE Member.NoCountry=1 AND Member.NoProvince=2 AND
  CHRTRAN(Member.City,"ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ","AAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy")
  ORDER BY Member.LastName,Member.FirstName

Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52

Répondre

Fil

Voir

Click here to load this message in the networking platform