<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>I have a problem transfering a table from oracle to postgresql (post-gis).</DIV>
<DIV>The Oracle table contain a field of type varchar2(250 byte) and when i try to load the table i get the error "ORA-01406: fetched column value was truncated. " I tryed with field of type varchar2(250 char) and i got the same erreor. </DIV>
<DIV> </DIV>
<DIV>In many records of the table, this field is filled with 250 character, including line breaks and special characters. To solve the problem, i created a new table on oracle with the varchar2(250 byte) field changed for a varchar2(500) and the data loaded correctly. Then, I altered the table on postgresql and changed the field type from varchar(500) to varchar(250) and it works. My conclusion is that there is no problem with the data but the loading is not working well. Is there something i can do or set to avoid this problem. </DIV>
<DIV> </DIV>
<DIV>Regards.</DIV></BODY></HTML>