character set issues on porting ODBC drivers
"Kai Mosebach" <[email protected]> Fri, 4 Apr 2003 19:28:38 +0200
| Newsgroups | gmane.comp.db.sapdb.sources |
|---|---|
| Message-ID | <[email protected]> |
Hi (Daniel ?), i recently ported some older (sapdb73) odbc drivers to freebsd, linking against the libs and execution of my test-code runs fine (i was trying it on linux AND bsd), but : linux connects fine, bsd does not. Due to the not so good error output, i startet sniffing the traffic with etherreal. My Question : After the connect string in Linux some charset stuff is transmitted, In BSD the sniff shows : Unknown or not loaded character set (see bottom) what kind of character set is transferred here, and where is it defined in 1. the operating system 2. the sapdb source code thanks and regards Kai ---------------------------------------------------- LINUX 0000 08 00 46 64 49 46 00 50 56 40 01 15 08 00 45 00 ..FdIF.P [email protected]. 0010 01 2c 02 2c 40 00 40 06 b6 37 c0 a8 00 14 c0 a8 .,.,@.@. ¶7À¨..À¨ 0020 00 04 80 02 1c 2a 8d c9 8c 0f 08 05 91 44 80 18 .....*.É .....D.. 0030 16 d0 88 1a 00 00 01 01 08 0a 00 00 6b 87 00 00 .Ð...... ....k... 0040 b4 33 f8 00 00 00 03 3f 00 00 01 00 00 00 0d 00 ´3ø....? ........ 0050 00 00 00 00 04 00 f8 00 00 00 00 02 00 00 37 30 ......ø. ......70 0060 33 30 30 4f 44 42 20 7e 00 00 c0 00 00 00 00 00 300ODB ~ ..À..... 0070 01 00 00 00 00 00 00 00 00 00 c0 00 00 00 00 00 ........ ..À..... 0080 00 00 02 00 01 00 01 02 02 01 00 00 00 00 00 00 ........ ........ 0090 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ........ ........ 00a0 00 00 03 00 01 00 00 00 00 00 41 00 00 00 e8 7d ........ ..A...è} 00b0 00 00 43 4f 4e 4e 45 43 54 20 22 44 42 41 20 20 ..CONNEC T "DBA 00c0 20 20 20 20 20 20 20 20 20 20 20 20 20 22 20 49 " I 00d0 44 45 4e 54 49 46 49 45 44 20 42 59 20 3a 41 20 DENTIFIE D BY :A 00e0 20 20 49 53 4f 4c 41 54 49 4f 4e 20 4c 45 56 45 ISOLAT ION LEVE 00f0 4c 20 31 ff ff ff ff ff ff ff 05 00 01 00 00 00 L 1ÿÿÿÿÿ ÿÿ...... 0100 00 00 2c 00 00 00 90 7d 00 00 00 a0 ef 09 3b b4 ..,....} ... ï.;´ 0110 c8 53 59 60 4f 37 3d c9 27 36 c2 07 a3 17 b4 2c ÈSY`O7=É '6Â.£.´, 0120 27 ed 56 20 72 65 61 64 74 74 79 31 20 20 20 20 'íV read tty1 0130 20 20 20 20 20 20 ff ff ff ff ÿÿ ÿÿ 0000 00 50 56 40 01 15 08 00 46 64 49 46 08 00 45 00 .PV@.... FdIF..E. 0010 05 dc a7 c4 40 00 80 06 cb ee c0 a8 00 04 c0 a8 .ܧÄ@... ËîÀ¨..À¨ 0020 00 14 1c 2a 80 02 08 05 91 44 8d c9 8d 07 80 10 ...*.... .D.É.... 0030 f9 b2 cc 03 00 00 01 01 08 0a 00 00 b4 35 00 00 ù²Ì..... ....´5.. 0040 6b 87 40 0d 00 00 03 40 00 00 01 00 00 00 0d 00 k.@....@ ........ 0050 00 00 00 00 04 00 40 0d 00 00 00 02 00 00 37 30 ......@. ......70 0060 33 30 30 4f 44 42 40 8d 00 00 08 0d 00 00 00 00 300ODB@. ........ 0070 01 00 00 00 00 00 00 00 00 00 08 0d 00 00 00 00 ........ ........ 0080 00 00 03 00 01 00 02 30 30 30 30 30 00 00 00 00 .......0 0000.... 0090 00 00 00 00 00 00 d5 00 00 00 00 00 00 00 00 00 ......Õ. ........ 00a0 00 00 0f 00 01 00 00 00 00 00 0d 00 00 00 08 8d ........ ........ 00b0 00 00 03 44 42 41 03 44 42 41 03 44 42 41 00 ff ...DBA.D BA.DBA.ÿ 00c0 ff ff 04 00 04 00 00 00 00 00 00 04 00 00 e8 8c ÿÿ...... ......è. 00d0 00 00 00 01 02 03 04 05 06 07 08 09 0a 0b 0c 0d ........ ........ 00e0 0e 0f 10 11 12 13 14 15 16 17 18 19 1a 1b 1c 1d ........ ........ 00f0 1e 1f 20 21 22 23 24 25 26 27 28 29 2a 2b 2c 2d .. !"#$% &'()*+,- 0100 2e 2f 30 31 32 33 34 35 36 37 38 39 3a 3b 3c 3d ./012345 6789:;<= 0110 3e 3f 40 61 62 63 64 65 66 67 68 69 6a 6b 6c 6d >?@abcde fghijklm 0120 6e 6f 70 71 72 73 74 75 76 77 78 79 7a 5b 5c 5d nopqrstu vwxyz[\] 0130 5e 5f 60 61 62 63 64 65 66 67 68 69 6a 6b 6c 6d ^_`abcde fghijklm 0140 6e 6f 70 71 72 73 74 75 76 77 78 79 7a 7b 7c 7d nopqrstu vwxyz{|} 0150 7e 7f 80 81 82 83 84 85 86 87 88 89 8a 8b 8c 8d ~....... ........ 0160 8e 8f 90 91 92 93 94 95 96 97 98 99 9a 9b 9c 9d ........ ........ 0170 9e 9f a0 a1 a2 a3 a4 a5 a6 a7 a8 a9 aa ab ac ad .. ¡¢£¤¥ ¦§¨©ª«¬ 0180 ae af b0 b1 b2 b3 b4 b5 b6 b7 b8 b9 ba bb bc bd ®¯°±²³´µ ¶·¸¹º»¼½ 0190 be bf e0 e1 e2 e3 e4 e5 e6 e7 e8 e9 ea eb ec ed ¾¿àáâãäå æçèéêëìí 01a0 ee ef f0 f1 f2 f3 f4 f5 f6 d7 f8 f9 fa fb fc fd îïðñòóôõ ö×øùúûüý 01b0 fe df e0 e1 e2 e3 e4 e5 e6 e7 e8 e9 ea eb ec ed þßàáâãäå æçèéêëìí 01c0 ee ef f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 fa fb fc fd îïðñòóôõ ö÷øùúûüý 01d0 fe ff 00 01 02 03 04 05 06 07 08 09 0a 0b 0c 0d þÿ...... ........ 01e0 0e 0f 10 11 12 13 14 15 16 17 18 19 1a 1b 1c 1d ........ ........ 01f0 1e 1f 20 21 22 23 24 25 26 27 28 29 2a 2b 2c 2d .. !"#$% &'()*+,- 0200 2e 2f 30 31 32 33 34 35 36 37 38 39 3a 3b 3c 3d ./012345 6789:;<= 0210 3e 3f 40 41 42 43 44 45 46 47 48 49 4a 4b 4c 4d >?@ABCDE FGHIJKLM 0220 4e 4f 50 51 52 53 54 55 56 57 58 59 5a 5b 5c 5d NOPQRSTU VWXYZ[\] 0230 5e 5f 60 41 42 43 44 45 46 47 48 49 4a 4b 4c 4d ^_`ABCDE FGHIJKLM 0240 4e 4f 50 51 52 53 54 55 56 57 58 59 5a 7b 7c 7d NOPQRSTU VWXYZ{|} 0250 7e 7f 80 81 82 83 84 85 86 87 88 89 8a 8b 8c 8d ~....... ........ 0260 8e 8f 90 91 92 93 94 95 96 97 98 99 9a 9b 9c 9d ........ ........ 0270 9e 9f a0 a1 a2 a3 a4 a5 a6 a7 a8 a9 aa ab ac ad .. ¡¢£¤¥ ¦§¨©ª«¬ 0280 ae af b0 b1 b2 b3 b4 b5 b6 b7 b8 b9 ba bb bc bd ®¯°±²³´µ ¶·¸¹º»¼½ 0290 be bf c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 ca cb cc cd ¾¿ÀÁÂÃÄÅ ÆÇÈÉÊËÌÍ 02a0 ce cf d0 d1 d2 d3 d4 d5 d6 d7 d8 d9 da db dc dd ÎÏÐÑÒÓÔÕ Ö×ØÙÚÛÜÝ 02b0 de df c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 ca cb cc cd ÞßÀÁÂÃÄÅ ÆÇÈÉÊËÌÍ 02c0 ce cf d0 d1 d2 d3 d4 d5 d6 f7 d8 d9 da db dc dd ÎÏÐÑÒÓÔÕ Ö÷ØÙÚÛÜÝ 02d0 de ff 00 01 02 03 37 2d 2e 2f 16 05 25 0b 0c 0d Þÿ....7- ./..%... 02e0 0e 0f 10 11 12 13 3c 3d 32 26 18 19 3f 27 1c 1d ......<= 2&..?'.. 02f0 1e 1f 40 4f 7f 7b 5b 6c 50 7d 4d 5d 5c 4e 6b 60 ..@O.{[l P}M]\Nk` 0300 4b 61 f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 7a 5e 4c 7e Kaðñòóôõ ö÷øùz^L~ 0310 6e 6f 7c c1 c2 c3 c4 c5 c6 c7 c8 c9 d1 d2 d3 d4 no|ÁÂÃÄÅ ÆÇÈÉÑÒÓÔ 0320 d5 d6 d7 d8 d9 e2 e3 e4 e5 e6 e7 e8 e9 4a e0 5a ÕÖ×ØÙâãä åæçèéJàZ 0330 5f 6d 79 81 82 83 84 85 86 87 88 89 91 92 93 94 _my..... ........ 0340 95 96 97 98 99 a2 a3 a4 a5 a6 a7 a8 a9 c0 bb d0 .....¢£¤ ¥¦§¨©À»Ð 0350 a1 07 04 06 08 09 00000 00 50 56 40 01 15 08 00 46 64 49 46 08 00 45 00 .PV@.... FdIF..E. 0010 05 dc a7 c4 40 00 80 06 cb ee c0 a8 00 04 c0 a8 .ܧÄ@... ËîÀ¨..À¨ 0020 00 14 1c 2a 80 02 08 05 91 44 8d c9 8d 07 80 10 ...*.... .D.É.... 0030 f9 b2 cc 03 00 00 01 01 08 0a 00 00 b4 35 00 00 ù²Ì..... ....´5.. 0040 6b 87 40 0d 00 00 03 40 00 00 01 00 00 00 0d 00 k.@....@ ........ 0050 00 00 00 00 04 00 40 0d 00 00 00 02 00 00 37 30 ......@. ......70 0060 33 30 30 4f 44 42 40 8d 00 00 08 0d 00 00 00 00 300ODB@. ........ 0070 01 00 00 00 00 00 00 00 00 00 08 0d 00 00 00 00 ........ ........ 0080 00 00 03 00 01 00 02 30 30 30 30 30 00 00 00 00 .......0 0000.... 0090 00 00 00 00 00 00 d5 00 00 00 00 00 00 00 00 00 ......Õ. ........ 00a0 00 00 0f 00 01 00 00 00 00 00 0d 00 00 00 08 8d ........ ........ 00b0 00 00 03 44 42 41 03 44 42 41 03 44 42 41 00 ff ...DBA.D BA.DBA.ÿ 00c0 ff ff 04 00 04 00 00 00 00 00 00 04 00 00 e8 8c ÿÿ...... ......è. 00d0 00 00 00 01 02 03 04 05 06 07 08 09 0a 0b 0c 0d ........ ........ 00e0 0e 0f 10 11 12 13 14 15 16 17 18 19 1a 1b 1c 1d ........ ........ 00f0 1e 1f 20 21 22 23 24 25 26 27 28 29 2a 2b 2c 2d .. !"#$% &'()*+,- 0100 2e 2f 30 31 32 33 34 35 36 37 38 39 3a 3b 3c 3d ./012345 6789:;<= 0110 3e 3f 40 61 62 63 64 65 66 67 68 69 6a 6b 6c 6d >?@abcde fghijklm 0120 6e 6f 70 71 72 73 74 75 76 77 78 79 7a 5b 5c 5d nopqrstu vwxyz[\] 0130 5e 5f 60 61 62 63 64 65 66 67 68 69 6a 6b 6c 6d ^_`abcde fghijklm 0140 6e 6f 70 71 72 73 74 75 76 77 78 79 7a 7b 7c 7d nopqrstu vwxyz{|} 0150 7e 7f 80 81 82 83 84 85 86 87 88 89 8a 8b 8c 8d ~....... ........ 0160 8e 8f 90 91 92 93 94 95 96 97 98 99 9a 9b 9c 9d ........ ........ 0170 9e 9f a0 a1 a2 a3 a4 a5 a6 a7 a8 a9 aa ab ac ad .. ¡¢£¤¥ ¦§¨©ª«¬ 0180 ae af b0 b1 b2 b3 b4 b5 b6 b7 b8 b9 ba bb bc bd ®¯°±²³´µ ¶·¸¹º»¼½ 0190 be bf e0 e1 e2 e3 e4 e5 e6 e7 e8 e9 ea eb ec ed ¾¿àáâãäå æçèéêëìí 01a0 ee ef f0 f1 f2 f3 f4 f5 f6 d7 f8 f9 fa fb fc fd îïðñòóôõ ö×øùúûüý 01b0 fe df e0 e1 e2 e3 e4 e5 e6 e7 e8 e9 ea eb ec ed þßàáâãäå æçèéêëìí 01c0 ee ef f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 fa fb fc fd îïðñòóôõ ö÷øùúûüý 01d0 fe ff 00 01 02 03 04 05 06 07 08 09 0a 0b 0c 0d þÿ...... ........ 01e0 0e 0f 10 11 12 13 14 15 16 17 18 19 1a 1b 1c 1d ........ ........ 01f0 1e 1f 20 21 22 23 24 25 26 27 28 29 2a 2b 2c 2d .. !"#$% &'()*+,- 0200 2e 2f 30 31 32 33 34 35 36 37 38 39 3a 3b 3c 3d ./012345 6789:;<= 0210 3e 3f 40 41 42 43 44 45 46 47 48 49 4a 4b 4c 4d >?@ABCDE FGHIJKLM 0220 4e 4f 50 51 52 53 54 55 56 57 58 59 5a 5b 5c 5d NOPQRSTU VWXYZ[\] 0230 5e 5f 60 41 42 43 44 45 46 47 48 49 4a 4b 4c 4d ^_`ABCDE FGHIJKLM 0240 4e 4f 50 51 52 53 54 55 56 57 58 59 5a 7b 7c 7d NOPQRSTU VWXYZ{|} 0250 7e 7f 80 81 82 83 84 85 86 87 88 89 8a 8b 8c 8d ~....... ........ 0260 8e 8f 90 91 92 93 94 95 96 97 98 99 9a 9b 9c 9d ........ ........ 0270 9e 9f a0 a1 a2 a3 a4 a5 a6 a7 a8 a9 aa ab ac ad .. ¡¢£¤¥ ¦§¨©ª«¬ 0280 ae af b0 b1 b2 b3 b4 b5 b6 b7 b8 b9 ba bb bc bd ®¯°±²³´µ ¶·¸¹º»¼½ 0290 be bf c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 ca cb cc cd ¾¿ÀÁÂÃÄÅ ÆÇÈÉÊËÌÍ 02a0 ce cf d0 d1 d2 d3 d4 d5 d6 d7 d8 d9 da db dc dd ÎÏÐÑÒÓÔÕ Ö×ØÙÚÛÜÝ 02b0 de df c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 ca cb cc cd ÞßÀÁÂÃÄÅ ÆÇÈÉÊËÌÍ 02c0 ce cf d0 d1 d2 d3 d4 d5 d6 f7 d8 d9 da db dc dd ÎÏÐÑÒÓÔÕ Ö÷ØÙÚÛÜÝ 02d0 de ff 00 01 02 03 37 2d 2e 2f 16 05 25 0b 0c 0d Þÿ....7- ./..%... 02e0 0e 0f 10 11 12 13 3c 3d 32 26 18 19 3f 27 1c 1d ......<= 2&..?'.. 02f0 1e 1f 40 4f 7f 7b 5b 6c 50 7d 4d 5d 5c 4e 6b 60 ..@O.{[l P}M]\Nk` 0300 4b 61 f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 7a 5e 4c 7e Kaðñòóôõ ö÷øùz^L~ 0310 6e 6f 7c c1 c2 c3 c4 c5 c6 c7 c8 c9 d1 d2 d3 d4 no|ÁÂÃÄÅ ÆÇÈÉÑÒÓÔ 0320 d5 d6 d7 d8 d9 e2 e3 e4 e5 e6 e7 e8 e9 4a e0 5a ÕÖ×ØÙâãä åæçèéJàZ 0330 5f 6d 79 81 82 83 84 85 86 87 88 89 91 92 93 94 _my..... ........ 0340 95 96 97 98 99 a2 a3 a4 a5 a6 a7 a8 a9 c0 bb d0 .....¢£¤ ¥¦§¨©À»Ð 0350 a1 07 04 06 08 09 0 ---------------------------------------------------- BSD 0000 08 00 46 64 49 46 00 10 5a 65 0c e0 08 00 45 00 ..FdIF.. Ze....E. 0010 01 84 6b 3e 40 00 40 06 00 00 c0 a8 00 64 c0 a8 ..k>@.@. .....d.. 0020 00 04 c0 12 1c 2a b2 07 82 dd 00 cc 80 b0 80 18 .....*.. ........ 0030 81 f1 83 2f 00 00 01 01 08 0a 00 07 c9 bc 00 00 .../.... ........ 0040 a1 10 50 01 00 00 03 3f 00 00 01 00 00 00 0d 00 ..P....? ........ 0050 00 00 00 00 04 00 50 01 00 00 13 02 00 00 37 30 ......P. ......70 0060 33 30 30 4f 44 42 20 7e 00 00 18 01 00 00 00 00 300ODB ~ ........ 0070 01 00 00 00 00 00 00 00 00 00 18 01 00 00 00 00 ........ ........ 0080 00 00 02 00 01 00 01 02 02 01 00 00 00 00 00 00 ........ ........ 0090 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ........ ........ 00a0 00 00 03 00 01 00 00 00 00 00 9c 00 00 00 e8 7d ........ .......} 00b0 00 00 43 00 4f 00 4e 00 4e 00 45 00 43 00 54 00 ..C.O.N. N.E.C.T. 00c0 20 00 22 00 44 00 42 00 41 00 20 00 20 00 20 00 .".D.B. A. . . . 00d0 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 . . . . . . . . 00e0 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 . . . . . . . . 00f0 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 . . . . . . . . 0100 20 00 22 00 20 00 49 00 44 00 45 00 4e 00 54 00 .". .I. D.E.N.T. 0110 49 00 46 00 49 00 45 00 44 00 20 00 42 00 59 00 I.F.I.E. D. .B.Y. 0120 20 00 3a 00 41 00 20 00 20 00 20 00 49 00 53 00 .:.A. . . .I.S. 0130 4f 00 4c 00 41 00 54 00 49 00 4f 00 4e 00 20 00 O.L.A.T. I.O.N. . 0140 4c 00 45 00 56 00 45 00 4c 00 20 00 31 00 ff ff L.E.V.E. L. .1... 0150 ff ff 05 00 01 00 00 00 00 00 2c 00 00 00 38 7d ........ ..,...8} 0160 00 00 00 4a b5 f4 54 04 00 5e 55 d7 cc dd 95 7f ...J..T. .^U..... 0170 10 7d bc 09 ab 52 a6 8a 0f e5 44 20 76 2e 64 65 .}...R.. ..D v.de 0180 74 79 70 30 20 20 20 20 20 20 20 20 20 20 ff ff typ0 .. 0190 ff ff .. 0000 00 10 5a 65 0c e0 08 00 46 64 49 46 08 00 45 00 ..Ze.... FdIF..E. 0010 00 cc 9d 7e 40 00 80 06 da f4 c0 a8 00 04 c0 a8 ...~@... ........ 0020 00 64 1c 2a c0 12 00 cc 80 b0 b2 07 84 2d 80 18 .d.*.... .....-.. 0030 f9 59 a2 13 00 00 01 01 08 0a 00 00 a1 10 00 07 .Y...... ........ 0040 c9 bc 98 00 00 00 03 40 00 00 01 00 00 00 0d 00 .......@ ........ 0050 00 00 00 00 04 00 98 00 00 00 13 02 00 00 37 30 ........ ......70 0060 33 30 30 4f 44 42 e8 8c 00 00 60 00 00 00 00 00 300ODB.. ..`..... 0070 01 00 00 00 00 00 00 00 00 00 60 00 00 00 00 00 ........ ..`..... 0080 00 00 01 00 01 00 02 49 34 30 32 35 47 f0 01 00 .......I 4025G... 0090 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ........ ........ 00a0 00 00 06 00 01 00 00 00 00 00 23 00 00 00 b0 8c ........ ..#..... 00b0 00 00 55 6e 6b 6e 6f 77 6e 20 6f 72 20 6e 6f 74 ..Unknow n or not 00c0 20 6c 6f 61 64 65 64 20 63 68 61 72 61 63 74 65 loaded characte 00d0 72 20 73 65 74 ff ff ff ff ff r set... ..