Undesired decimal truncation with psqlodbc version 08.04.0100

Undesired decimal truncation with psqlodbc version 08.04.0100

am 16.11.2009 14:49:41 von Marco Cassiano

--0015175dd9d6096f0e04787d48e8
Content-Type: text/plain; charset=ISO-8859-1

Hello everybody,

during this weekend we upgraded our Postgres database from version 8.3.8 to
version 8.4.1.
We also updated the odbc driver from version 08.03.0400 to version
08.04.0100.
With this new version though, we observe an unwanted decimal truncation as
you can see in the following example.

I would need your help to understand the reason of this different, undesired
behavior and how to fix it.

Thank you

Marco

I attached the output from the same query on the same database made with the
two drivers version:


>>>>> With version 08.03.0400 (Correct decimal handling, see column
"co_perc_magg_matrice", first row):

SQL> select * from anamat.collezioni;
+-----+---------------------+-----------------+------------- --------+--------------+---------+
| coll| co_descr | co_coll_numerica| co_perc_magg_matrice|
co_descr_abbr| cond_pag|
+-----+---------------------+-----------------+------------- --------+--------------+---------+
| 1 | Descr. non disponib.| 10 | 1.200 |
PennyPull | RB10 |
| 2 | Descr. non disponib.| 20 | 0.000 |
PennyBlack | |
| 3 | Descr. non disponib.| 30 | 0.000 |
NewPenny | |
| 4 | Descr. non disponib.| 40 | 0.000 |
Classic | RB09 |
| 5 | Descr. non disponib.| 50 | 0.000 | PB
Plus | |
| 6 | Descr. non disponib.| 60 | 0.000 |
Active | |
| 7 | Descr. non disponib.| 70 | 0.000 | Jeans
& B. | |
| 8 | Descr. non disponib.| 96 | 0.000 |
Trend | |
| 9 | Descr. non disponib.| 90 | 0.000 | F.
Natale | |
| A | Descr. non disponib.| 48 | 0.000
| | RB09 |
| B | Descr. non disponib.| 31 | 0.000 | Flash
NP S | RB09 |
| C | Descr. non disponib.| 32 | 0.000 | Flash
NP C | RB09 |
| E | Descr. non disponib.| 11 | 0.000 |
Ins.P.Pull | |
| F | Descr. non disponib.| 21 | 0.000 | Flash
PB J | RB09 |
| G | Descr. non disponib.| 22 | 0.000 | Flash
PB G | RB09 |
| H | Descr. non disponib.| 35 | 0.000 |
Ins.N.Penn | |
| I | Descr. non disponib.| 23 | 0.000 | F. PB
Ant. | RB09 |
| K | Descr. non disponib.| 28 | 0.000 |
N.D. | |
| L | Descr. non disponib.| 84 | 0.000 |
FL | |
| M | Descr. non disponib.| 24 | 0.000 | Flash
PB M | RB09 |
| N | Descr. non disponib.| 85 | 0.000 | Ins.
NP | RB09 |
| O | Descr. non disponib.| 26 | 0.000 | Saldi
I. P | |
| P | Descr. non disponib.| 98 | 0.000 |
Pubblicit. | |
| R | Descr. non disponib.| 99 | 0.000 |
Prototipi | |
| S | Descr. non disponib.| 25 | 0.000 | Ins.
PB Ac | |
| T | Descr. non disponib.| 45 | 0.000 | Fl.
abiti | |
| U | Descr. non disponib.| 46 | 0.000 |
Chemises | |
| V | Descr. non disponib.| 47 | 0.000 | Max&Co
Acc | |
| W | B2B by default | 91 | 0.000 | B2B by
def | |
| X | Descr. non disponib.| 61 | 0.000 | Ins.
MaxCo | |
| Y | Descr. non disponib.| 27 | 0.000 | Idee
reg. | |
| Z | Descr. non disponib.| 49 | 0.000 |
DD | |
+-----+---------------------+-----------------+------------- --------+--------------+---------+
SQLRowCount returns 32
32 rows fetched

>>>>> With version 08.04.0100 (wrong decimal truncation):

SQL> select * from anamat.collezioni;
+-----+---------------------+-----------------+------------- --------+--------------+---------+
| coll| co_descr | co_coll_numerica| co_perc_magg_matrice|
co_descr_abbr| cond_pag|
+-----+---------------------+-----------------+------------- --------+--------------+---------+
| 1 | Descr. non disponib.| 10 | 1 |
PennyPull | RB10 |
| 2 | Descr. non disponib.| 20 | 0 |
PennyBlack | |
| 3 | Descr. non disponib.| 30 | 0 |
NewPenny | |
| 4 | Descr. non disponib.| 40 | 0 |
Classic | RB09 |
| 5 | Descr. non disponib.| 50 | 0 | PB
Plus | |
| 6 | Descr. non disponib.| 60 | 0 |
Active | |
| 7 | Descr. non disponib.| 70 | 0 | Jeans
& B. | |
| 8 | Descr. non disponib.| 96 | 0 |
Trend | |
| 9 | Descr. non disponib.| 90 | 0 | F.
Natale | |
| A | Descr. non disponib.| 48 | 0
| | RB09 |
| B | Descr. non disponib.| 31 | 0 | Flash
NP S | RB09 |
| C | Descr. non disponib.| 32 | 0 | Flash
NP C | RB09 |
| E | Descr. non disponib.| 11 | 0 |
Ins.P.Pull | |
| F | Descr. non disponib.| 21 | 0 | Flash
PB J | RB09 |
| G | Descr. non disponib.| 22 | 0 | Flash
PB G | RB09 |
| H | Descr. non disponib.| 35 | 0 |
Ins.N.Penn | |
| I | Descr. non disponib.| 23 | 0 | F. PB
Ant. | RB09 |
| K | Descr. non disponib.| 28 | 0 |
N.D. | |
| L | Descr. non disponib.| 84 | 0 |
FL | |
| M | Descr. non disponib.| 24 | 0 | Flash
PB M | RB09 |
| N | Descr. non disponib.| 85 | 0 | Ins.
NP | RB09 |
| O | Descr. non disponib.| 26 | 0 | Saldi
I. P | |
| P | Descr. non disponib.| 98 | 0 |
Pubblicit. | |
| R | Descr. non disponib.| 99 | 0 |
Prototipi | |
| S | Descr. non disponib.| 25 | 0 | Ins.
PB Ac | |
| T | Descr. non disponib.| 45 | 0 | Fl.
abiti | |
| U | Descr. non disponib.| 46 | 0 |
Chemises | |
| V | Descr. non disponib.| 47 | 0 | Max&Co
Acc | |
| W | B2B by default | 91 | 0 | B2B by
def | |
| X | Descr. non disponib.| 61 | 0 | Ins.
MaxCo | |
| Y | Descr. non disponib.| 27 | 0 | Idee
reg. | |
| Z | Descr. non disponib.| 49 | 0 |
DD | |
+-----+---------------------+-----------------+------------- --------+--------------+---------+
SQLRowCount returns 32
32 rows fetched

--0015175dd9d6096f0e04787d48e8
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: base64

PGRpdj48c3BhbiBjbGFzcz0iMjA5MjEzODA4LTA5MTEyMDA5Ij48Zm9udCBm YWNlPSJUYWhvbWEi
IHNpemU9IjIiPkhlbGxvIApldmVyeWJvZHksPC9mb250Pjwvc3Bhbj48L2Rp dj4KPGRpdj48c3Bh
biBjbGFzcz0iMjA5MjEzODA4LTA5MTEyMDA5Ij48L3NwYW4+oDwvZGl2Pgo8 ZGl2PjxzcGFuIGNs
YXNzPSIyMDkyMTM4MDgtMDkxMTIwMDkiPjxmb250IGZhY2U9IlRhaG9tYSIg c2l6ZT0iMiI+ZHVy
aW5nIHRoaXMgd2Vla2VuZCAKd2UgdXBncmFkZWQgb3VyIFBvc3RncmVzIGRh dGFiYXNlIGZyb20g
dmVyc2lvbiA4LjMuOCB0byB2ZXJzaW9uIAo4LjQuMS48L2ZvbnQ+PC9zcGFu PjwvZGl2Pgo8ZGl2
PjxzcGFuIGNsYXNzPSIyMDkyMTM4MDgtMDkxMTIwMDkiPjxmb250IGZhY2U9 IlRhaG9tYSIgc2l6
ZT0iMiI+V2UgYWxzbyB1cGRhdGVkIHRoZSAKb2RiYyBkcml2ZXIgZnJvbSB2 ZXJzaW9uIDA4LjAz
LjA0MDAgdG8gdmVyc2lvbiAwOC4wNC4wMTAwLjwvZm9udD48L3NwYW4+PC9k aXY+CjxkaXY+PHNw
YW4gY2xhc3M9IjIwOTIxMzgwOC0wOTExMjAwOSI+PGZvbnQgZmFjZT0iVGFo b21hIiBzaXplPSIy
Ij5XaXRoIHRoaXMgbmV3IAp2ZXJzaW9uIHRob3VnaCwgd2Ugb2JzZXJ2ZSBh biB1bndhbnRlZCBk
ZWNpbWFsIHRydW5jYXRpb24gYXMgeW91IGNhbiBzZWUgaW4gdGhlIApmb2xs b3dpbmcgZXhhbXBs
ZS48L2ZvbnQ+PC9zcGFuPjwvZGl2Pgo8ZGl2PjxzcGFuIGNsYXNzPSIyMDky MTM4MDgtMDkxMTIw
MDkiPjwvc3Bhbj6gPC9kaXY+CjxkaXY+PHNwYW4gY2xhc3M9IjIwOTIxMzgw OC0wOTExMjAwOSI+
PGZvbnQgZmFjZT0iVGFob21hIiBzaXplPSIyIj5JIHdvdWxkIG5lZWQgeW91 ciAKaGVscCB0byB1
bmRlcnN0YW5kIHRoZSByZWFzb24gb2YgdGhpcyBkaWZmZXJlbnQsIHVuZGVz aXJlZCBiZWhhdmlv
ciBhbmQgaG93IHRvIApmaXggaXQuPC9mb250Pjwvc3Bhbj48L2Rpdj4KPGRp dj48c3BhbiBjbGFz
cz0iMjA5MjEzODA4LTA5MTEyMDA5Ij48L3NwYW4+oDwvZGl2Pgo8ZGl2Pjxz cGFuIGNsYXNzPSIy
MDkyMTM4MDgtMDkxMTIwMDkiPjxmb250IGZhY2U9IlRhaG9tYSIgc2l6ZT0i MiI+VGhhbmsgCnlv
dTwvZm9udD48L3NwYW4+PC9kaXY+CjxkaXY+PHNwYW4gY2xhc3M9IjIwOTIx MzgwOC0wOTExMjAw
OSI+PC9zcGFuPqA8L2Rpdj4KPGRpdj48c3BhbiBjbGFzcz0iMjA5MjEzODA4 LTA5MTEyMDA5Ij48
Zm9udCBmYWNlPSJUYWhvbWEiIHNpemU9IjIiPk1hcmNvPC9mb250Pjwvc3Bh bj48L2Rpdj4KPGRp
dj48c3BhbiBjbGFzcz0iMjA5MjEzODA4LTA5MTEyMDA5Ij48L3NwYW4+oDwv ZGl2Pgo8ZGl2Pjxz
cGFuIGNsYXNzPSIyMDkyMTM4MDgtMDkxMTIwMDkiPjxmb250IGZhY2U9IlRh aG9tYSIgc2l6ZT0i
MiI+SSBhdHRhY2hlZCB0aGUgCm91dHB1dCBmcm9tIHRoZSBzYW1lIHF1ZXJ5 IG9uIHRoZSBzYW1l
IGRhdGFiYXNlIG1hZGUgd2l0aCB0aGUgdHdvIGRyaXZlcnMgCnZlcnNpb246 PC9mb250Pjwvc3Bh
bj48L2Rpdj4KPGRpdj48c3BhbiBjbGFzcz0iMjA5MjEzODA4LTA5MTEyMDA5 Ij48L3NwYW4+oDwv
ZGl2Pgo8ZGl2PjxzcGFuIGNsYXNzPSIyMDkyMTM4MDgtMDkxMTIwMDkiPjwv c3Bhbj6gPC9kaXY+
CjxkaXY+PHNwYW4gY2xhc3M9IjIwOTIxMzgwOC0wOTExMjAwOSI+PGZvbnQg ZmFjZT0iQ291cmll
ciBOZXciIHNpemU9IjIiPgo8ZGl2PjxzcGFuIGNsYXNzPSIyMDkyMTM4MDgt MDkxMTIwMDkiPjxm
b250IGZhY2U9IkNvdXJpZXIgTmV3IiBzaXplPSIyIj4mZ3Q7Jmd0OyZndDsm Z3Q7Jmd0OyBXaXRo
IHZlcnNpb24gMDguMDMuMDQwMCAoQ29ycmVjdCBkZWNpbWFsIApoYW5kbGlu Zywgc2VlIGNvbHVt
biAmcXVvdDtjb19wZXJjX21hZ2dfbWF0cmljZSZxdW90OywgZmlyc3QgCnJv dyk6PC9mb250Pjwv
c3Bhbj48L2Rpdj48L2ZvbnQ+PC9zcGFuPjwvZGl2Pgo8ZGl2PjxzcGFuIGNs YXNzPSIyMDkyMTM4
MDgtMDkxMTIwMDkiPjwvc3Bhbj6gPC9kaXY+CjxkaXY+PHNwYW4gY2xhc3M9 IjIwOTIxMzgwOC0w
OTExMjAwOSI+PGZvbnQgZmFjZT0iQ291cmllciBOZXciIHNpemU9IjIiPlNR TCZndDsgCnNlbGVj
dCAqIGZyb20gCmFuYW1hdC5jb2xsZXppb25pOzxicj4rLS0tLS0rLS0tLS0t LS0tLS0tLS0tLS0t
LS0tKy0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0t
LSstLS0tLS0tLS0rPGJyPnwgCmNvbGx8IGNvX2Rlc2NyoKCgoKCgoKCgoKAg fCBjb19jb2xsX251
bWVyaWNhfCBjb19wZXJjX21hZ2dfbWF0cmljZXwgCmNvX2Rlc2NyX2FiYnJ8 IApjb25kX3BhZ3w8
YnI+Ky0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0t LS0tLSstLS0tLS0t
LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tKzxicj58 IAoxoKAgfCBEZXNj
ci4gbm9uIGRpc3BvbmliLnwgMTCgoKCgoKCgoKCgoKCgIHwgMS4yMDCgoKCg oKCgoKCgoKCgoCB8
IFBlbm55UHVsbKCgoCAKfCBSQjEwoKCgIHw8YnI+fCAyoKAgfCBEZXNjci4g bm9uIGRpc3Bvbmli
LnwgMjCgoKCgoKCgoKCgoKCgIHwgCjAuMDAwoKCgoKCgoKCgoKCgoKAgfCBQ ZW5ueUJsYWNroKAg
fKCgoKCgoKCgIHw8YnI+fCAzoKAgfCBEZXNjci4gbm9uIGRpc3BvbmliLnwg CjMwoKCgoKCgoKCg
oKCgoCB8IDAuMDAwoKCgoKCgoKCgoKCgoKAgfCBOZXdQZW5ueaCgoKAgfKCg oKCgoKCgIHw8YnI+
fCA0oKAgfCAKRGVzY3IuIG5vbiBkaXNwb25pYi58IDQwoKCgoKCgoKCgoKCg oCB8IDAuMDAwoKCg
oKCgoKCgoKCgoKAgfCBDbGFzc2ljoKCgoKAgfCAKUkIwOaCgoCB8PGJyPnwg NaCgIHwgRGVzY3Iu
IG5vbiBkaXNwb25pYi58IDUwoKCgoKCgoKCgoKCgoCB8IDAuMDAwoKCgoKCg oKCgoKCgoKAgCnwg
UEIgUGx1c6CgoKCgIHygoKCgoKCgoCB8PGJyPnwgNqCgIHwgRGVzY3IuIG5v biBkaXNwb25pYi58
IDYwoKCgoKCgoKCgoKCgoCB8IAowLjAwMKCgoKCgoKCgoKCgoKCgIHwgQWN0 aXZloKCgoKCgIHyg
oKCgoKCgoCB8PGJyPnwgN6CgIHwgRGVzY3IuIG5vbiBkaXNwb25pYi58IAo3 MKCgoKCgoKCgoKCg
oKAgfCAwLjAwMKCgoKCgoKCgoKCgoKCgIHwgSmVhbnMgJmFtcDsgQi6goCB8 oKCgoKCgoKAgfDxi
cj58IDigoCB8IApEZXNjci4gbm9uIGRpc3BvbmliLnwgOTagoKCgoKCgoKCg oKCgIHwgMC4wMDCg
oKCgoKCgoKCgoKCgoCB8IFRyZW5koKCgoKCgoCAKfKCgoKCgoKCgIHw8YnI+ fCA5oKAgfCBEZXNj
ci4gbm9uIGRpc3BvbmliLnwgOTCgoKCgoKCgoKCgoKCgIHwgCjAuMDAwoKCg oKCgoKCgoKCgoKAg
fCBGLiBOYXRhbGWgoKAgfKCgoKCgoKCgIHw8YnI+fCBBoKAgfCBEZXNjci4g bm9uIGRpc3Bvbmli
LnwgCjQ4oKCgoKCgoKCgoKCgoCB8IDAuMDAwoKCgoKCgoKCgoKCgoKAgfKCg oKCgoKCgoKCgoKAg
fCBSQjA5oKCgIHw8YnI+fCBCoKAgfCAKRGVzY3IuIG5vbiBkaXNwb25pYi58 IDMxoKCgoKCgoKCg
oKCgoCB8IDAuMDAwoKCgoKCgoKCgoKCgoKAgfCBGbGFzaCBOUCBToKAgfCAK UkIwOaCgoCB8PGJy
PnwgQ6CgIHwgRGVzY3IuIG5vbiBkaXNwb25pYi58IDMyoKCgoKCgoKCgoKCg oCB8IDAuMDAwoKCg
oKCgoKCgoKCgoKAgCnwgRmxhc2ggTlAgQ6CgIHwgUkIwOaCgoCB8PGJyPnwg RaCgIHwgRGVzY3Iu
IG5vbiBkaXNwb25pYi58IDExoKCgoKCgoKCgoKCgoCB8IAowLjAwMKCgoKCg oKCgoKCgoKCgIHwg
SW5zLlAuUHVsbKCgIHygoKCgoKCgoCB8PGJyPnwgRqCgIHwgRGVzY3IuIG5v biBkaXNwb25pYi58
IAoyMaCgoKCgoKCgoKCgoKAgfCAwLjAwMKCgoKCgoKCgoKCgoKCgIHwgRmxh c2ggUEIgSqCgIHwg
UkIwOaCgoCB8PGJyPnwgR6CgIHwgCkRlc2NyLiBub24gZGlzcG9uaWIufCAy MqCgoKCgoKCgoKCg
oKAgfCAwLjAwMKCgoKCgoKCgoKCgoKCgIHwgRmxhc2ggUEIgR6CgIHwgClJC MDmgoKAgfDxicj58
IEigoCB8IERlc2NyLiBub24gZGlzcG9uaWIufCAzNaCgoKCgoKCgoKCgoKAg fCAwLjAwMKCgoKCg
oKCgoKCgoKCgIAp8IElucy5OLlBlbm6goCB8oKCgoKCgoKAgfDxicj58IEmg oCB8IERlc2NyLiBu
b24gZGlzcG9uaWIufCAyM6CgoKCgoKCgoKCgoKAgfCAKMC4wMDCgoKCgoKCg oKCgoKCgoCB8IEYu
IFBCIEFudC6goCB8IFJCMDmgoKAgfDxicj58IEugoCB8IERlc2NyLiBub24g ZGlzcG9uaWIufCAK
MjigoKCgoKCgoKCgoKCgIHwgMC4wMDCgoKCgoKCgoKCgoKCgoCB8IE4uRC6g oKCgoKCgoCB8oKCg
oKCgoKAgfDxicj58IEygoCB8IApEZXNjci4gbm9uIGRpc3BvbmliLnwgODSg oKCgoKCgoKCgoKCg
IHwgMC4wMDCgoKCgoKCgoKCgoKCgoCB8IEZMoKCgoKCgoKCgoCAKfKCgoKCg oKCgIHw8YnI+fCBN
oKAgfCBEZXNjci4gbm9uIGRpc3BvbmliLnwgMjSgoKCgoKCgoKCgoKCgIHwg CjAuMDAwoKCgoKCg
oKCgoKCgoKAgfCBGbGFzaCBQQiBNoKAgfCBSQjA5oKCgIHw8YnI+fCBOoKAg fCBEZXNjci4gbm9u
IGRpc3BvbmliLnwgCjg1oKCgoKCgoKCgoKCgoCB8IDAuMDAwoKCgoKCgoKCg oKCgoKAgfCBJbnMu
IE5QoKCgoKAgfCBSQjA5oKCgIHw8YnI+fCBPoKAgfCAKRGVzY3IuIG5vbiBk aXNwb25pYi58IDI2
oKCgoKCgoKCgoKCgoCB8IDAuMDAwoKCgoKCgoKCgoKCgoKAgfCBTYWxkaSBJ LiBQoKAgCnygoKCg
oKCgoCB8PGJyPnwgUKCgIHwgRGVzY3IuIG5vbiBkaXNwb25pYi58IDk4oKCg oKCgoKCgoKCgoCB8
IAowLjAwMKCgoKCgoKCgoKCgoKCgIHwgUHViYmxpY2l0LqCgIHygoKCgoKCg oCB8PGJyPnwgUqCg
IHwgRGVzY3IuIG5vbiBkaXNwb25pYi58IAo5OaCgoKCgoKCgoKCgoKAgfCAw LjAwMKCgoKCgoKCg
oKCgoKCgIHwgUHJvdG90aXBpoKCgIHygoKCgoKCgoCB8PGJyPnwgU6CgIHwg CkRlc2NyLiBub24g
ZGlzcG9uaWIufCAyNaCgoKCgoKCgoKCgoKAgfCAwLjAwMKCgoKCgoKCgoKCg oKCgIHwgSW5zLiBQ
QiBBY6CgIAp8oKCgoKCgoKAgfDxicj58IFSgoCB8IERlc2NyLiBub24gZGlz cG9uaWIufCA0NaCg
oKCgoKCgoKCgoKAgfCAKMC4wMDCgoKCgoKCgoKCgoKCgoCB8IEZsLiBhYml0 aaCgoCB8oKCgoKCg
oKAgfDxicj58IFWgoCB8IERlc2NyLiBub24gZGlzcG9uaWIufCAKNDagoKCg oKCgoKCgoKCgIHwg
MC4wMDCgoKCgoKCgoKCgoKCgoCB8IENoZW1pc2VzoKCgoCB8oKCgoKCgoKAg fDxicj58IFagoCB8
IApEZXNjci4gbm9uIGRpc3BvbmliLnwgNDegoKCgoKCgoKCgoKCgIHwgMC4w MDCgoKCgoKCgoKCg
oKCgoCB8IE1heCZhbXA7Q28gQWNjoKAgCnygoKCgoKCgoCB8PGJyPnwgV6Cg IHwgQjJCIGJ5IGRl
ZmF1bHSgoKCgoCB8IDkxoKCgoKCgoKCgoKCgoCB8IAowLjAwMKCgoKCgoKCg oKCgoKCgIHwgQjJC
IGJ5IGRlZqCgIHygoKCgoKCgoCB8PGJyPnwgWKCgIHwgRGVzY3IuIG5vbiBk aXNwb25pYi58IAo2
MaCgoKCgoKCgoKCgoKAgfCAwLjAwMKCgoKCgoKCgoKCgoKCgIHwgSW5zLiBN YXhDb6CgIHygoKCg
oKCgoCB8PGJyPnwgWaCgIHwgCkRlc2NyLiBub24gZGlzcG9uaWIufCAyN6Cg oKCgoKCgoKCgoKAg
fCAwLjAwMKCgoKCgoKCgoKCgoKCgIHwgSWRlZSByZWcuoKCgIAp8oKCgoKCg oKAgfDxicj58IFqg
oCB8IERlc2NyLiBub24gZGlzcG9uaWIufCA0OaCgoKCgoKCgoKCgoKAgfCAK MC4wMDCgoKCgoKCg
oKCgoKCgoCB8IEREoKCgoKCgoKCgoCB8oKCgoKCgoKAgCnw8YnI+Ky0tLS0t Ky0tLS0tLS0tLS0t
LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0t LS0tLS0rLS0tLS0t
LS0tLS0tLS0rLS0tLS0tLS0tKzxicj5TUUxSb3dDb3VudCAKcmV0dXJucyAz Mjxicj4zMiByb3dz
IGZldGNoZWQ8YnI+PC9mb250Pjwvc3Bhbj48L2Rpdj4KPGRpdj48c3BhbiBj bGFzcz0iMjA5MjEz
ODA4LTA5MTEyMDA5Ij48L3NwYW4+oDwvZGl2Pgo8ZGl2PjxzcGFuIGNsYXNz PSIyMDkyMTM4MDgt
MDkxMTIwMDkiPjxmb250IGZhY2U9IkNvdXJpZXIgTmV3IiBzaXplPSIyIj4m Z3Q7Jmd0OyZndDsm
Z3Q7Jmd0OyBXaXRoIHZlcnNpb24gMDguMDQuMDEwMCAod3JvbmcgZGVjaW1h bCAKdHJ1bmNhdGlv
bik6PC9mb250Pjwvc3Bhbj48L2Rpdj4KPGRpdj48c3BhbiBjbGFzcz0iMjA5 MjEzODA4LTA5MTEy
MDA5Ij48L3NwYW4+oDwvZGl2Pgo8ZGl2PjxzcGFuIGNsYXNzPSIyMDkyMTM4 MDgtMDkxMTIwMDki
Pjxmb250IGZhY2U9IlRhaG9tYSIgc2l6ZT0iMiI+PGZvbnQgZmFjZT0iQ291 cmllciBOZXciPlNR
TCZndDsgc2VsZWN0ICogZnJvbSAKYW5hbWF0LmNvbGxlemlvbmk7PGJyPist LS0tLSstLS0tLS0t
LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t LS0tLS0tLS0tKy0t
LS0tLS0tLS0tLS0tKy0tLS0tLS0tLSs8YnI+fCAKY29sbHwgY29fZGVzY3Kg oKCgoKCgoKCgoCB8
IGNvX2NvbGxfbnVtZXJpY2F8IGNvX3BlcmNfbWFnZ19tYXRyaWNlfCAKY29f ZGVzY3JfYWJicnwg
CmNvbmRfcGFnfDxicj4rLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0t LS0tLS0tLS0tLS0t
LS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0t LS0tLS0rPGJyPnwg
CjGgoCB8IERlc2NyLiBub24gZGlzcG9uaWIufCAxMKCgoKCgoKCgoKCgoKAg fKAxoKCgoKCgoKCg
oKCgoKCgoKCgIHwgUGVubnlQdWxsoKCgIAp8IFJCMTCgoKAgfDxicj58IDKg oCB8IERlc2NyLiBu
b24gZGlzcG9uaWIufCAyMKCgoKCgoKCgoKCgoKAgfCAKMKCgoKCgoKCgoKCg oKCgoKCgoCB8IFBl
bm55QmxhY2ugoCB8oKCgoKCgoKAgfDxicj58IDOgoCB8IERlc2NyLiBub24g ZGlzcG9uaWIufCAK
MzCgoKCgoKCgoKCgoKCgIHwgMKCgoKCgoKCgoKCgoKCgoKCgoCB8IE5ld1Bl bm55oKCgoCB8oKCg
oKCgoKAgfDxicj58IDSgoCB8IApEZXNjci4gbm9uIGRpc3BvbmliLnwgNDCg oKCgoKCgoKCgoKCg
IHwgMKCgoKCgoKCgoKCgoKCgoKCgoCB8IENsYXNzaWOgoKCgoCB8IApSQjA5 oKCgIHw8YnI+fCA1
oKAgfCBEZXNjci4gbm9uIGRpc3BvbmliLnwgNTCgoKCgoKCgoKCgoKCgIHwg MKCgoKCgoKCgoKCg
oKCgoKCgoCAKfCBQQiBQbHVzoKCgoKAgfKCgoKCgoKCgIHw8YnI+fCA2oKAg fCBEZXNjci4gbm9u
IGRpc3BvbmliLnwgNjCgoKCgoKCgoKCgoKCgIHwgCjCgoKCgoKCgoKCgoKCg oKCgoKAgfCBBY3Rp
dmWgoKCgoKAgfKCgoKCgoKCgIHw8YnI+fCA3oKAgfCBEZXNjci4gbm9uIGRp c3BvbmliLnwgCjcw
oKCgoKCgoKCgoKCgoCB8IDCgoKCgoKCgoKCgoKCgoKCgoKAgfCBKZWFucyAm YW1wOyBCLqCgIHyg
oKCgoKCgoCB8PGJyPnwgOKCgIHwgCkRlc2NyLiBub24gZGlzcG9uaWIufCA5 NqCgoKCgoKCgoKCg
oKAgfCAwoKCgoKCgoKCgoKCgoKCgoKCgIHwgVHJlbmSgoKCgoKCgIAp8oKCg oKCgoKAgfDxicj58
IDmgoCB8IERlc2NyLiBub24gZGlzcG9uaWIufCA5MKCgoKCgoKCgoKCgoKAg fCAKMKCgoKCgoKCg
oKCgoKCgoKCgoCB8IEYuIE5hdGFsZaCgoCB8oKCgoKCgoKAgfDxicj58IEGg oCB8IERlc2NyLiBu
b24gZGlzcG9uaWIufCAKNDigoKCgoKCgoKCgoKCgIHwgMKCgoKCgoKCgoKCg oKCgoKCgoCB8oKCg
oKCgoKCgoKCgoCB8IFJCMDmgoKAgfDxicj58IEKgoCB8IApEZXNjci4gbm9u IGRpc3BvbmliLnwg
MzGgoKCgoKCgoKCgoKCgIHwgMKCgoKCgoKCgoKCgoKCgoKCgoCB8IEZsYXNo IE5QIFOgoCB8IApS
QjA5oKCgIHw8YnI+fCBDoKAgfCBEZXNjci4gbm9uIGRpc3BvbmliLnwgMzKg oKCgoKCgoKCgoKCg
IHwgMKCgoKCgoKCgoKCgoKCgoKCgoCAKfCBGbGFzaCBOUCBDoKAgfCBSQjA5 oKCgIHw8YnI+fCBF
oKAgfCBEZXNjci4gbm9uIGRpc3BvbmliLnwgMTGgoKCgoKCgoKCgoKCgIHwg CjCgoKCgoKCgoKCg
oKCgoKCgoKAgfCBJbnMuUC5QdWxsoKAgfKCgoKCgoKCgIHw8YnI+fCBGoKAg fCBEZXNjci4gbm9u
IGRpc3BvbmliLnwgCjIxoKCgoKCgoKCgoKCgoCB8IDCgoKCgoKCgoKCgoKCg oKCgoKAgfCBGbGFz
aCBQQiBKoKAgfCBSQjA5oKCgIHw8YnI+fCBHoKAgfCAKRGVzY3IuIG5vbiBk aXNwb25pYi58IDIy
oKCgoKCgoKCgoKCgoCB8IDCgoKCgoKCgoKCgoKCgoKCgoKAgfCBGbGFzaCBQ QiBHoKAgfCAKUkIw
OaCgoCB8PGJyPnwgSKCgIHwgRGVzY3IuIG5vbiBkaXNwb25pYi58IDM1oKCg oKCgoKCgoKCgoCB8
IDCgoKCgoKCgoKCgoKCgoKCgoKAgCnwgSW5zLk4uUGVubqCgIHygoKCgoKCg oCB8PGJyPnwgSaCg
IHwgRGVzY3IuIG5vbiBkaXNwb25pYi58IDIzoKCgoKCgoKCgoKCgoCB8IAow oKCgoKCgoKCgoKCg
oKCgoKCgIHwgRi4gUEIgQW50LqCgIHwgUkIwOaCgoCB8PGJyPnwgS6CgIHwg RGVzY3IuIG5vbiBk
aXNwb25pYi58IAoyOKCgoKCgoKCgoKCgoKAgfCAwoKCgoKCgoKCgoKCgoKCg oKCgIHwgTi5ELqCg
oKCgoKCgIHygoKCgoKCgoCB8PGJyPnwgTKCgIHwgCkRlc2NyLiBub24gZGlz cG9uaWIufCA4NKCg
oKCgoKCgoKCgoKAgfCAwoKCgoKCgoKCgoKCgoKCgoKCgIHwgRkygoKCgoKCg oKCgIAp8oKCgoKCg
oKAgfDxicj58IE2goCB8IERlc2NyLiBub24gZGlzcG9uaWIufCAyNKCgoKCg oKCgoKCgoKAgfCAK
MKCgoKCgoKCgoKCgoKCgoKCgoCB8IEZsYXNoIFBCIE2goCB8IFJCMDmgoKAg fDxicj58IE6goCB8
IERlc2NyLiBub24gZGlzcG9uaWIufCAKODWgoKCgoKCgoKCgoKCgIHwgMKCg oKCgoKCgoKCgoKCg
oKCgoCB8IElucy4gTlCgoKCgoCB8IFJCMDmgoKAgfDxicj58IE+goCB8IApE ZXNjci4gbm9uIGRp
c3BvbmliLnwgMjagoKCgoKCgoKCgoKCgIHwgMKCgoKCgoKCgoKCgoKCgoKCg oCB8IFNhbGRpIEku
IFCgoCAKfKCgoKCgoKCgIHw8YnI+fCBQoKAgfCBEZXNjci4gbm9uIGRpc3Bv bmliLnwgOTigoKCg
oKCgoKCgoKCgIHwgCjCgoKCgoKCgoKCgoKCgoKCgoKAgfCBQdWJibGljaXQu oKAgfKCgoKCgoKCg
IHw8YnI+fCBSoKAgfCBEZXNjci4gbm9uIGRpc3BvbmliLnwgCjk5oKCgoKCg oKCgoKCgoCB8IDCg
oKCgoKCgoKCgoKCgoKCgoKAgfCBQcm90b3RpcGmgoKAgfKCgoKCgoKCgIHw8 YnI+fCBToKAgfCAK
RGVzY3IuIG5vbiBkaXNwb25pYi58IDI1oKCgoKCgoKCgoKCgoCB8IDCgoKCg oKCgoKCgoKCgoKCg
oKAgfCBJbnMuIFBCIEFjoKAgCnygoKCgoKCgoCB8PGJyPnwgVKCgIHwgRGVz Y3IuIG5vbiBkaXNw
b25pYi58IDQ1oKCgoKCgoKCgoKCgoCB8IAowoKCgoKCgoKCgoKCgoKCgoKCg IHwgRmwuIGFiaXRp
oKCgIHygoKCgoKCgoCB8PGJyPnwgVaCgIHwgRGVzY3IuIG5vbiBkaXNwb25p Yi58IAo0NqCgoKCg
oKCgoKCgoKAgfCAwoKCgoKCgoKCgoKCgoKCgoKCgIHwgQ2hlbWlzZXOgoKCg IHygoKCgoKCgoCB8
PGJyPnwgVqCgIHwgCkRlc2NyLiBub24gZGlzcG9uaWIufCA0N6CgoKCgoKCg oKCgoKAgfCAwoKCg
oKCgoKCgoKCgoKCgoKCgIHwgTWF4JmFtcDtDbyBBY2OgoCAKfKCgoKCgoKCg IHw8YnI+fCBXoKAg
fCBCMkIgYnkgZGVmYXVsdKCgoKCgIHwgOTGgoKCgoKCgoKCgoKCgIHwgCjCg oKCgoKCgoKCgoKCg
oKCgoKAgfCBCMkIgYnkgZGVmoKAgfKCgoKCgoKCgIHw8YnI+fCBYoKAgfCBE ZXNjci4gbm9uIGRp
c3BvbmliLnwgCjYxoKCgoKCgoKCgoKCgoCB8IDCgoKCgoKCgoKCgoKCgoKCg oKAgfCBJbnMuIE1h
eENvoKAgfKCgoKCgoKCgIHw8YnI+fCBZoKAgfCAKRGVzY3IuIG5vbiBkaXNw b25pYi58IDI3oKCg
oKCgoKCgoKCgoCB8IDCgoKCgoKCgoKCgoKCgoKCgoKAgfCBJZGVlIHJlZy6g oKAgCnygoKCgoKCg
oCB8PGJyPnwgWqCgIHwgRGVzY3IuIG5vbiBkaXNwb25pYi58IDQ5oKCgoKCg oKCgoKCgoCB8IAow
oKCgoKCgoKCgoKCgoKCgoKCgIHwgRESgoKCgoKCgoKCgIHygoKCgoKCgoCAK fDxicj4rLS0tLS0r
LS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tKy0tLS0t LS0tLS0tLS0tLS0t
LS0tLSstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0rPGJyPlNRTFJvd0NvdW50 IApyZXR1cm5zIDMy
PGJyPjMyIHJvd3MgZmV0Y2hlZDwvZm9udD48YnI+PC9mb250Pjwvc3Bhbj48 L2Rpdj4KPGRpdj4K
PHAgc3R5bGU9Im1hcmdpbjogMGNtIDBjbSAwcHQ7Ij48c3BhbiBzdHlsZT0i Zm9udC1mYW1pbHk6
IEFyaWFsOyBmb250LXNpemU6IDcuNXB0OyI+PC9zcGFuPjwvcD48c3BhbiBz dHlsZT0iZm9udC1m
YW1pbHk6IEFyaWFsOyBmb250LXNpemU6IDcuNXB0OyI+PC9zcGFuPjxzcGFu IHN0eWxlPSJmb250
LWZhbWlseTogVGFob21hOyI+PC9zcGFuPiA8YnI+PC9kaXY+PGJyIGNsZWFy PSJhbGwiPgo8YnI+
Cg==
--0015175dd9d6096f0e04787d48e8--

Re: Undesired decimal truncation with psqlodbc version 08.04.0100

am 17.11.2009 17:16:54 von Hiroshi Inoue

This is a multi-part message in MIME format.
--------------090607020806010703090601
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Marco,

Marco Cassiano wrote:
> Hello everybody,
>
> during this weekend we upgraded our Postgres database from version 8.3.8
> to version 8.4.1.
> We also updated the odbc driver from version 08.03.0400 to version
> 08.04.0100.
> With this new version though, we observe an unwanted decimal truncation
> as you can see in the following example.
>
> I would need your help to understand the reason of this different,
> undesired behavior and how to fix it.

Please apply the attached patch.

regards,
Hiroshi Inoue

> Thank you
>
> Marco
>
> I attached the output from the same query on the same database made with
> the two drivers version:
>
>
>> >>>> With version 08.03.0400 (Correct decimal handling, see column
> "co_perc_magg_matrice", first row):
>
> SQL> select * from anamat.collezioni;
> +-----+---------------------+-----------------+------------- --------+--------------+---------+
> | coll| co_descr | co_coll_numerica| co_perc_magg_matrice|
> co_descr_abbr| cond_pag|
> +-----+---------------------+-----------------+------------- --------+--------------+---------+
> | 1 | Descr. non disponib.| 10 | 1.200 |
> PennyPull | RB10 |
> | 2 | Descr. non disponib.| 20 | 0.000 |
> PennyBlack | |
> | 3 | Descr. non disponib.| 30 | 0.000 |
> NewPenny | |
> | 4 | Descr. non disponib.| 40 | 0.000 |
> Classic | RB09 |
> | 5 | Descr. non disponib.| 50 | 0.000 | PB
> Plus | |
> | 6 | Descr. non disponib.| 60 | 0.000 |
> Active | |
> | 7 | Descr. non disponib.| 70 | 0.000 |
> Jeans & B. | |
> | 8 | Descr. non disponib.| 96 | 0.000 |
> Trend | |
> | 9 | Descr. non disponib.| 90 | 0.000 | F.
> Natale | |
> | A | Descr. non disponib.| 48 | 0.000
> | | RB09 |
> | B | Descr. non disponib.| 31 | 0.000 |
> Flash NP S | RB09 |
> | C | Descr. non disponib.| 32 | 0.000 |
> Flash NP C | RB09 |
> | E | Descr. non disponib.| 11 | 0.000 |
> Ins.P.Pull | |
> | F | Descr. non disponib.| 21 | 0.000 |
> Flash PB J | RB09 |
> | G | Descr. non disponib.| 22 | 0.000 |
> Flash PB G | RB09 |
> | H | Descr. non disponib.| 35 | 0.000 |
> Ins.N.Penn | |
> | I | Descr. non disponib.| 23 | 0.000 | F.
> PB Ant. | RB09 |
> | K | Descr. non disponib.| 28 | 0.000 |
> N.D. | |
> | L | Descr. non disponib.| 84 | 0.000 |
> FL | |
> | M | Descr. non disponib.| 24 | 0.000 |
> Flash PB M | RB09 |
> | N | Descr. non disponib.| 85 | 0.000 |
> Ins. NP | RB09 |
> | O | Descr. non disponib.| 26 | 0.000 |
> Saldi I. P | |
> | P | Descr. non disponib.| 98 | 0.000 |
> Pubblicit. | |
> | R | Descr. non disponib.| 99 | 0.000 |
> Prototipi | |
> | S | Descr. non disponib.| 25 | 0.000 |
> Ins. PB Ac | |
> | T | Descr. non disponib.| 45 | 0.000 |
> Fl. abiti | |
> | U | Descr. non disponib.| 46 | 0.000 |
> Chemises | |
> | V | Descr. non disponib.| 47 | 0.000 |
> Max&Co Acc | |
> | W | B2B by default | 91 | 0.000 |
> B2B by def | |
> | X | Descr. non disponib.| 61 | 0.000 |
> Ins. MaxCo | |
> | Y | Descr. non disponib.| 27 | 0.000 |
> Idee reg. | |
> | Z | Descr. non disponib.| 49 | 0.000 |
> DD | |
> +-----+---------------------+-----------------+------------- --------+--------------+---------+
> SQLRowCount returns 32
> 32 rows fetched
>
>> >>>> With version 08.04.0100 (wrong decimal truncation):
>
> SQL> select * from anamat.collezioni;
> +-----+---------------------+-----------------+------------- --------+--------------+---------+
> | coll| co_descr | co_coll_numerica| co_perc_magg_matrice|
> co_descr_abbr| cond_pag|
> +-----+---------------------+-----------------+------------- --------+--------------+---------+
> | 1 | Descr. non disponib.| 10 | 1 |
> PennyPull | RB10 |
> | 2 | Descr. non disponib.| 20 | 0 |
> PennyBlack | |
> | 3 | Descr. non disponib.| 30 | 0 |
> NewPenny | |
> | 4 | Descr. non disponib.| 40 | 0 |
> Classic | RB09 |
> | 5 | Descr. non disponib.| 50 | 0 | PB
> Plus | |
> | 6 | Descr. non disponib.| 60 | 0 |
> Active | |
> | 7 | Descr. non disponib.| 70 | 0 |
> Jeans & B. | |
> | 8 | Descr. non disponib.| 96 | 0 |
> Trend | |
> | 9 | Descr. non disponib.| 90 | 0 | F.
> Natale | |
> | A | Descr. non disponib.| 48 | 0
> | | RB09 |
> | B | Descr. non disponib.| 31 | 0 |
> Flash NP S | RB09 |
> | C | Descr. non disponib.| 32 | 0 |
> Flash NP C | RB09 |
> | E | Descr. non disponib.| 11 | 0 |
> Ins.P.Pull | |
> | F | Descr. non disponib.| 21 | 0 |
> Flash PB J | RB09 |
> | G | Descr. non disponib.| 22 | 0 |
> Flash PB G | RB09 |
> | H | Descr. non disponib.| 35 | 0 |
> Ins.N.Penn | |
> | I | Descr. non disponib.| 23 | 0 | F.
> PB Ant. | RB09 |
> | K | Descr. non disponib.| 28 | 0 |
> N.D. | |
> | L | Descr. non disponib.| 84 | 0 |
> FL | |
> | M | Descr. non disponib.| 24 | 0 |
> Flash PB M | RB09 |
> | N | Descr. non disponib.| 85 | 0 |
> Ins. NP | RB09 |
> | O | Descr. non disponib.| 26 | 0 |
> Saldi I. P | |
> | P | Descr. non disponib.| 98 | 0 |
> Pubblicit. | |
> | R | Descr. non disponib.| 99 | 0 |
> Prototipi | |
> | S | Descr. non disponib.| 25 | 0 |
> Ins. PB Ac | |
> | T | Descr. non disponib.| 45 | 0 |
> Fl. abiti | |
> | U | Descr. non disponib.| 46 | 0 |
> Chemises | |
> | V | Descr. non disponib.| 47 | 0 |
> Max&Co Acc | |
> | W | B2B by default | 91 | 0 |
> B2B by def | |
> | X | Descr. non disponib.| 61 | 0 |
> Ins. MaxCo | |
> | Y | Descr. non disponib.| 27 | 0 |
> Idee reg. | |
> | Z | Descr. non disponib.| 49 | 0 |
> DD | |
> +-----+---------------------+-----------------+------------- --------+--------------+---------+
> SQLRowCount returns 32
> 32 rows fetched


--------------090607020806010703090601
Content-Type: text/plain;
name="conv.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="conv.patch"

*** convert.c Wed Nov 18 01:11:06 2009
--- ../ver_8040100/convert.c Tue Nov 17 23:59:08 2009
***************
*** 1099,1105 ****
for (i = 0, j = 0; ptr[i]; i++)
if (ptr[i] == '.')
{
! strncpy_null(&new_string[j], lc->decimal_point, strlen(lc->decimal_point));
j += strlen(lc->decimal_point);
}
else
--- 1099,1105 ----
for (i = 0, j = 0; ptr[i]; i++)
if (ptr[i] == '.')
{
! strncpy_null(&new_string[j], lc->decimal_point, cbValueMax - j);
j += strlen(lc->decimal_point);
}
else

--------------090607020806010703090601
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

--------------090607020806010703090601--

Re: Undesired decimal truncation with psqlodbc version 08.04.0100

am 18.11.2009 12:00:29 von mcassiano

Hi Hiroshi,

I applied the patch and now I have the correct behaviour.
Thank you very much
Regards


Marco=20

------------------------------------------------------------ ---------------=
------------------


-----Original Message-----
From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]=20
Sent: Tuesday, November 17, 2009 5:17 PM
To: Cassiano, Marco
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Undesired decimal truncation with psqlodbc version 08.0=
4.0100

Hi Marco,

Marco Cassiano wrote:
> Hello everybody,
>
> during this weekend we upgraded our Postgres database from version 8.3.8=
=20
> to version 8.4.1.
> We also updated the odbc driver from version 08.03.0400 to version=20
> 08.04.0100.
> With this new version though, we observe an unwanted decimal truncation=
=20
> as you can see in the following example.
>
> I would need your help to understand the reason of this different,=20
> undesired behavior and how to fix it.

Please apply the attached patch.

regards,
Hiroshi Inoue

> Thank you
>
> Marco
>
> I attached the output from the same query on the same database made with=
=20
> the two drivers version:
>
>
>> >>>> With version 08.03.0400 (Correct decimal handling, see column=20
> "co_perc_magg_matrice", first row):
>
> SQL> select * from anamat.collezioni;
> +-----+---------------------+-----------------+------------- --------+----=
----------+---------+
> | coll| co_descr | co_coll_numerica| co_perc_magg_matrice|=20
> co_descr_abbr| cond_pag|
> +-----+---------------------+-----------------+------------- --------+----=
----------+---------+
> | 1 | Descr. non disponib.| 10 | 1.200 |=20
> PennyPull | RB10 |
> | 2 | Descr. non disponib.| 20 | 0.000 |=20
> PennyBlack | |
> | 3 | Descr. non disponib.| 30 | 0.000 |=20
> NewPenny | |
> | 4 | Descr. non disponib.| 40 | 0.000 |=20
> Classic | RB09 |
> | 5 | Descr. non disponib.| 50 | 0.000 | PB=
=20
> Plus | |
> | 6 | Descr. non disponib.| 60 | 0.000 |=20
> Active | |
> | 7 | Descr. non disponib.| 70 | 0.000 |=20
> Jeans & B. | |
> | 8 | Descr. non disponib.| 96 | 0.000 |=20
> Trend | |
> | 9 | Descr. non disponib.| 90 | 0.000 | F.=
=20
> Natale | |
> | A | Descr. non disponib.| 48 | 0.000 =
=20
> | | RB09 |
> | B | Descr. non disponib.| 31 | 0.000 |=20
> Flash NP S | RB09 |
> | C | Descr. non disponib.| 32 | 0.000 |=20
> Flash NP C | RB09 |
> | E | Descr. non disponib.| 11 | 0.000 |=20
> Ins.P.Pull | |
> | F | Descr. non disponib.| 21 | 0.000 |=20
> Flash PB J | RB09 |
> | G | Descr. non disponib.| 22 | 0.000 |=20
> Flash PB G | RB09 |
> | H | Descr. non disponib.| 35 | 0.000 |=20
> Ins.N.Penn | |
> | I | Descr. non disponib.| 23 | 0.000 | F.=
=20
> PB Ant. | RB09 |
> | K | Descr. non disponib.| 28 | 0.000 |=20
> N.D. | |
> | L | Descr. non disponib.| 84 | 0.000 |=20
> FL | |
> | M | Descr. non disponib.| 24 | 0.000 |=20
> Flash PB M | RB09 |
> | N | Descr. non disponib.| 85 | 0.000 |=20
> Ins. NP | RB09 |
> | O | Descr. non disponib.| 26 | 0.000 |=20
> Saldi I. P | |
> | P | Descr. non disponib.| 98 | 0.000 |=20
> Pubblicit. | |
> | R | Descr. non disponib.| 99 | 0.000 |=20
> Prototipi | |
> | S | Descr. non disponib.| 25 | 0.000 |=20
> Ins. PB Ac | |
> | T | Descr. non disponib.| 45 | 0.000 |=20
> Fl. abiti | |
> | U | Descr. non disponib.| 46 | 0.000 |=20
> Chemises | |
> | V | Descr. non disponib.| 47 | 0.000 |=20
> Max&Co Acc | |
> | W | B2B by default | 91 | 0.000 |=20
> B2B by def | |
> | X | Descr. non disponib.| 61 | 0.000 |=20
> Ins. MaxCo | |
> | Y | Descr. non disponib.| 27 | 0.000 |=20
> Idee reg. | |
> | Z | Descr. non disponib.| 49 | 0.000 |=20
> DD | |
> +-----+---------------------+-----------------+------------- --------+----=
----------+---------+
> SQLRowCount returns 32
> 32 rows fetched
>
>> >>>> With version 08.04.0100 (wrong decimal truncation):
>
> SQL> select * from anamat.collezioni;
> +-----+---------------------+-----------------+------------- --------+----=
----------+---------+
> | coll| co_descr | co_coll_numerica| co_perc_magg_matrice|=20
> co_descr_abbr| cond_pag|
> +-----+---------------------+-----------------+------------- --------+----=
----------+---------+
> | 1 | Descr. non disponib.| 10 | 1 |=20
> PennyPull | RB10 |
> | 2 | Descr. non disponib.| 20 | 0 |=20
> PennyBlack | |
> | 3 | Descr. non disponib.| 30 | 0 |=20
> NewPenny | |
> | 4 | Descr. non disponib.| 40 | 0 |=20
> Classic | RB09 |
> | 5 | Descr. non disponib.| 50 | 0 | PB=
=20
> Plus | |
> | 6 | Descr. non disponib.| 60 | 0 |=20
> Active | |
> | 7 | Descr. non disponib.| 70 | 0 |=20
> Jeans & B. | |
> | 8 | Descr. non disponib.| 96 | 0 |=20
> Trend | |
> | 9 | Descr. non disponib.| 90 | 0 | F.=
=20
> Natale | |
> | A | Descr. non disponib.| 48 | 0 =
=20
> | | RB09 |
> | B | Descr. non disponib.| 31 | 0 |=20
> Flash NP S | RB09 |
> | C | Descr. non disponib.| 32 | 0 |=20
> Flash NP C | RB09 |
> | E | Descr. non disponib.| 11 | 0 |=20
> Ins.P.Pull | |
> | F | Descr. non disponib.| 21 | 0 |=20
> Flash PB J | RB09 |
> | G | Descr. non disponib.| 22 | 0 |=20
> Flash PB G | RB09 |
> | H | Descr. non disponib.| 35 | 0 |=20
> Ins.N.Penn | |
> | I | Descr. non disponib.| 23 | 0 | F.=
=20
> PB Ant. | RB09 |
> | K | Descr. non disponib.| 28 | 0 |=20
> N.D. | |
> | L | Descr. non disponib.| 84 | 0 |=20
> FL | |
> | M | Descr. non disponib.| 24 | 0 |=20
> Flash PB M | RB09 |
> | N | Descr. non disponib.| 85 | 0 |=20
> Ins. NP | RB09 |
> | O | Descr. non disponib.| 26 | 0 |=20
> Saldi I. P | |
> | P | Descr. non disponib.| 98 | 0 |=20
> Pubblicit. | |
> | R | Descr. non disponib.| 99 | 0 |=20
> Prototipi | |
> | S | Descr. non disponib.| 25 | 0 |=20
> Ins. PB Ac | |
> | T | Descr. non disponib.| 45 | 0 |=20
> Fl. abiti | |
> | U | Descr. non disponib.| 46 | 0 |=20
> Chemises | |
> | V | Descr. non disponib.| 47 | 0 |=20
> Max&Co Acc | |
> | W | B2B by default | 91 | 0 |=20
> B2B by def | |
> | X | Descr. non disponib.| 61 | 0 |=20
> Ins. MaxCo | |
> | Y | Descr. non disponib.| 27 | 0 |=20
> Idee reg. | |
> | Z | Descr. non disponib.| 49 | 0 |=20
> DD | |
> +-----+---------------------+-----------------+------------- --------+----=
----------+---------+
> SQLRowCount returns 32
> 32 rows fetched=20


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc