🚀 go-pugleaf

AFAIK, MS SQL Server always expects dot as decimal separator in queries. For 
time/date, you may use CONVERT function in query, it has parameter to 
specify date style. Other DBMS may work another way.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Michele Santucci" <michele.santucci@celinavio.it> �������/�������� � 
�������� ���������: news:430ecb7e@newsgroups.borland.com...
>> Setting DecimalSeparator = '.' will use '.' for convertion. Parameters 
>> may be added at runtime too.
>
>
>
> This's exactly what I would like to avoid since I cannot be sure of what 
> type
> of separator the system locale and the database engine are using.
>
> How can I get what separator or more generally what float format is used 
> into
> a database ?
>
> How can I get what time separator or more generally what time/date format 
> i
> used into a database ?
>
> I tried to set the locale of the application with this:
>
>                 setlocale( LC_ALL, "Italian_Italy.1252" );
>
> but this's not enough ...
>
>