Re: Bug when performing command SELECT without cast

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):

http://www.postgresql.org/message-id/152de38c9c2544b9b61f9a2f77e9aa3d@BY2PR08MB281.namprd08.prod.outlook.com

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.klaver@aklaver.com