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"
On 20/06/2014 06:51 PM, Adrian Klaver wrote:
> On 06/20/2014 10:24 AM, Desenvolvimento wrote:
>> Dear,
>> Good afternoon!
>>
>> When executing a SELECT command using ODBC, my return is different from
>> earlier versions.
>>
>> Command: "SELECT '1058 ';"
>> Return: 1 0 5 8
>> Sorry for the picture in return, unable to copy the return because I
>> think after each digit is returning me a null.
>
> Meant to add, what OS are you working with and is it the same for both
> the client and the Postgres server?
>
>>
>> The test was performed in versions 9.03.0300 and 9.03.0100 and not
>> worked properly in any.
>>
>> Ernane Helder Rodrigues
>
>