WOW! WOW! WOW! Hi Brian
thank you very much! The first try works briliant. Thank you for this fast solution All the best Ludwig Am 21 May 2009 um 15:44, schrieb Brian Hancock: > > Hi Ludwig, > > For the sample DP Web application I have updated the DP.pm module which > converts field data > from an iso-8859-1 form submission from the Latin character set to the > IBMPC DOS charset. > > You can simply replace the DP.pm file in the > C:\DPWeb\Apache2.2\cgi-bin\lib\ folder (perhaps > back it up first) and replace it with the DP.pm file included in the .zip > file that can be downloaded > from http://www.brileigh.com/dpweb/DP.zip > > I will make this the standard for this module as it seems to work, and > although I was worried about > speed, I haven’t been able to find any degradation,,, > > Regards > Brian > PS. Thank you for the feedback, if you come across any other problems > please let me know… > > > > > > > From: [email protected] > [mailto:[email protected]] On Behalf > Of Ludwig Güthlein > Sent: Wednesday, 20 May 2009 3:59 PM > To: [email protected] > Subject: [Dataperf] DP-Web and ASCII-DOS and iso-8859-1 > > > Hi Bruce > and everyone who answered my question regarding how to deal with > charcters > from the extended ASCII-Dos-characterset > > I changed the topic and started a new threat (see former threat at the > end of this > mail). > > When I use DP-Web the characters from the DP-Database are shown properly > in the Web-Browser-display. > But trying to enter characters into the database via the > browser-interface (edit > and save) all extended characters are changed to something else. > > Now I understand the difference of ascii-dos and iso-8859-1 Latin > charstet. At > which moment of the import-report-perl-script should a conversion > programm (if I > find one) be activated? > > Thanks for your last answer and for any help > > Ludwig Güthlein > > > ------ former threat: > > Hi Ludwig, > > DP uses an extended ASCII character set peculiar to the IBM PC. On the > web, I tend to use to "Latin" character set (officially known as > iso-8859-1). So, in the firestorm way of doing DP on the web, there is an > in-built translation table for moving characters first from DOS to the > Latin character set (for displaying data from within DP) and then for > translating characters from Latin to DOS (for bringing data into DP). > > Brian's suggestion to use character entities might help. If not, even > though this isn't directly useful to you, I am attaching the two > translation tables. Character 129 in DOS maps to character 252 in Latin, > and vice versa. Perhaps this translation could be built in to the Perl > script? > > Best wishes, > Bruce > > P.S. Rather than attaching, am just pasting it in here: > > unsigned char dosToLatin[256] = { > 0, 1, 2,3, 4, 5, 6, 7,8, 9, 10, 11, 12, > 13, 14, 15, > 16, 17, 18, 19, 182, 167,20, 21, 22, 23, 24, 25, 26, > 27, 28, 29, > 32, 33, 34, 35, 36,37, 38, 39, 40, 41, 42, 43,44, > 45, 46, 47, > 48, 49, 50, 51, 52,53, 54, 55, 56, 57, 58, 59,60, > 61, 62, 63, > 64, 65, 66, 67, 68,69, 70, 71, 72, 73, 74, 75,76, > 77, 78, 79, > 80, 81, 82, 83, 84,85, 86, 87, 88, 89, 90, 91,92, > 93, 94, 95, > 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, > 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, > 125, 126, 30, 199, 252, 233, 226, 228, 224, 229, 231, 234, 235, 232, > 239, 238, 236, 196, 197, 201, 230, 198, 244, 246, 242, 251, 249, 255, > 214, 220, 162, 163, 165, 31, 127, 225, 237, 243, 250, 241, 209, 170, > 186, 191, 128, 172, 189, 188, 161, 171, 187, 129, 130, 131, 132, 133, > 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, > 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158,159, 164, 166, > 168, 169, 173, 174, 175, 179, 180, 184, 185, 190, 192, 193, 194, 195, > 200, 202, 203, 204, 205, 206, 207, 181, 208, 210, 211, 212, 213, 215, 216, > 217, 218, 219, 177, 221, 222, 223, 227, 247, 240, 176, 183, 245, 248, > 253, 178, 254, 160 }; unsigned char latinToDos[256] = { > 0, 1, 2,3, 4, 5, 6, 7,8, 9, 10, 11, 12, > 13, 14, 15, > 16, 17, 18, 19, 22,23, 24, 25, 26, 27, 28, 29, 30,31, > 127, 158, > 32, 33, 34, 35, 36,37, 38, 39, 40, 41, 42, 43,44, > 45, 46, 47, > 48, 49, 50, 51, 52,53, 54, 55, 56, 57, 58, 59,60, > 61, 62, 63, > 64, 65, 66, 67, 68,69, 70, 71, 72, 73, 74, 75,76, > 77, 78, 79, > 80, 81, 82, 83, 84,85, 86, 87, 88, 89, 90, 91,92, > 93, 94, 95, > 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, > 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, > 125, 126, 159, 169, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, > 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, > 200, 201, 202, 203, 204, 205, 206, 255, 173, 155, 156, 207, 157, 208, > 21, 209, 210, 166, 174, 170, 211, 212, 213, 248, 241, 253, 214, 215, 230, > 20, 249, 216, 217, 167, 175, 172, 171, 218, 168, 219, 220, 221, 222, > 142, 143, 146, 128, 223, 144, 224, 225, 226, 227, 228, 229, 231, 165, > 232, 233, 234, 235, 153, 236, 237, 238, 239, 240, 154, 242, 243, 244, > 133, 160, 131, 245, 132, 134, 145, 135, 138, 130, 136, 137, 141, 161, > 140, 139, 247, 164, 149, 162, 147, 250, 148, 246, 251, 151, 163, 150, 129, > 252, 254, 152 }; > > On May 19, 2009, at 2:27 AM, Ludwig Güthlein wrote: > > > Hello to everyone! > > > > Following this discussion I made my first try with this DP-Web- > > Sample and it works perfect on a > > Vista-Notebook and on a XP-Desktop. Thank you very much. > > > > I have translated the necessary terms of the reports into German and it > > works smoothly. I have run into one problem: If I enter a charcter of > > the extended- ASCII-set it is not converted correctly. In detail with > > the letter u-diaresis (i.e. a german u with 2 dots above) = ASCII129: > > > > - if I enter the letter ASCII-129 directly into the DP-Database it is > > shown correct in the DOS environment - then I can run DP-Web-Sample and > > the letter is shown correct in the browser - when I edit the record > > from the browser I can enter ASCII-129 correctly - after saving this > > u-diaresis (ASCII-129) ist saved in the DP- Databse as ASCII-236 (a y > > with an accent) -from now on the browser will always show this y with > > accent(ASCII-236) > > > > Actually all letters from the extended-character-set a convert to > > something (for me unpredectable) when saved by the edit and save command > > of thebrowser-page. > > > > Has it something to do with my german environment of windows and > > dos? Is there a way to > > control the conversion of these extended-charset-letters? > > > > Thank you for any help. > > > > DP is the fastest way to build a database and to control any amount of > > data. Thank you to all who keep it alive. > > > > Ludwig Güthlein > > > > > > > -- > Ludwig Güthlein > Berg Sion 6, 56179 Vallendar > Tel/Fax: 0261-9632223 > eMail: [email protected] > > > -- Ludwig Güthlein Berg Sion 6, 56179 Vallendar Tel/Fax: 0261-9632223 eMail: [email protected] _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
