Re: NUMERIC type makes trouble in MS Access

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
>