Re: International Numbers and Date/Times
Date: 1996/02/08
Message-ID: <4fdn6p$psa_at_goliat.eik.bme.hu>#1/1
Phil Grisier (pgrisier_at_aurum.com) wrote:
: Can anyone describe some of the issues in international
: companies using SQL datbases? In particular, each vendor has a
: scheme for *localizing* a database to get appropriate collating
: sequences. But what happens to numbers and date/time formats.
: The internal storage no doubt is the same, but does the SQL
: text used selects and inserts/updates change. For example, In
: English if I want to select, insert, or update on the value one
: thousand, the SQL statement contains this fragment:
:
: * = 1,000.00 *
:
: But if I am sending this statement statement to a French
: database, will may statement fail unless I send it:
:
: * = 1 000,00 *
:
: The specific problem I want to avoid is in copying a row from a
: connection on an English database to a row on a connection in a
: French database. Can I avoid problems if I select from
: English into bind variables and then insert from them.
:
: Thanks in advance for any advice.
This number format is only important if you use the number directly in the Sql statement, and then the format of the number should follow the local windows format, which can be set in the Control Panel. But if you use bind variables, you should not have any problems because they are in SQLWindows' internal number format. So you can even use the same bind variables for the two databases. ( The same is true for date/time formats).
Tamas Erdei E-mail: erdeit_at_goliat.eik.bme.hu Faculty of Electrical Engineering & Informatics Technical University of Budapest Received on Thu Feb 08 1996 - 00:00:00 CET