[ psqlodbc-Bugs-1000687 ] Problem with WHERE and upercase character

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=10006 87&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=10006 87&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly