From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Desenvolvimento <ernane(at)planit(dot)com(dot)br>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Bug when performing command SELECT without cast |
Date: | 2014-06-24 14:33:02 |
Message-ID: | 53A98C1E.6010307@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 06/24/2014 07:22 AM, Desenvolvimento wrote:
>
> ON 24/06/2014 10:59 AM, Adrian Klaver wrote:
>> On 06/24/2014 04:40 AM, Desenvolvimento wrote:
>>> I'm working with OS Windows 8.1 Pro 64-bit and my server is:
>>> Linux - Cent-OS
>>> PostgreSQL 8.4.21 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
>>> 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
>>>
>>> About the empty space, the correct string is:
>>> "SELECT '1058';" -- Without space.
>>>
>>> If I cast it, the return will be:
>>> "SELECT '1058'::char(4);"
>>> Return: "1058"
>>
>>
>> In what program are you doing the above?
>>
>> What happens if you do?:
>>
>> "SELECT 1058;"
>>
>>
>>
>
> I'm using Microsoft Visual FoxPro 9.0 SP2 with driver "PostgreSQL UNICODE".
> When I execute "SELECT 1058;" my return is "1058" type numeric.
>
There was a previous thread about VFP and text/string issues(warning it
is long and not resolved):
As near as I could figure VFP and ODBC are not always in agreement on
what is the correct type for a string. I have to run now but I will take
another look when I get a chance.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-06-24 17:30:14 | Re: Bug when performing command SELECT without cast |
Previous Message | Desenvolvimento | 2014-06-24 14:22:08 | Re: Bug when performing command SELECT without cast |