Re: SQL in German

Irritating problem isn't it? I fixed all of these problems in my SQL*XL utility. SQL*XL is an utility to access Oracle from Excel. It can query Oracle and show the results in Excel. SQL*XL can also take data from Excel and insert it into an Oracle table. Have a look at SQL*XL at:

http://www.oraxcel.com

SQL*XL caters for the 4 possible permutations for decimal separators. As you rightly say you can have different settings in the database itself and on the client PC. So the 4 possibilities are:

     Oracle          Client PC
      1,23             1,23
      1.23             1,23
      1,23             1.23
      1.23             1.23

Please download SQL*XL for a test drive and convince yourself.

Gerrit-Jan Linker

In article <3a8572f2.3373781_at_news.online.de>,   knijff_at_bigfoot.com (Ted Knijff) wrote:
> Hi,
> I am also located in Germany and have had the same problem many times.
> You can do nothing on the Oracle side. Changing NLS_xxx does not work.
> On MS-MDAC systems, including ADO, data is passed from the
> intermediate layer to the cursor and back as comma separated strings,
> including numerics which are without the ' or " character delimeter.
> eg. 'MYSTRING, 123',12.5,'ANOTHER STRING' ...
> Changing the . to a comma generates another value and it crashes.
>
> So to tell the the database that you are sending it a number, you have
> to convert the number to either remove the comma or convert the number
> to a delimited string before sending it to the database.
>
> Some MS-MDAC versions handle it correctly, some don't. The problem is
> not only on the Oracle side and I have the problem with Visual Foxpro,
> Visual Basic, with ODBC or ADO or RDS and Excel ... etc. etc.
>
> For example, the Oracle ODBC driver (all versions supplied with 8i) do
> not work with decimal fractions in Germany. The ODBC that came with
> 8.0.5 works with MDAC versions 1.x. With >8.1.5 you need the MS ODBC
> driver for Oracle that comes with Office.
>
> Oracle tells me MS is to blame. MS tells me, use MS-SQL.
>
> On Mon, 05 Feb 2001 09:19:58 GMT, Dennis <dwehlman_at_my-deja.com> wrote:
>
> >If you change the nls_lang in registory local_machine/software/oracle
> >to AMERICAN_AMERICA.WE8ISO8859P1 it should work
> >
> >Dennis
> >
> >In article <95fhme$v46$1_at_nnrp1.deja.com>,
> > mingoz_at_my-deja.com wrote:
> >> I installed the Oracle 8.0.5 version in English. Later on, I
 changed
> >> the regional setting of my NT server to German. Now my ADO
 statement
> >> failed because my sql is "...set item_a = 12,345, item_b =
 23,456...".
> >> As you can see, the decimal point in German is "," instead of ".".
> >> What can I do to Oracle so that it will take these sql statements?
> >>
> >> Thanks,
> >>
> >> Sent via Deja.com
> >> http://www.deja.com/
> >>
> >
> >
> >Sent via Deja.com
> >http://www.deja.com/
>
> EMail: knijff_at_bigfoot.com
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Feb 12 2001 - 13:38:01 CET