From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1000687 ] Problem with WHERE and upercase character |
Date: | 2006-07-19 13:09:15 |
Message-ID: | 20060719130915.AC24986C5B5@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Bugs item #1000687, was opened at 2006-07-19 13:09
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000687&group_id=1000125
Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Problem with WHERE and upercase character
Initial Comment:
Hello,
i use odbc 8.2.2 and PG 8.1.4 with LATIN9 in Windows XP Sp2.
I have a table named TEXTE with two Cols named TEXTTYP Varchar(50) and TEXTZEILE varchar(255)
Inside are rows like
ANSP.xxx , "Any chars"
ANSP.George , "Director"
...
When i have
update TEXTE set TEXTZEILE = 'abc' where TEXTTYP='ANSP.xxx' and TEXTZEILE = 'Any chars'
i get the one row and it is OK.
When i have
update TEXTE set TEXTZEILE = 'abc' where TEXTTYP='ANSP.George' and TEXTZEILE = 'Director'
i get no row and no update is done
The difference is the uppercase G in ANSP.George
When i have
update TEXTE set TEXTZEILE = 'abc' where TEXTTYP='ANSP.George'
i get the row(s) and the update is done.
I need both in the where clause.
I tested it with some other data.
every time i have a uppercase letter after the dot, it dont work.
What will that be?
Thanks
Paul
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000687&group_id=1000125
From | Date | Subject | |
---|---|---|---|
Next Message | Antoine | 2006-07-19 19:46:53 | Re: postgre connection via odbc |
Previous Message | 王宝兵 | 2006-07-19 06:44:42 | Does psqlodbc support declare/fetch in Un ux? |