problem to save german umlaute part 2

[Tonigs, Nils]

Hello,

with

...
on AddSomeRecsViaVCursor( inDB )
  
  l_str_sql = "SELECT * FROM binaryData WHERE false"
  
  l_o_VCursor = inDB.sqlSelect(l_str_sql, #kServerSide, #kReadWrite, #kRandom)
  
  l_int_asdasasas = l_o_VCursor.fieldCount
  repeat with i = 1 to l_int_asdasasas
    
    put( "feld " & i & " : " & l_o_VCursor.field[ i ].name & " enthält " & l_o_VCursor.field[ i ].value )  
    
  end repeat
  put( "cursor enthält " & l_o_VCursor.recordCount & " einträge" )
  l_o_VCursor.Field( "mediaTitle" ).value = "test1"
  fldPict = l_o_VCursor.field("binary_media")
  fldPict.setBlank()
  fldPict.setMedia(member("test1",1))
  l_o_VCursor.field( "filename_orig" ).value = "test1a"
  newRec = l_o_VCursor.addRecord()
  
  --if( _movie.CheckValError() )then 
  SWtrace( "Fehler beim addRec in VCursor " & CheckValError() )
  --end if
  put( "cursor enthält " & l_o_VCursor.recordCount & " einträge" )
  
  l_o_VCursor.Field( "mediaTitle" ).value = "test2ÄÖÜ"
  fldPict = l_o_VCursor.field("binary_media")
  fldPict.setBlank()
  fldPict.setMedia(member("test2",1))
  l_o_VCursor.field( "filename_orig" ).value = "test2aÄÜÖ"
  newRec = l_o_VCursor.addRecord()
  
  --if( _movie.CheckValError() )then 
  SWtrace( "Fehler beim addRec in VCursor " & CheckValError() )
  --end if
  put( "cursor enthält " & l_o_VCursor.recordCount & " einträge" )
  l_o_VCursor.Field( "mediaTitle" ).value = "test3"
  fldPict = l_o_VCursor.field("binary_media")
  fldPict.setBlank()
  fldPict.setMedia(member("test3",1))
  l_o_VCursor.field( "filename_orig" ).value = "test3a"
  newRec = l_o_VCursor.addRecord()
  
  --if( _movie.CheckValError() )then 
  SWtrace( "Fehler beim addRec in VCursor " & CheckValError() )
  --end if
  put( "cursor enthält " & l_o_VCursor.recordCount & " einträge" )
  
  inDB.flush()
  
end AddSomeRecsViaVCursor
...

it is the same. I test it also with field-type "Text". Without any success.


Best regards,

Nils Tonigs

Audiovisuelles Medienzentrum

Medizinische Fakultät der RWTH Aachen

Pauwelsstr. 30

52074 Aachen

 

Tel.: +49-(0)241-80-89035

Fax: +49-(0)241-80-82561

E-Mail: ntonigs at ukaachen.de