problem to save german umlaute

Tonigs, Nils ntonigs at ukaachen.de
Tue Nov 10 09:04:27 CST 2009 

Hi Ruslan,

a new approach to save german umlaute with DIR11.5, V4MD 4.3 and Valentina Office Server 4.2:

this lingoscript (from a test-movie) save some textstrings from textmembers to a db. The field-type is set to VarChar[2044] and string[2044].

...
on AddSomeRecords( inDB )

  tempTextMember1 = _movie.newMember( #text )
  tempTextMember1.font = "Arial Unicode MS *"
  tempTextMember1.text = "Diese Häcke in Übergröße"

  tempTextMember2 = _movie.newMember( #text )
  tempTextMember2.font = "Arial Unicode MS *"
  tempTextMember2.text = "Höhren fällt schwer."

  tempTextMember3 = _movie.newMember( #text )
  tempTextMember3.font = "Arial Unicode MS *"
  tempTextMember3.html = "Tästtäckst 3"

  tblBinaryData = inDB.table("binaryData")

  tblBinaryData.lastRecord()

  tblBinaryData.field( "mediaTitle" ).value = "ätest1ö"
  fldPict = tblBinaryData.field("binary_media")
  fldPict.setBlank()
  fldPict.setMedia(member("test1",1))
  tblBinaryData.field( "filename_orig" ).value = tempTextMember1.html
  newRec = tblBinaryData.addRecord()

  tblBinaryData.nextRecord()

  sjhdkjshd = [ member(26).html ] -- textmember with content "Wäärthers üchte! "
  tblBinaryData.field( "mediaTitle" ).value = sjhdkjshd[ 1 ]
  --tblBinaryData.field( "mediaTitle" ).setString( "ätest2ö" )
  fldPict = tblBinaryData.field("binary_media")
  fldPict.setBlank()
  fldPict.setMedia(member("test2",1))
  tblBinaryData.field( "filename_orig" ).value = "Höäü ÜÖÄ !!??ßß[]" -- tempTextMember2.html
  tblBinaryData.addRecord()

  tblBinaryData.nextRecord()

  tblBinaryData.field( "mediaTitle" ).value = tempTextMember3.html
  fldPict = tblBinaryData.field("binary_media")
  fldPict.setBlank()
  fldPict.setMedia(member("test3",1))
  tblBinaryData.field( "filename_orig" ).value = tempTextMember3.html
  tblBinaryData.addRecord()

end
...

The addRecord() change " Wäärthers üchte!" to " Wäärthers üchte!" !!

After correcting the german umlaute with valentine studio, the strings are display at the right way.
The storage encoding ist set to UTF-16 (field, table, database).
For ioEncoding the valentine-xtra use UTF-8, of course DIR11 use UTF-8.

My DIR MX movies use ISO-8859-1. At this movies german umlaute where save fine (with the same database!).

At the office server logs I can find different settings for connection encoding. Here are some selected log-extractions:

10:10:19.032961 (1113004944): (18) Database 'mawiba' object memory released.
 10:10:19.049654 (1110903696): Closing connection (18). ( Connections available: 'unlimited')
 10:10:19.104150 (1113004944): Connection established with '94.220.244.60:2341' (18). ( Connections available: 'unlimited')
 10:10:19.139230 (1104599952): (18) User: KDnupxv8Orr. Connection encoding: Latin-1 - LittleEndian.
 10:10:19.173786 (1110903696): (18) Database '(null)' remoteID 158181912 registered.
 10:10:19.173824 (1110903696): (18) Database: <none>; User: KDnupxv8Orr: OK
 10:10:19.207842 (1113004944): (18) Database 'mawiba' put_Location.
 10:10:19.225191 (1110903696): (18) Database '(null)' remoteID 158181912 unregistered.
 10:10:19.225240 (1110903696): (18) Database 'mawiba.vdb' remoteID 158181912 registered.
 10:10:19.225382 (1110903696): (18) Database 'mawiba' has been successfully opened.
 10:10:19.493311 (1104599952): (18) Database 'mawiba' has been successfully closed.
 10:10:19.510434 (1113004944): (18) Database: mawiba; User: KDnupxv8Orr: OK
 10:10:19.527764 (1110903696): (18) Database 'mawiba.vdb' remoteID 158181912 unregistered.
 10:10:19.527793 (1110903696): (18) Closing database 'mawiba': OK

11:43:19.483677 (1110903696): Closing connection (18). ( Connections available: 'unlimited')
 11:43:19.544112 (1104599952): Connection established with '94.220.244.60:2848' (18). ( Connections available: 'unlimited')
 11:43:19.578907 (1106701200): (18) User: KDnupxv8Orr. Connection encoding: Latin-1 - LittleEndian.
 11:43:19.613095 (1110903696): (18) Database '(null)' remoteID 158495024 registered.
 11:43:19.613132 (1110903696): (18) Database: <none>; User: KDnupxv8Orr: OK
 11:43:19.646570 (1104599952): (18) Database 'mawiba' put_Location.
 11:43:19.663312 (1110903696): (18) Database '(null)' remoteID 158495024 unregistered.
 11:43:19.663363 (1110903696): (18) Database 'mawiba.vdb' remoteID 158495024 registered.
 11:43:19.663502 (1110903696): (18) Database 'mawiba' has been successfully opened.
 11:43:19.819702 (1104599952): (18) Database 'mawiba' has been successfully closed.

07:57:44.301158 (1108802448): Connection established with '10.159.16.20:1181' (18). ( Connections available: 'unlimited')
 07:57:44.302407 (1104599952): (18) User: KDnupxv8Orr. Connection encoding: UTF-8 - LittleEndian.
 07:57:44.316001 (1110903696): (18) Database '(null)' remoteID 158437496 registered.
 07:57:44.316038 (1110903696): (18) Database: <none>; User: KDnupxv8Orr: OK
 07:57:44.322650 (1108802448): (18) Database 'mawiba' put_Location.
 07:57:44.322922 (1110903696): (18) Database '(null)' remoteID 158437496 unregistered.
 07:57:44.322981 (1110903696): (18) Database 'mawiba.vdb' remoteID 158437496 registered.
 07:57:44.323193 (1110903696): (18) Database 'mawiba' has been successfully opened.
 07:57:46.761352 (1108802448): (18) Database 'mawiba' has been successfully closed.
 07:57:46.774904 (1110903696): Closing connection (18). ( Connections available: 'unlimited')

 09:57:32.863061 (1104599952): Connection established with '10.159.16.20:1402' (18). ( Connections available: 'unlimited')
 09:57:32.863924 (1106701200): (18) User: KDnupxv8Orr. Connection encoding: UTF-8 - LittleEndian.
 09:57:32.887825 (1113004944): (18) Database '(null)' remoteID 157968840 registered.
 09:57:32.887862 (1113004944): (18) Database: <none>; User: KDnupxv8Orr: OK
 09:57:32.900054 (1104599952): (18) Database 'mawiba' put_Location.
 09:57:32.900335 (1113004944): (18) Database '(null)' remoteID 157968840 unregistered.
 09:57:32.900385 (1113004944): (18) Database 'mawiba.vdb' remoteID 157968840 registered.
 09:57:32.900509 (1113004944): (18) Database 'mawiba' has been successfully opened.
 09:57:33.041912 (1106701200): (18) Database 'mawiba' has been successfully closed.
 09:57:33.063918 (1104599952): Closing connection (18). ( Connections available: 'unlimited')
 10:03:29.705083 (1106701200): Connection established with '10.159.16.20:1405' (18). ( Connections available: 'unlimited')
 10:03:29.706284 (1110903696): (18) User: bCs5G33Ae. Connection encoding: UTF-16 - LittleEndian.
 10:03:29.709665 (1108802448): (18) SqlConnection object created.
 10:03:29.766483 (1106701200): (18) Database '(null)' remoteID 158822464 registered.
 10:03:29.766522 (1106701200): (18) Database: <none>; User: bCs5G33Ae: OK
 10:03:29.766917 (1108802448): (18) Database 'mawiba' put_Location.
 10:03:29.767172 (1110903696): (18) Database '(null)' remoteID 158822464 unregistered.
 10:03:29.767226 (1110903696): (18) Database 'mawiba.vdb' remoteID 158822464 registered.
 10:03:29.767429 (1110903696): (18) Database 'mawiba' has been successfully opened.
 10:03:29.767685 (1106701200): (18) Database: mawiba; User: bCs5G33Ae: OK
 10:03:29.768470 (1108802448): (18) Database '(null)' remoteID 158822592 registered.
 10:03:29.768504 (1108802448): (18) Database: <none>; User: bCs5G33Ae: OK
 10:03:29.768862 (1110903696): (18) Database 'sw4testDB' put_Location.
 10:03:29.769113 (1106701200): (18) Database '(null)' remoteID 158822592 unregistered.
 10:03:29.769160 (1106701200): (18) Database 'sw4testDB.vdb' remoteID 158822592 registered.
 10:03:29.769341 (1106701200): (18) Database 'sw4testdb' has been successfully opened.
 10:03:29.776651 (1106701200): (18) Database 'sw4testdb' get_Location.
 10:03:29.776947 (1108802448): (18) Database 'mawiba' get_Location.
 10:03:31.020925 (1108802448): (18) Table 'object_type' remoteID 157326704 registered.
 10:03:31.021238 (1110903696): (18) Field 'RecID' remoteID 157326832 registered.
 10:03:31.021285 (1110903696): (18) Field 'OID' remoteID 157326936 registered.
 10:03:31.021318 (1110903696): (18) VString 'obj_type_name' remoteID 157327040 registered.
 10:03:31.021355 (1110903696): (18) ObjectPtr 'mod_id' remoteID 157327184 registered.
 10:03:31.021382 (1110903696): (18) Field 'menuindex' remoteID 157327368 registered.
 10:03:31.022618 (1106701200): (18) Table 'objects' remoteID 157327472 registered.
 10:03:31.022889 (1108802448): (18) Field 'RecID' remoteID 157327600 registered.
 10:03:31.022929 (1108802448): (18) Field 'OID' remoteID 157327704 registered.
 10:03:31.022962 (1108802448): (18) ObjectPtr 'obj_type_id' remoteID 157327808 registered.
 10:03:31.022993 (1108802448): (18) VString 'content' remoteID 157327992 registered.
 10:03:31.023021 (1108802448): (18) Field 'date1' remoteID 157328136 registered.
 10:03:31.023047 (1108802448): (18) Field 'date2' remoteID 157328240 registered.
 10:03:31.023074 (1108802448): (18) Field 'bool1' remoteID 157328344 registered.
 10:03:31.023099 (1108802448): (18) Field 'bool2' remoteID 157328448 registered.
 10:03:31.023124 (1108802448): (18) Field 'released' remoteID 157328552 registered.
 10:03:31.023153 (1108802448): (18) Field 'timestamp' remoteID 157328656 registered.
 10:03:31.023186 (1108802448): (18) ObjectPtr 'module_id' remoteID 157328760 registered.
 10:03:31.023213 (1108802448): (18) Field 'menuindex' remoteID 157329032 registered.
 10:03:31.023238 (1108802448): (18) Field 'edit' remoteID 157329136 registered.
 10:03:31.026192 (1106701200): (18) Table 'obj_relations' remoteID 157329240 registered.
 10:03:31.026466 (1108802448): (18) Field 'RecID' remoteID 157329368 registered.
 10:03:31.026500 (1108802448): (18) Field 'OID' remoteID 157329472 registered.
 10:03:31.026535 (1108802448): (18) ObjectPtr 'rel_obj_id' remoteID 157329576 registered.
 10:03:31.026568 (1108802448): (18) ObjectPtr 'parent_id' remoteID 157329760 registered.
 10:03:31.026595 (1108802448): (18) Field 'rel_cat' remoteID 157329944 registered.
 10:03:31.026620 (1108802448): (18) Field 'evid_prop' remoteID 157330048 registered.
 10:03:31.027782 (1110903696): (18) Table 'attribute_type' remoteID 157330152 registered.
 10:03:31.028050 (1106701200): (18) Field 'RecID' remoteID 157330280 registered.
 10:03:31.028096 (1106701200): (18) Field 'OID' remoteID 157330384 registered.
 10:03:31.028129 (1106701200): (18) VString 'attribute_type_name' remoteID 157330936 registered.
 10:03:31.028159 (1106701200): (18) Field 'menuindex' remoteID 157331080 registered.
 10:03:31.028185 (1106701200): (18) Field 'released' remoteID 157331184 registered.
 10:03:31.029400 (1108802448): (18) Table 'attribute' remoteID 157331288 registered.
 10:03:31.029674 (1110903696): (18) Field 'RecID' remoteID 157331416 registered.
 10:03:31.029713 (1110903696): (18) Field 'OID' remoteID 157331520 registered.
 10:03:31.029749 (1110903696): (18) ObjectPtr 'attr_type_id' remoteID 157331624 registered.
 10:03:31.029781 (1110903696): (18) ObjectPtr 'obj_id' remoteID 157331808 registered.
 10:03:31.029807 (1110903696): (18) Field 'needed' remoteID 157331992 registered.
 10:03:31.029837 (1110903696): (18) VString 'datatyp' remoteID 157332096 registered.
 10:03:31.029865 (1110903696): (18) Field 'display' remoteID 157332240 registered.
 10:03:31.029910 (1110903696): (18) VString 'attribute_name' remoteID 157332344 registered.
 10:03:31.029939 (1110903696): (18) Field 'menuindex' remoteID 157332488 registered.
 10:03:31.029965 (1110903696): (18) Field 'edit' remoteID 157332592 registered.
 10:03:31.029996 (1110903696): (18) ObjectPtr 'binary_id' remoteID 157332696 registered.
 10:03:31.030026 (1110903696): (18) VString 'attribute_value' remoteID 157332968 registered.
 10:03:31.031460 (1106701200): (18) Table 'binary_data' remoteID 157333112 registered.
 10:03:31.031796 (1108802448): (18) Field 'RecID' remoteID 157333240 registered.
 10:03:31.031830 (1108802448): (18) Field 'OID' remoteID 157333344 registered.
 10:03:31.031861 (1108802448): (18) VString 'filename_orig' remoteID 157333448 registered.
 10:03:31.031891 (1108802448): (18) VString 'media_title' remoteID 157333592 registered.
 10:03:31.031920 (1108802448): (18) VString 'filepath' remoteID 157333736 registered.
 10:03:31.031950 (1108802448): (18) VString 'mime_type' remoteID 157333880 registered.
 10:03:31.031979 (1108802448): (18) VString 'timestamp' remoteID 157334024 registered.
 10:03:31.032009 (1108802448): (18) BLOB 'binary_media' remoteID 157334168 registered.
 10:03:31.032037 (1108802448): (18) VString 'keywords' remoteID 157334288 registered.
 10:03:31.032065 (1108802448): (18) BLOB 'binary_thumb' remoteID 157334432 registered.
 10:03:31.241575 (1110903696): (18) Table 'module' remoteID 158608616 registered.
 10:03:31.241877 (1106701200): (18) Field 'RecID' remoteID 158608744 registered.
 10:03:31.241920 (1106701200): (18) Field 'OID' remoteID 158608848 registered.
 10:03:31.241955 (1106701200): (18) VString 'mod_name' remoteID 158608952 registered.
 10:03:31.243092 (1108802448): (18) Table 'sys_Diagrams' remoteID 158609096 registered.
 10:03:31.243378 (1110903696): (18) Field 'RecID' remoteID 158609224 registered.
 10:03:31.243445 (1110903696): (18) Field 'OID' remoteID 158609328 registered.
 10:03:31.243479 (1110903696): (18) VString 'name' remoteID 158609432 registered.
 10:03:31.243511 (1110903696): (18) BLOB 'diadata' remoteID 158609576 registered.
 10:04:10.395167 (1108802448): (18) Link 'BLtype_relations' remoteID 154264656 registered.
 10:04:58.074544 (1108802448): Connection established with '10.159.16.20:1406' (34). ( Connections available: 'unlimited')
 10:04:58.075457 (1110903696): (34) User: KDnupxv8Orr. Connection encoding: UTF-8 - LittleEndian.
 10:04:58.101138 (1106701200): (34) Database '(null)' remoteID 159327208 registered.
 10:04:58.101194 (1106701200): (34) Database: <none>; User: KDnupxv8Orr: OK
 10:04:58.113391 (1108802448): (34) Database 'mawiba' put_Location.
 10:04:58.113662 (1106701200): (34) Database '(null)' remoteID 159327208 unregistered.
 10:04:58.113708 (1106701200): (34) Database 'mawiba.vdb' remoteID 159327208 registered.
 10:04:58.113848 (1106701200): (34) Database 'mawiba' has been successfully opened.
 10:05:02.477090 (1108802448): (34) Database 'mawiba' has been successfully closed.
 10:05:02.498528 (1106701200): Closing connection (34). ( Connections available: 'unlimited')


14:43:47.671290 (1113004944): (34) VString 'filename_orig' remoteID 158848400 registered.
 14:43:47.718306 (1113004944): (34) Database 'sw4testdb' has been successfully closed.
 14:43:47.718663 (1108802448): Closing connection (34). ( Connections available: 'unlimited')
 14:43:58.001449 (1113004944): Connection established with '10.159.16.20:1783' (34). ( Connections available: 'unlimited')
 14:43:58.002344 (1106701200): (34) User: bCs5G33Ae. Connection encoding: UTF-8 - LittleEndian.
 14:43:58.017032 (1108802448): (34) Database '(null)' remoteID 159345712 registered.
 14:43:58.017064 (1108802448): (34) Database: <none>; User: bCs5G33Ae: OK
 14:43:58.045523 (1108802448): (34) Database 'sw4testDB' put_Location.
 14:43:58.045800 (1106701200): (34) Database '(null)' remoteID 159345712 unregistered.
 14:43:58.045854 (1106701200): (34) Database 'sw4testDB.vdb' remoteID 159345712 registered.

Any hint to solve this?

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

More information about the Valentina mailing list