shapefile to postgis

[Anonymous]

hi,
i use Talend TOS 6.11 and i've installed spatial extension (TOS-spatial-36.0.1)
i have to load a shapefile to postgis, but my shapefile is encoded in utf8 (like in .cpg) and it seems sShapefileInput is working only with "latin1" encodage (it's the standard for shapefile encoding ...)
there is a solution ? i think to use some postgis utility like shp2pgsql, but it's not an ideal solution for me
another question : some functions are deprecated for postgresql (like geomfromtext wihich is prefixed now in st_geomfromtext in postgis extension) ; for that, we have to install old legacy.sql in spatial database ... and i don't think it is a good thing : there is another solution ?
regards
fred

[Anonymous]

Hi Fred,
You're right about charset, I created an issue about that https://github.com/talend-spatial/talend-spatial/issues/69 but I've no resource to work on it. Another option would be to test what sOgrInput provides ?
HTH.
Francois

[Anonymous]

Thanks François
regards
fred