> On Feb 22, 2017, at 9:49 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: > > On 02/22/2017 07:32 AM, Jerry LeVan wrote: >> >>> On Feb 22, 2017, at 9:20 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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 to the 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@xxxxxxxxxxx >> >> > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
