Skip site navigation (1) Skip section navigation (2)

Re: Locale problem with psqlODBC under Fedora 16

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Zoltan Boszormenyi <zb(at)cybertec(dot)at>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Locale problem with psqlODBC under Fedora 16
Date: 2011-11-09 17:57:17
Message-ID: 4EBABEFD.8030103@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Zoltan,

(2011/11/08 8:53), Inoue, Hiroshi wrote:
> Hi Zoltan,
>
> (2011/11/06 12:49), Zoltan Boszormenyi wrote:
>> Hi,
>>
>> I just installed Fedora 16 and it has PostgreSQL 9.1.1 and
>> postgresql-odbc-09.00.0200 (which is psqlODBC).
>>
>> My problem comes from this code:
>>
>> SQLBindParameter(hStmt,13,
>> SQL_PARAM_INPUT, SQL_C_DOUBLE, SQL_NUMERIC, 0, 0,
>> (SQLPOINTER)&co2, sizeof(co2), NULL);
>>
>> New value of "co2" is 99.47 but as my Hungarian locale uses comma
>> instead of dot for a decimal separator, this pops up:
>>
>> ERROR: invalid input syntax for type numeric: "99,47" at character 210
>> STATEMENT: update al set
>> megr=1,fpont=1478,csopvez=79,datum='2011-09-05'::date,d1='2011-09-04'::date,t1='21:30:00'::time,d2='2011-09-05'::date,t2='03:00:00'::time,temp=113,n_beepites=1,n_sikeres=1,kutfejnyomas='300',co2='99,47',h2sppm=0,hibajel=E''
>>
>> where id=2805;
>
> OK I would try to fix it.
> Please wait for a day or so.

Could you please try the attached patch?

regards,
Inoue, Hiroshi

Attachment: psqlodbc.patch
Description: text/plain (6.5 KB)

In response to

Responses

pgsql-odbc by date

Next:From: lehmannDate: 2011-11-10 02:07:38
Subject: Re: SQLDescribeParam / SUPPORT_DESCRIBE_PARAM
Previous:From: BGoebelDate: 2011-11-09 16:10:55
Subject: FETCH LAST is returning "no data" after a Cursor Update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group