FaxChange, FEATURE - KBFX20050518-143717RAS - Conversion of e-mail addresses and state types in database to the same case

Datasys Knowledge Base Document

Updated:	2005/05/18
Product:	FaxChange
Version:	6.0
Service pack:	6.0.35
Area:	Database
Category:	FEATURE
Problem:	Conversion of e-mail addresses and state types in database to the same case

Problem description:

Until now it was possible to have in Faxchange database stored some data in mixed case - user's e-mail addresses in tUser table and record's type in tState table. It could lead to problems, so new fuction was created, which consolidates these data into the same case.

Solution:

There are two values in the registry, which have effect to letter case in mentioned tables:

[HKLM/Software/Datasys/Faxchange/ODBC/tState/StateTypeCaseUpper] = 1. With this setting letter case of fType column in tState table is not checked. If this value is changed to 0 or deleted, fType is converted to upper case.
[HKLM/Software/Datasys/Faxchange/ODBC/tUser/EmailCaseLower] = 1. With this setting letter case of fEmail column in tUser table is not checked. If this value is changed to 0 or deleted, fEmail is converted to lower case.

To really enforce lower/upper case conversion, database interface must be initialized - so restart all Faxchange services.

Further information:

Keywords:

conversion, email, state, lower case, upper case

If there is something unclear, send us an email to development@datasys.cz.