Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Decode this..
Message
From
24/11/2011 12:49:56
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
 
To
24/11/2011 12:25:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01529759
Message ID:
01529760
Views:
72
>Hi All,
>
>My app uses a basic encryption/decryption algorithm based on the ASCII table codepage 1252 English U.S. Nothing fancy.
>When some users, especially in countries using other keyboard languages try to log in using the default user and password setting, they of course get the dreaded 'Invalid Username/Password' routine. They get frustrated and I lose a potential sale!
>Is there a way to have my app override their language/keyboard settings and direct their machine to the English U.S. setting? I've tried setting CODEPAGE=1252 in the config.fpw file, but that doesn't seem to work. Is there anything else I can do?

If you're storing passwords (bad practice) or hashes (good practice) in a VFP table, you probably should store them in Character (Binary) fields rather than plain Character. From VFP Help about the Character Data Type: "To prevent data in Character fields from being translated across code pages, use the Character (Binary) field type."

A quick and dirty workaround may be to change the default password to a string of numbers, e.g. "12345" which may be compatible with more international locales.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform