{"id":1938,"date":"2014-11-14T00:44:57","date_gmt":"2014-11-14T00:44:57","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=1938"},"modified":"2020-11-10T09:31:57","modified_gmt":"2020-11-10T17:31:57","slug":"using-translation-tables-ms92-odbc32-and-nft","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/using-translation-tables-ms92-odbc32-and-nft\/","title":{"rendered":"Using Translation Tables (Secure 92, ODBC\/32 and NFT)"},"content":{"rendered":"<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Translation tables provide a means to substitute characters during ASCII file transfers. They are used in Secure 92, ODBC\/32 and NFT.<\/span><\/p>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">These tables are available from Minisoft, Inc. Contact Minisoft to receive the table(s) you need. You may also create you own tables.<\/span><\/p>\n<hr size=\"1\" \/>\n<h3><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Using Translations Tables With MS92<\/span><\/h3>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">If you need non-U.S. English fonts and you plan to use Windows True Type fonts, you will need to use font conversion tables.<\/span><\/p>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">MS92 uses Character Set Translation Tables to convert between different character sets on PCs and host computers.<\/span><\/p>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">The tables reside in the same directory as MS92, where MS92 looks for them during startup.<\/span><\/p>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Some of the tables may also be loaded dynamically, without having to stop and restart MS92. You do this by running a script file that includes the TABLOAD command.<\/span><\/p>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">The following table shows the table types available and the equivalent TABLOAD values:<\/span><\/p>\n<table border=\"1\" cellpadding=\"4\">\n<tbody>\n<tr>\n<th><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Function<\/span><\/th>\n<th><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Translation<br \/>\nTable<\/span><\/th>\n<th><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">TABLOAD<br \/>\nValue<\/span><\/th>\n<\/tr>\n<tr>\n<td bgcolor=\"#FFFFC8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">PC keyboard to host computer<\/span><\/td>\n<td bgcolor=\"#FFFFC8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">HP_CHARS.TBL<\/span><\/td>\n<td bgcolor=\"#FFFFC8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Host computer to PC monitor<\/span><\/td>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">PC_CHARS.TBL<\/span><\/td>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#FFFFD2\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">ASCII file transfer from PC to host<\/span><\/td>\n<td bgcolor=\"#FFFFD2\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">XLAT1.TBL<\/span><\/td>\n<td bgcolor=\"#FFFFD2\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">3<\/span><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">ASCII file transfer from host to PC<\/span><\/td>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">XLAT2.TBL<\/span><\/td>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">4<\/span><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#FFFFD2\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Host to PC function keys<\/span><\/td>\n<td bgcolor=\"#FFFFD2\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">FK_CHARS.TBL<\/span><\/td>\n<td bgcolor=\"#FFFFD2\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">5<\/span><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Host to PC local printer<\/span><\/td>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">PT_CHARS.TBL<\/span><\/td>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">6<\/span><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#FFFFD2\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Copy to clipboard<\/span><\/td>\n<td bgcolor=\"#FFFFD2\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">CUTCHARS.TBL<\/span><\/td>\n<td bgcolor=\"#FFFFD2\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">7<\/span><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Paste from clipboard<\/span><\/td>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">PASTE_CH.TBL<\/span><\/td>\n<td bgcolor=\"#E8E8E8\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">8<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr size=\"1\" \/>\n<h3><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Using Translation Tables With ODBC\/32, JDBC and OLE DB<\/span><\/h3>\n<p class=\"style2\">The connection parameters &#8220;2DriverTable&#8221; and &#8220;2HostTable&#8221; are provided to hold the names of translation table files. Provide the value for a file name as used on the system that runs the client driver library.<\/p>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Enter the name of existing .tbl translation tables in the DSN configuration dialog box.<\/span><\/p>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">These files are the same as those used with the other communication products.<\/span><\/p>\n<p align=\"left\"><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\"> <a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2014\/11\/odbc_a14.gif\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1940\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2014\/11\/odbc_a14.gif\" alt=\"odbc_a14\" width=\"380\" height=\"245\" \/><\/a><br \/>\n<\/span><\/p>\n<hr size=\"1\" \/>\n<h3><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Using Translation Tables With NFT<\/span><\/h3>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">NFT (both MPE and FTP) use a MDMFT32.INI (or MDMFTP32.INI) file to set translation table values. For example, to have extended characters convert correctly between Windows ANSI and HP-ROMAN9 when using NFT, add the following lines to the file C:\\WINNT\\MDMFT32.INI:<\/span><\/p>\n<blockquote><p><code>[Translation]<br \/>\nUploadTable=C:\\MINISOFT\\WS92\\ANSIROM9.TBL<br \/>\nDownloadTable=C:\\MINISOFT\\WS92\\ROM9ANSI.TBL<\/code><\/p><\/blockquote>\n<p class=\"basic\">Note: Use the appropriate Table.<\/p>\n<hr size=\"1\" \/>\n<h3><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\"> Making XLAT Files<\/span><\/h3>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">The size of these tables is always 256 bytes. The characters in this file are substituted for the equivalent (indexed) character requested. If the file contains the binary values zero through 255, no change would take place.<\/span><\/p>\n<p><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Example:<br \/>\nIf the 33rd character (Decimal value 32, Hex 20) is replaced with the 66th character (Decimal value 65, Hex 41), all blank spaces will be replaced with the letter A.<\/span><\/p>\n<hr size=\"1\" \/>\n<h3><span style=\"font-family: Arial,Helvetica,sans-serif; font-size: small;\">Sample Tables<\/span><\/h3>\n<p>Download the <a href=\"\/support\/wp-content\/uploads\/2014\/11\/xlat.zip\">Sample Tables<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Translation tables provide a means to substitute characters during ASCII file transfers. They are used in Secure 92, ODBC\/32 and NFT. These tables are available from Minisoft, Inc. Contact Minisoft to receive the table(s) you need. You may also create you own tables. Using Translations Tables With MS92 If you need non-U.S. English fonts and [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,64,54,60,63,65,72,62],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1938"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=1938"}],"version-history":[{"count":5,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1938\/revisions"}],"predecessor-version":[{"id":8636,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1938\/revisions\/8636"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=1938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=1938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=1938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}