SUM: [postgis-users] Client encoding error

[Milo van der Linden]

Thank you Mark!

This was indeed the solution I needed!

Mark Cave-Ayland schreef:
>> PostGIS is in UTF-8, the table is in WindowsLatin1. How do I change the
>> encoding? Is it just a matter of editting the tab file and changing the
>> string WindowsLatin1 with UTF-8?
>>     
>
>
> Hi Milo,
>
> If your database is in UTF8 encoding then you can try to get PostgreSQL to
> do the conversion for you. A useful tip is that you can configure the
> default client encoding for a particular database user, e.g. in the case
> of user foo:
>
> ALTER USER foo SET client_encoding to LATIN1;
>
> Then re-connect to the database as foo to reload your data. Don't forget
> to swap the encoding back when you're done ;)
>
>
> HTH,
>
> Mark.
>
>
>
>   


-- 


	

Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
http://www.3dsite.nl

	  	

De informatie in dit bericht reflecteert mijn persoonlijke mening en
niet die van een bedrijf of instantie. Aan de informatie kunnen geen
rechten worden ontleend. Indien dit bericht onderdeel is van een forum,
mailing-list of community dan gelden automatisch de bij het betreffende
medium behorende voorwaarden. The information in this message reflects
my personal opinion and not that of a company or public body. All rights
reserved.If this message is contained in a mailing-list or community,
the rights on the medium are automatically adapted.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070816/b7427a01/attachment.html>