Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page Properties
hiddentrue
idKB


ThemeDebug
Type

My House

Available from 


...

In the example above the '0x0B' is a non-printable escape character '\v' (also ASCII decimal character code 11). You will need to look at the individual fields within your PostgreSQL database to see which records contain the invalid character.

...

(note: The \v escape character as per the above select statement  ...E'\\v'...).

Once you have found the fields and records that contain the invalid character the invalid character(s) will need to be removed. The best option may be to ask the source data owner/ source database administrator to remove the invalid characters from the source data prior to being imported for use with iShare.

...