Unicode escape codes

From: Chris Campbell <ccampbell(at)cascadeds(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Unicode escape codes
Date: 2010-10-08 15:52:03
Message-ID: 453A24085F801842AEA8D0B6B269065D301423FEEF@HDMC.cds.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi, using Postgres 9.0.1 on Windows 7/64bit

I run the following SQL statement through a data connection in .net.

Update data1.systeminfo SET aicompanyfile='C:\Users\Public\Documents\Intuit\QuickBooks\Company Files\acme_rockets.QBW'

The issue is that Postgres interprets the back slashes in the path name as escapes and errors out with "invalid unicode escape" Okay, I get it. Back slashes are symbols for escape codes.

So my question is, what options do I have other than "swapping out" the offending back-slash for some other character, then having to remember to swap it back after I fetch the table from the database? There must be a more elegant solution. I do use escapes in other calls so I can't eliminate the functionality completely.

Oh, apologies for switching gears, just fyi, I use the pgAdminIII program and after updating to 9.0.1 from 8.4.4, I noticed that calls to help (documentation) attempt to fetch it from its old 8.4 location and errors out (No big deal I manually updated the registry). Also, from pgAdminIII, if I select Help/EnterpriseDB help, it pulls up Advanced Server 8.3 documentation?

Thank you for any suggestions...

Chris Campbell
Cascade Data Solutions, Inc.
ccampbell(at)CascadeDS(dot)com
(800) 280-2090

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-10-08 16:41:49 Re: Unicode escape codes
Previous Message Josh Kupershmidt 2010-10-08 14:19:43 Re: PostgreSQL data types mapped Java classes for JDBC