Funny odbc + MS odbc.net behaviour. - Mailing list pgsql-odbc

From Ivar
Subject Funny odbc + MS odbc.net behaviour.
Date
Msg-id bdf3dr$mqb$1@main.gmane.org
Whole thread Raw
List pgsql-odbc
Hi,

I have funny odbc (unicode) + MS odbc.net data provider behaviour, it's hard
to explain but I'll try.

Table structure which causes error:

CREATE TABLE test (
 nimetus varchar(20) NOT NULL,
 hind decimal(18,5) NOT NULL
);

Data in table

insert into test values('vvv vvvX',3); - X is char(382), Z with ROOF. Other
unicode chars provide same result. Eg. russian 'k'.

I have table with following row. I just make select * from test with
odbc.net provider and 'Input string isn't in a correct format' error is
arised.

Now funn begins:
If to change column 'hind' to decimal(18.3) - all works ok.

If to change row value from 'vvv vvvX',3  to vvvX,3 or vX,3 or v vvvX,3
... - all works ok.
(It's important that value is
char_char_cahr_space_char_char_char_UnicodeChar to get error, but not all
unicode chars won't fit)

Now I thought that's MS odbc.net provider bug, but to make same table with
same values to ms sql server using ms sql server odbc driver, all works ok.

pgsql 7.3.1 on windows + latest odbc driver

Have anybody some idea or suggestions ?




begin 666 bug2.sql
M[[N_#0H-"D-214%412!404),12!T97-T("@-"@EN:6UE='5S('9A<F-H87(H
M,C I($Y/5"!.54Q,+ T*"6AI;F0@9&5C:6UA;"@Q."PU*2!.3U0@3E5,3 T*
M*3L-"@T*#0II;G-E<G0@:6YT;R!T97-T('9A;'5E<R@G=G9V('9V=L6^)RPS
$*3L-"@``
`
end


pgsql-odbc by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Client software vs cursor problem?
Next
From: Jeffrey Bohmer
Date:
Subject: Re: Is psqlodbc driver 7.03.0100 thread safe?