Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting foreign accents
Message
From
17/02/2017 15:12:33
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxExpress
Miscellaneous
Thread ID:
01648083
Message ID:
01648101
Views:
48
>sorry I dont quite understand
>
>I have a field Paris La D‚fense It should be Paris La Defense - I think th seond letter has an acute accent or am I mistaken?

This was an example on how to use this ChrTran() conversion in a SQL select so you can get specific records which might not have the same ASCII character as the one you would like to search. So, there is an auto conversion to achieve that. This was initially an approach used at the Web site to find records having French characters, among many, also included in the SQL result.
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform