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 the browser-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]
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
