From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | <trainee12(at)yeah(dot)net>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Bug #869: varchar 's comparision |
Date: | 2003-01-10 04:34:08 |
Message-ID: | 20030109203113.B656-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, 9 Jan 2003 pgsql-bugs(at)postgresql(dot)org wrote:
> trainee (trainee12(at)yeah(dot)net) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> varchar 's comparision
>
> Long Description
> SERVER: PGSQL 7.31 + MANDRAKE LINUX 8.1
> CLIENT: VISIVAL FOXPRO 7.0 + PGSQLODBC 7.02
>
> TABLE : MYTABLE
> M_ID VARCHAR(10) M_DESC VARCHAR(10)
> -----------------------------------------------------------
> ABC HELLO
>
> I create a romate view in vfp, when I modify "m_desc" from "HELLO"
> TO "GOOD" ,and update table, vfp trigger a error "UPDATE CONFLICT".
>
> In odbc-log: (THIS SQL SYNTAX IS GENERATED BY VFP )
> ---------------------------------------------------------------
> UPDATE MYTABLE SET M_DESC='GOOD' WHERE M_ID='ABC ' AND M_DESC='HELLO '
varchar() considers trailing spaces as significant, so 'ABC'!='ABC '
If it's going to generate values with trailing spaces, you might want to
use char() instead.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-10 04:45:52 | Re: Bug #869: varchar 's comparision |
Previous Message | pgsql-bugs | 2003-01-10 03:24:04 | Bug #869: varchar 's comparision |