Re: [GENERAL] Strange Errors... - Mailing list pgsql-general

> On Feb 22, 2017, at 10:08 AM, Jerry LeVan <jerry.levan@gmail.com> wrote:
>
>>
>> On Feb 22, 2017, at 9:49 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> On 02/22/2017 07:32 AM, Jerry LeVan wrote:
>>>
>>>> On Feb 22, 2017, at 9:20 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>>>
>>>> On 02/22/2017 07:09 AM, Jerry LeVan wrote:
>>>>> Sorry I accidentally posted this to pgsql-general-owners earlier today…
>>>>> ********
>>>>> How can this happen ( from the postgresql.log file)
>>>>>
>>>>> LOG:  statement: select * from knives where manufacturer=‘Boker’
>>>>> ERROR:  column "‘boker’" does not exist at character 41
>>>>>
>>>>> Some background:
>>>>> I am trying to move from 32 bit apps to 64 bit apps. I still
>>>>> have a couple of 32 bit apps that talk to postgresql.
>>>>>
>>>>> env:
>>>>> MacOS Sierra 10.12.3
>>>>>
>>>>> postgresql 9.6.2 compiled as a 64 bit program. I also
>>>>> compiled it as a 32 bit program and glued the 64 bit
>>>>> and 32 bit libpq libraries together and replaced the
>>>>> installed 64 bit libpq library with the fat version.
>>>>>
>>>>> python 2.7.10 Apple’s version
>>>>>
>>>>> psycopg2 2.6.1
>>>>>
>>>>> wxpython '3.0.3.0.b20160914’ installed from the wxpython.org site.
>>>>>
>>>>> My main interaction with my database is a wxpython app. I type
>>>>> sql into a text window and can send the contents of the window
>>>>> or the selection or the line containing the cursor to postgresql
>>>>>
>>>>> It appears that every single quote ( ‘ ) gets translated somehow to
>>>>
>>>> No:
>>>>
>>>> test=# select ‘Boker’;
>>>> ERROR:  column "‘boker’" does not exist
>>>> LINE 1: select ‘Boker’;
>>>>
>>>> test=# select 'Boker';
>>>> ?column?
>>>> ----------
>>>> Boker
>>>> (1 row)
>>>>
>>>> It is because they are ‘ ’ not ' '.
>>>>
>>>> So you need to find out what is causing your program to introduce ‘ ’.
>>>
>>> The mail program is displaying the straight quote as a curly quote…
>>> In the terminal program I see a straight quote.
>>>
>>> Perhaps wxpython is somehow confusing things… tain’t clear on
>>> how to test.
>>
>> I have seen this issue when I cut and pasted data from word processing/spreadsheet programs and not paid attention
tothe fact they have settings that convert ' --> ’ and ''  --> ‘‘ ’’. 
>>
>>>
>>>>
>>
> I think you may be on to something….If I how down the straight quote in the text window for a few seconds I can see a

> ripple of changes to a different character when I release the key. If I zoom the terminal window displaying
> the log file the quote is clearly not the ‘straight’ quote.
>>>>
>>>> --
>>>> Adrian Klaver
>>>> adrian.klaver@aklaver.com
>>>
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com

There is a setting in the Mac System Preferences that will allow you to turn
off smart quotes.

I did this and the program is acting properly once more :)

Thanks for the tip.

Jerry