[Gambas-user] help with data import into postgres - funny characters> import fails

richard terry rterry at ...1946...
Fri Feb 27 02:57:55 CET 2009


Hi ,

I'm trying to import the hl7 from a local radiology provider:
It's got funny characters in the file and postgres baulks when I go to save 
the line with the message attatched, but it basically says - invalid byte 
sequence for encoding UTF8.

My postgres database is created with UTF8 encoding

CREATE DATABASE "27Feb09"
  WITH OWNER = richard
       ENCODING = 'UTF8';

snipped is the offending bit:

with a maximum AP diameter\.br\of 1.0cm and a less than 50% stenosis in its 
proximal segment.  \.br\\.br\Continued�����/2\.br\In the mid superficial 
femoral artery there is staccato flow and an 

I've imported thousands and thousands of lines from a pathology provider  and 
never encountered these characters.

Thanks in anticipation.




More information about the User mailing list