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.
>

Is the encoding for your database Unicode?

Have you done this?:

http://www.west-wind.com/webconnection/wwClient_docs/_1F00WW3PB.htm

If not have you tried the ANSI driver?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com