Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Change Decimal Delimiter

3 posts in ,  General Discussion General Discussion Last posting was on 2003-11-04 17:34:23.0Z
G. Papaioannou Posted on 2003-10-28 18:19:00.0Z
From: "G. Papaioannou" <GPAPAI@RELATIONAL.GR>
Newsgroups: ianywhere.public.general,sybase.public.sqlanywhere.general
Subject: Change Decimal Delimiter
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: d97.kif4.nas.panafonet.gr
Message-ID: <3f9ec238@forums-2-dub>
X-Original-Trace: 28 Oct 2003 11:23:36 -0700, d97.kif4.nas.panafonet.gr
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Oct 2003 11:11:29 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Oct 2003 11:19:00 -0700
X-Trace: forums-1-dub 1067368740 10.22.108.75 (28 Oct 2003 11:19:00 -0700)
X-Original-Trace: 28 Oct 2003 11:19:00 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1941 sybase.public.sqlanywhere.general:84003
Article PK: 4179

Hi.

How can I change the decimal delimiter from "point" to "comma" in ASA v9?
I am already using the greek codepage (cp1253) in the db and -of course- I
have greek as a default language in the OS.

TIA


Graham Hurst Posted on 2003-11-04 16:33:03.0Z
From: Graham Hurst <spam_guard_hurst@ianywhere.com>
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030901 Thunderbird/0.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general,sybase.public.sqlanywhere.general
Followup-To: sybase.public.sqlanywhere.general
Subject: Re: Change Decimal Delimiter
References: <3f9ec238@forums-2-dub>
In-Reply-To: <3f9ec238@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: hurst-xp.sybase.com
X-Original-NNTP-Posting-Host: hurst-xp.sybase.com
Message-ID: <3fa7d4bf$1@forums-1-dub>
Date: 4 Nov 2003 08:33:03 -0800
X-Trace: forums-1-dub 1067963583 172.31.142.129 (4 Nov 2003 08:33:03 -0800)
X-Original-Trace: 4 Nov 2003 08:33:03 -0800, hurst-xp.sybase.com
Lines: 27
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2013 sybase.public.sqlanywhere.general:84247
Article PK: 17370

Please don't crosspost.

I think that the ANSI SQL standard requires the use of a period for the
decimal separator, since commas are used for field separators. So I
doubt any SQL DBMS lets you use commas as decimal separators in SQL
statements.

Otherwise the choice of decimal separator is up to the application
connected to the database.

Where were you hoping to use/see commas instead of periods?

Cheers,

Graham

G. Papaioannou wrote:
> Hi.
>
> How can I change the decimal delimiter from "point" to "comma" in ASA v9?
> I am already using the greek codepage (cp1253) in the db and -of course- I
> have greek as a default language in the OS.
>
> TIA
>
>


Graham Hurst Posted on 2003-11-04 17:34:23.0Z
From: Graham Hurst <spam_guard_hurst@ianywhere.com>
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030901 Thunderbird/0.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere.general
Subject: Re: Change Decimal Delimiter
References: <3f9ec238@forums-2-dub> <3fa7d4bf$1@forums-1-dub>
In-Reply-To: <3fa7d4bf$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: hurst-xp.sybase.com
X-Original-NNTP-Posting-Host: hurst-xp.sybase.com
Message-ID: <3fa7e31f@forums-1-dub>
Date: 4 Nov 2003 09:34:23 -0800
X-Trace: forums-1-dub 1067967263 172.31.142.129 (4 Nov 2003 09:34:23 -0800)
X-Original-Trace: 4 Nov 2003 09:34:23 -0800, hurst-xp.sybase.com
Lines: 14
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.general:84254
Article PK: 947230


Graham Hurst wrote:
> I think that the ANSI SQL standard requires the use of a period for the
> decimal separator, since commas are used for field separators. So I
> doubt any SQL DBMS lets you use commas as decimal separators in SQL
> statements.

Spoke too soon! I did a little more digging and found that some DBMS's
do let you specify which decimal separator to use for SQL statements.
Current versions of ASA don't let you do that.

Cheers,

Graham