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-24 10:44:00 |
Message-ID: | 20060724104400.62CF386C57D@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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=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
----------------------------------------------------------------------
>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=1000687&group_id=1000125
From | Date | Subject | |
---|---|---|---|
Next Message | Hu, Ming (Ivan) | 2006-07-24 10:48:49 | Re: Why SQLBindCol can not get back the c string length. |
Previous Message | Ludek Finstrle | 2006-07-24 09:06:41 | Re: Why SQLBindCol can not get back the c string length. |