[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-devel
Subject:    [postgis-devel] Fwd: Invalid Byte Sequence Error when using st_bandpath
From:       Tumasgiu Rossini <rossini.t () gmail ! com>
Date:       2016-05-17 8:00:39
Message-ID: CAJD9AWzBrpyP=Xzh_J-bMDjUsu09gjhPUV2e2o9MgVG_F_eMNA () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hello list,

I came across an error using st_bandpath,
When using PostgreSQL binary output format, executing the function on
rasters registered with UNC paths fails with error message :

"22021: invalid byte sequence for encoding =C2=AB WIN1252 =C2=BB : 0x00"

When using Text mode, the functions works correctly.

My guess is that the first character of a UNC path which is a
backslash is considered as an escape sequence.
But it seems you can't escape the first two backslashes when
using raster2pgsql (tried \\\\, /\/\, doublequoted path and
every combination of these three).

My configuration :
Windows 7
Postgres 9.3.5
Postgis 2.1.3
Database using WIN1252 Encoding and French_France.1252 collate.
Client encoding : UTF-8

Thank for reading.

[Attachment #5 (text/html)]

<div dir="ltr">Hello list,<br><div class="gmail_quote"><div dir="ltr"><div><br>I came \
across an error using st_bandpath,<br>When using PostgreSQL binary output format, \
executing the function on<br>rasters registered with UNC paths fails with error \
message :<br><br>&quot;22021: invalid byte sequence for encoding  « WIN1252  » : \
0x00&quot;<br><br>When using Text mode, the functions works correctly.<br><br>My \
guess is that the first character of a UNC path which is a<br>backslash is considered \
as an escape sequence.<br>But it seems you can&#39;t escape the first two backslashes \
when<br>using raster2pgsql (tried \\\\, /\/\, doublequoted path and<br>every \
combination of these three).<br><br>My configuration :<br>Windows 7<br>Postgres \
9.3.5<br>Postgis 2.1.3<br>Database using WIN1252 Encoding and French_France.1252 \
collate.<br>Client encoding : UTF-8<br><br></div>Thank for reading.<br></div> \
</div><br></div>


[Attachment #6 (text/plain)]

_______________________________________________
postgis-devel mailing list
postgis-devel@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-devel

[prev in list] [next in list] [prev in thread] [next in thread]