InterRob a écrit :
>> Arnaud Lesauvage a écrit :
>> Also, doing a search like :
>> SELECT * FROM mytable WHERE upper(myflied) ILIKE u&'%c29f%';
>> Gives me 0 result.
>> Am I wrong to think that the error 'character 0xc29f of UTF8' relates
>> to the character with code point C29F in UTF8 ?
>
I wou
I would do this last query searching for the 0xC29F character WITHOUT the
upper() function on the source table, in the native (to table) UTF8 client
encoding. No result either?
Rob
2009/10/16 Arnaud Lesauvage
> Arnaud Lesauvage a écrit :
>
>> But then, if I dump it through a query to have my fi
Arnaud Lesauvage a écrit :
But then, if I dump it through a query to have my field in uppercase, I
get an error 'character 0xc29f of encoding UTF8 has no equivalent in
WIN1252' (translated by myself, the message is in French)
The command is simply :
pgsql2shp -f myouput.shp -u postgres -g mygeo
Raymond O'Donnell a écrit :
If it's any help to you, you can get iconv (and a bunch of other helpful
stuff) from GnuWin32:
http://gnuwin32.sourceforge.net/
Thanks for your help Raymond.
I tried iconv but I have other problems now.
I still have to load the file into postgresql because the sh
On 16/10/2009 10:36, Arnaud Lesauvage wrote:
> I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
> database. I want my shapefile to be encoded in WIN1252, and a particular
> field to be in uppercase.
>
> Since I am on windows, I don't have an iconv executable. Therefore, I am
Hi all!
I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
database. I want my shapefile to be encoded in WIN1252, and a particular
field to be in uppercase.
Since I am on windows, I don't have an iconv executable. Therefore, I am
trying to :
- dump the shapefile with shp
