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.

decimal separator

2 posts in General Discussion Last posting was on 2005-07-11 13:20:21.0Z
Gururaj Posted on 2005-07-11 12:12:42.0Z
From: "Gururaj" <gururajkombettu@yahoo.com>
Newsgroups: ianywhere.public.general
Organization: 61.246.48.146
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: decimal separator
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <42d26235$1@forums-2-dub>
X-Original-Trace: 11 Jul 2005 05:12:37 -0700, web110.discountasp.net
Lines: 11
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Jul 2005 05:12:40 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Jul 2005 05:12:42 -0700
X-Trace: forums-1-dub 1121083962 10.22.108.75 (11 Jul 2005 05:12:42 -0700)
X-Original-Trace: 11 Jul 2005 05:12:42 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4612
Article PK: 8425

Hi

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

Plz help me out solve this problem.

Cheers guru
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


John Smirnios Posted on 2005-07-11 13:20:21.0Z
From: John Smirnios <smirnios_at_sybase_dot_com>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: decimal separator
References: <42d26235$1@forums-2-dub>
In-Reply-To: <42d26235$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: smirnios-x64.sybase.com
X-Original-NNTP-Posting-Host: smirnios-x64.sybase.com
Message-ID: <42d27215$1@forums-1-dub>
Date: 11 Jul 2005 06:20:21 -0700
X-Trace: forums-1-dub 1121088021 10.25.107.241 (11 Jul 2005 06:20:21 -0700)
X-Original-Trace: 11 Jul 2005 06:20:21 -0700, smirnios-x64.sybase.com
Lines: 30
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4613
Article PK: 8417

You cannot. Fetch the values as floating point & format them to your
liking in your application rather than fetching them as strings. On the
input side, insert as floating point. You certainly can never change the
way numbers are represented in a SQL statement, otherwise you'd
introduce ambiguity:

Does "select 3,14 , 10" return two columns or three?

-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Gururaj wrote:
> Hi
>
> How can I change the decimal delimiter from "point" to "comma" in sqlanywhere 9
> database ?I am already using the greek codepage (cp1253) in the db and -of
> course- I have greek as a default language in the OS.
>
> Plz help me out solve this problem.
>
> Cheers guru
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp