*** ERROR: invalid byte sequence for encoding "UTF8": 0xc97

  • Hi all,


    a new error appears to me but i don't think to have change anything...


    When some Dicom tags as :

      0008,0090
      0008,1030
      0008,1048
      0032,1032
      0032,1060
      0040,0007
      0008,0104
      0010,1040


    contains some special caracters as : é, ç, à, etc... the error appears !!
    It is certainly an SQL encoding error but i don't see any issue.


    I have to make some ImportConverters to set then to ""


    Any idea ???


    Esteraph.

  • Hi Marcel,


    i always use Postgresql Database (V9.1.x)


    The conquest message error is :

    Code
    Thu Mar 6 11:22:32 2014 *** ERROR: invalid byte sequence for encoding "UTF8": 0xc970
    Thu Mar 6 11:22:32 2014 ***Error saving to SQL: 73_29652/1.3.46.670589.30.1.2.1.95595295115.1394101129312.1.dcm


    When i put some ImportConverters into the dicom.ini to put these tags to "" it is ok.
    But not always....
    I can't know before all the bad tags...


    Regards.

  • Effectively, it's a postgresql encoding problem.


    I'm tring to use :


    Code
    export PGCLIENTENCODING=LATIN1


    It's seems to be good...
    I'm going to test it a long time and come back to you...


    Thanks

  • Hi


    I had the same problem that UTF8 did not work.
    I did set the DB to Win1252 - which I thin is prettty much Latin1 - and the error was gone, However the DB needs to be rebuild/deleted to change the encoding. Stupid error

  • Hi all,


    i confirm that under linux (ubuntu server LTS) i have to do :

    Code
    export PGCLIENTENCODING=LATIN1


    before running dgate.


    The command :

    Code
    psql --list


    shows the encoding of database.
    My encoding is always UTF8 but sometimes (when meta dicom contains specials caracters), it crashes when PGCLIENTENCODING is not set to LATIN1.


    Perhaps the solution is not to create utf8 database !!! but latin1.
    Bye.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!