From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Tobias Wendorff <tobias(dot)wendorff(at)tu-dortmund(dot)de> |
Cc: | Craig Ringer <craig(at)2ndquadrant(dot)com>, Jan Wieck <jan(at)wi3ck(dot)info>, pgsql-odbc(at)lists(dot)postgresql(dot)org |
Subject: | Re: NUMERIC type makes trouble in MS Access |
Date: | 2018-05-28 22:39:47 |
Message-ID: | 83d12d4d-0237-bfa4-747c-5d7919f88ea9@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Tobias,
On 2018/05/29 6:19, Tobias Wendorff wrote:
> Dear Hiroshi,
>
> in case you missed my E-Mail from 13 hours ago:
No.
The modified drivers should extend the field length to "max varchar" size.
Please test the driver and tell me the result.
regards,
Hiroshi Inoue
>
> works nice, well done!
>
> Could you perhaps extend the field length of varchar to "max varchar"
> from "Miscellaneous" on page 1? Right now it's limited to 28.
>
> That would allow exporting the highest possible precision in Access
> (f.e. export to CSV).
>
> Thanks again... really good work!
> Tobias
>
>
>
> Am Mo, 28.05.2018, 14:59 schrieb Inoue, Hiroshi:
>> Hi Tobias,
>>
>> Could you please try the test drivers 10.03.0110 on Windows at
>> https://winpg.jp/~inoue/psqlodbc/index.html
>> ?
>>
>> regards,
>> Hiroshi Inoue
>>
>> On 2018/05/28 16:32, Tobias Wendorff wrote:
>>> Hi Hiroshi,
>>>
>>> works nice, well done!
>>>
>>> Could you perhaps extend the field length of varchar to "max varchar"
>>> from "Miscellaneous" on page 1? Right now it's limited to 28.
>>>
>>> That would allow exporting the highest possible precision in Access
>>> (f.e. export to CSV).
>>>
>>> Thanks again... really good work!
>>> Tobias
>>>
>>>
>>>
>>> Am Mo, 28.05.2018, 09:17 schrieb Inoue, Hiroshi:
>>>> Hi Tobias,
>>>>
>>>> Could you please try the test drivers 10.03.0100 on Windows at
>>>> https://winpg.jp/~inoue/psqlodbc/index.html
>>>> ?
>>>> The test drivers have an option
>>>> Numeric(without precision) as
>>>> .
>>>>
>>>> regards,
>>>> Hiroshi Inoue
>>>>
>>>> On 2018/05/28 11:13, Tobias Wendorff wrote:
>>>>> Hi Craig,
>>>>>
>>>>> Am Mo, 28.05.2018, 03:34 schrieb Craig Ringer:
>>>>>> Some quick research suggests that Access's Decimal data type is
>>>>>> what you should be using. It's not floating point. This fits with
>>>>>> what you're saying, as the docs say Decimal in Access is limited
>>>>>> to 28 digits.
>>>>> But there's a problem: you can't change the field type of a linked
>>>>> table in MS Access. Even if the driver delivers the correct type,
>>>>> I cannot influence the decimal width (or anything else) and the
>>>>> problem inevitably arises.
>>>>>
>>>>> So, as Jan and I suggested, the only way is to apply a change
>>>>> either in the column itself or do it in realtime using a VIEW.
>>>>>
>>>>>> Seems like it probably has a more limited implementation using
>>>>>> fixed-point, not PostgreSQL's BCD representation, as they use
>>>>>> a fixed 17 bytes in the native storage.
>>>>>>
>>>>>> It should map as SQL_DECIMAL, NOT double or float.
>>>>> Sure, I didn't want to force fundamental changes here. I just
>>>>> wanted to suggest something like a "compatibility switch" for
>>>>> Microsoft Access when using "unlimited" NUMERIC in PostgreSQL.
>>>>>
>>>>> Best,
>>>>> Tobias
From | Date | Subject | |
---|---|---|---|
Next Message | Tobias Wendorff | 2018-05-29 00:34:38 | Re: NUMERIC type makes trouble in MS Access |
Previous Message | Tobias Wendorff | 2018-05-28 21:19:00 | Re: NUMERIC type makes trouble in MS Access |