Databases
StackOverflow2013
Postsdbo
POPostgreSQL: nonstandard use of escape string
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPostgreSQL: nonstandard use of escape string
    primarykey
    data
    text
    <p>I have a PostgreSQL 8.4 database that is being queried by an application that is outside of my control. Queries such as the following are throwing warnings but are working...</p> <pre><code>SELECT "tagname","tagindex","tagtype","tagdatatype" FROM "tagtable" WHERE "tagname" = 'Lift_Stations\07\ETMs\Generator_ETM' </code></pre> <p>However, the same query for stations 08 and 09 are failing...</p> <pre><code>SELECT "tagname","tagindex","tagtype","tagdatatype" FROM "tagtable" WHERE "tagname" = 'Lift_Stations\08\ETMs\Generator_ETM' </code></pre> <blockquote> <p>WARNING: nonstandard use of escape in a string literal LINE 2: ...,"tagdatatype" FROM "tagtable" WHERE "tagname" = 'Lift_Stat... ^ HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.</p> <p>ERROR: invalid byte sequence for encoding "UTF8": 0x00 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".</p> <p><em><strong></em>***<em></strong> Error <strong></em>**<em>*</em></strong></p> <p>ERROR: invalid byte sequence for encoding "UTF8": 0x00 SQL state: 22021 Hint: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".</p> </blockquote> <p>I know the problem is incorrect escaping, but given the fact that 08 and 09 are the only ones not working, I'm hoping someone might have a bright idea on how to work around this.</p> <p>Thanks!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USdschulz
    1. USKevin Garman
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPostgreSQL: nonstandard use of escape string
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. CO`WHERE "tagname" = E'Lift_Stations\08\ETMs\Generator_ETM'` could help.
      singulars
      1. POPostgreSQL: nonstandard use of escape string
      1. USwildplasser
    2. COIf do not work wildplasser's solution, please try add another backslashes, for more information read [this link](http://stackoverflow.com/a/943/1563878).
      singulars
      1. POPostgreSQL: nonstandard use of escape string
      1. USGaston Flores
    3. CO@wildplasser I think that's a path, and they don't *want* it to be interpreted as escape sequences.
      singulars
      1. POPostgreSQL: nonstandard use of escape string
      1. USCraig Ringer
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload