Thread: Bug when performing command SELECT without cast
Dear,
Good afternoon!
When executing a SELECT command using ODBC, my return is different from earlier versions.
Command: "SELECT '1058 ';"
Return:
Sorry for the picture in return, unable to copy the return because I think after each digit is returning me a null.
The test was performed in versions 9.03.0300 and 9.03.0100 and not worked properly in any.
Ernane Helder Rodrigues
Good afternoon!
When executing a SELECT command using ODBC, my return is different from earlier versions.
Command: "SELECT '1058 ';"
Return:
Sorry for the picture in return, unable to copy the return because I think after each digit is returning me a null.
The test was performed in versions 9.03.0300 and 9.03.0100 and not worked properly in any.
Ernane Helder Rodrigues
Attachment
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. What program are using to execute the SELECT? Also from what I see you are selecting a string with an empty space at the end, is that correct? > > The test was performed in versions 9.03.0300 and 9.03.0100 and not > worked properly in any. > > Ernane Helder Rodrigues -- Adrian Klaver adrian.klaver@aklaver.com
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 -- Adrian Klaver adrian.klaver@aklaver.com
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 > >
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;" -- Adrian Klaver adrian.klaver@aklaver.com
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.
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
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.klaver@aklaver.com