Article View: borland.public.cppbuilder.database.ado
Article #511Re: Float field format mimatching in query
From: Michele Santucci
Date: Mon, 29 Aug 2005 08:16
Date: Mon, 29 Aug 2005 08:16
45 lines
2769 bytes
2769 bytes
I'm not using MS SQL Server but just an Access Database... do you think is the same ? "Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto nel messaggio news:430f16de@newsgroups.borland.com... > 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 ... >> >> > >
Technical Details
Message-ID:
<4312c450@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.moat.net!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.newsfeeds.com!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<430c51e0@newsgroups.borland.com> <430d5e97$1@newsgroups.borland.com> <430d93fd@newsgroups.borland.com> <430ec2e1$1@newsgroups.borland.com> <430ecb7e@newsgroups.borland.com> <430f16de@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,f2763377f03f683f X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII From: "Michele Santucci" <michele.santucci@celinavio.it> Newsgroups: borland.public.cppbuilder.database.ado References: <430c51e0@newsgroups.borland.com> <430d5e97$1@newsgroups.borland.com> <430d93fd@newsgroups.borland.com> <430ec2e1$1@newsgroups.borland.com> <430ecb7e@newsgroups.borland.com> <430f16de@newsgroups.borland.com> Subject: Re: Float field format mimatching in query Date: Mon, 29 Aug 2005 10:16:57 +0200 Lines: 47 Organization: Celin Avio S.r.l. X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 80.86.50.35 Message-ID: <4312c450@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1125303376 80.86.50.35 (29 Aug 2005 01:16:16 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.moat.net!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.newsfeeds.com!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mail