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

Bugs item #1000687, was opened at 2006-07-19 15: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

------------------------------------------------------------ ----------

>Comment By: Ludek Finstrle (luf)
Date: 2006-07-24 12:44

Message:
Hello,

could you try the update directly via psql or pgadmin?
If it doesn't fail there please send me the mylog output.

Regards,

Luf

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10006 87&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend