Converting foreign accents

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Converting foreign accents

Message

From

17/02/2017 12:48:12

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

17/02/2017 11:35:47

Colin Northway
Colin Northway Associates
London, United Kingdom

General information

Forum:

Visual FoxPro

Category:

Visual FoxExpress

Title:

Re: Converting foreign accents

Miscellaneous

Thread ID:

01648083

Message ID:

01648088

Views:

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

Map

View

Click here to load this message in the networking platform