{"_id":"@el3um4s/decode-mdb-strange-chars","_rev":"2-bdf75e4a90123d1b4c8c4be210fcb5ef","name":"@el3um4s/decode-mdb-strange-chars","dist-tags":{"latest":"1.0.1"},"versions":{"0.0.1":{"name":"@el3um4s/decode-mdb-strange-chars","version":"0.0.1","description":"A workaround to solve the character decoding problem of .mdb files (MS Access)","main":"lib/index.js","types":"lib/index.d.ts","scripts":{"build":"tsc","lint":"eslint . --ext .ts","test":"jest --config jestconfig.json","prepare":"npm run build","prepublishOnly":"npm test && npm run lint","preversion":"npm run lint","version":"git add -A src","postversion":"git push && git push --tags","check-updates":"npx npm-check-updates","check-updates:minor":"npx npm-check-updates --target minor","check-updates:patch":"npx npm-check-updates --target patch"},"repository":{"type":"git","url":"git+https://github.com/el3um4s/decode-mdb-strange-chars.git"},"keywords":["typescript","npm","ts","mdb","msaccess","ms-access","utf8","utf-8","decoder","strange-chars","utf8-characters","utf-8-conversion-tool","utf-8-string","utf8-string","windows"],"author":{"name":"Samuele C. De Tomasi"},"license":"MIT","funding":[{"type":"patreon","url":"https://www.patreon.com/el3um4s"},{"type":"individual","url":"https://www.paypal.me/el3um4s"}],"bugs":{"url":"https://github.com/el3um4s/decode-mdb-strange-chars/issues"},"homepage":"https://github.com/el3um4s/decode-mdb-strange-chars#readme","devDependencies":{"@el3um4s/run-vbs":"^1.1.1","@types/jest":"^28.1.6","@types/node":"^18.0.6","@typescript-eslint/eslint-plugin":"^5.30.7","@typescript-eslint/parser":"^5.30.7","ansi-regex":">=6.0.1","eslint":"^8.20.0","eslint-config-prettier":"^8.5.0","eslint-config-standard":"^17.0.0","eslint-plugin-import":"^2.26.0","eslint-plugin-node":"^11.1.0","eslint-plugin-promise":"^6.0.0","jest":"^28.1.3","ts-jest":"^28.0.7","typescript":"^4.7.4"},"gitHead":"59e989673c72fb7e9ca05e9e57007a342d65279a","_id":"@el3um4s/decode-mdb-strange-chars@0.0.1","_nodeVersion":"18.3.0","_npmVersion":"8.12.1","dist":{"integrity":"sha512-+x4xrUuy3R2JZcDOa9gAMxr7pFw0xnw9qH+N1h4Oc+/s//z2mfxbpJ++jrtERlGDoG7TWQlhFfm2/aPG4lW/1g==","shasum":"74eb6ef56d89c304521fa5b34d3331a35e5db31e","tarball":"https://registry.npmjs.org/@el3um4s/decode-mdb-strange-chars/-/decode-mdb-strange-chars-0.0.1.tgz","fileCount":9,"unpackedSize":18524,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIE1ce07O+ZM/nCDBgLwvQi7GN/svScYCQuYATEOvbjLWAiEAs5YF1Bm72Uf88mZ4QLTtm0dxxgnHp8Ya0e0fcWWCj9s="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJi1c1dACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmoaMg/+N19TAmjwGeua0T2By+YPMoC7jBoKoWZ4ktqCGSU7BMVIXxul\r\nG5f7sSgAKj/W9P7QjNi7DHBZ7hkUNClr1o/Qyg4xklCyAv4Uy2KO1eQ81pk2\r\n7wXiXlKKxHxse9JZdjselQ6lTchzgOx1KYNi36SQCwGh64OhOKqvJjYK1Nj9\r\nU1YzJ6nSSp7zCC/nJS1xMH5b95OdDv5wrVMhnBTq8zDCOdwyoAbROBWN/ErF\r\noCvK6d/IFiCJgQdspq9Hkycbh+2xPhfQaZoq1zpcK2hrJ8xR387yvhuSheVw\r\nQsGyS74fQaOKEGvRYayt1L3wgQVAzTANHZAuMOQwXmQ3ae689CtodLBl1WAH\r\nh45A+49RE0Uh3YnEDYfslIdRKny3gqxP71zpD7yQWV2s7yxdpClMxYdCZrvZ\r\nnZ5FUh83U+wLNhB+oZSILSoTvBRtwBRvVhqUhRM7394PERjEsZWhrkwxOe6h\r\nMA5uy9bsyLgpMPDzM4m79YA/uB3ygODzRDtRhsYCqHqlaDmLsBd8dbITGBxk\r\n6FEYuaaAHtDhCCsL5aCXmU2DkqTx0mnIuSbpwwcG9iPHiXzLsQbVrUiKAMO2\r\nL/W+Xw6cNCP/BkULllF0+6mkRF7CognkV9sqtMYf3wng0OwT2WObiR+knn8P\r\nCVveeVFaoFDloF53yU97/m/gqaTVwZGizo8=\r\n=pcXr\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"el3um4s","email":"el3um4s@gmail.com"},"directories":{},"maintainers":[{"name":"el3um4s","email":"el3um4s@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/decode-mdb-strange-chars_0.0.1_1658178909578_0.9925498367152736"},"_hasShrinkwrap":false},"1.0.0":{"name":"@el3um4s/decode-mdb-strange-chars","version":"1.0.0","description":"A workaround to solve the character decoding problem of .mdb files (MS Access)","main":"lib/index.js","types":"lib/index.d.ts","scripts":{"build":"tsc","lint":"eslint . --ext .ts","test":"jest --config jestconfig.json","prepare":"npm run build","prepublishOnly":"npm test && npm run lint","preversion":"npm run lint","version":"git add -A src","postversion":"git push && git push --tags","check-updates":"npx npm-check-updates","check-updates:minor":"npx npm-check-updates --target minor","check-updates:patch":"npx npm-check-updates --target patch"},"repository":{"type":"git","url":"git+https://github.com/el3um4s/decode-mdb-strange-chars.git"},"keywords":["typescript","npm","ts","mdb","msaccess","ms-access","utf8","utf-8","decoder","strange-chars","utf8-characters","utf-8-conversion-tool","utf-8-string","utf8-string","windows"],"author":{"name":"Samuele C. De Tomasi"},"license":"MIT","funding":[{"type":"patreon","url":"https://www.patreon.com/el3um4s"},{"type":"individual","url":"https://www.paypal.me/el3um4s"}],"bugs":{"url":"https://github.com/el3um4s/decode-mdb-strange-chars/issues"},"homepage":"https://github.com/el3um4s/decode-mdb-strange-chars#readme","devDependencies":{"@el3um4s/run-vbs":"^1.1.1","@types/jest":"^28.1.6","@types/node":"^18.0.6","@typescript-eslint/eslint-plugin":"^5.30.7","@typescript-eslint/parser":"^5.30.7","ansi-regex":">=6.0.1","eslint":"^8.20.0","eslint-config-prettier":"^8.5.0","eslint-config-standard":"^17.0.0","eslint-plugin-import":"^2.26.0","eslint-plugin-node":"^11.1.0","eslint-plugin-promise":"^6.0.0","jest":"^28.1.3","ts-jest":"^28.0.7","typescript":"^4.7.4"},"gitHead":"308c6b0df43dcacae3c9c7adb74735943bc4ed9c","_id":"@el3um4s/decode-mdb-strange-chars@1.0.0","_nodeVersion":"18.3.0","_npmVersion":"8.12.1","dist":{"integrity":"sha512-Qj01PNc9jWcHntDhu8PnP+/EdY59avF1G3HMS1SAmGULkgogdLJPcAjURYlIH8i8c92utjDwgZHnv9Hc26O/AA==","shasum":"ebeb3b6136d74c0334ccdab65cbc12f928393f8f","tarball":"https://registry.npmjs.org/@el3um4s/decode-mdb-strange-chars/-/decode-mdb-strange-chars-1.0.0.tgz","fileCount":9,"unpackedSize":18524,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDGVdsMxYaf4sR1CmFR4g/0S26KW7ALf63cWVhMdhVWbgIhAKVS0ZyG0oU5z8lMGem0fgK768J14yC/IrmDMN54zxki"}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJi1c2vACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmprKA/9G6zRxftcsIvJlF+BYoxvdRH/JEYCrKKfhGpovhRChXnD444n\r\ncrfJyOv5i/lWNEM2wd3Oyb3qRsGRIl85TZ+cEPbJTQR9horPvfqNh8VJQs6O\r\nLvM64iHrdl/kUX9B0r9rh8NhFictnSNoKQbQB4t1NbtmyLwmKSbciym+14xO\r\nLCP/m2heMrMX1OfzeAuY+a5tBxyw+oMfEswFhzoKDZrAe8SzpsugUgmhRCTV\r\nHPm9J47B9JAWLgSyQgsX0tnkJLZZmGCuSMZZ36EwnAvoWwsUJcPYRWV4TztT\r\n9foDF2fxRsUoLX7fuOVs4nE1V7v1JHfuQX//CpnQ1b+/R6cpLIL65+w6GrST\r\n6fmPQ8FBn4z56+o2HLHC2uBVz5RAPKACK22V+MYGan51P2eNqhR4P27MOIdz\r\nObI/HemgZKu2zb6FW2CcPHELqPVJGYlqcCouFRcvIZTNzKUo8A6680v9G0UC\r\nRTvVG3tjwimgJjeI5p0az5q8V84FTh3CVNqnpDMl53SudDNov2spCtmT+E5k\r\nSGjFa4P8PXkKYiEbRwxlPnd3FbtYpNl56//z0Jzqu9HpGYpJ//jUgg1YvIUq\r\n809+cHUsIwu4edfrZAial7dz4B/ViK3HGCYlMfpgNXrJbmYaV7keIEOs+p9W\r\nMAXAv3ijapRc08zKC/0yTpWcTHaQYA4+Msk=\r\n=VhA8\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"el3um4s","email":"el3um4s@gmail.com"},"directories":{},"maintainers":[{"name":"el3um4s","email":"el3um4s@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/decode-mdb-strange-chars_1.0.0_1658178990981_0.23146657519849256"},"_hasShrinkwrap":false},"1.0.1":{"name":"@el3um4s/decode-mdb-strange-chars","version":"1.0.1","description":"A workaround to solve the character decoding problem of .mdb files (MS Access)","main":"lib/index.js","types":"lib/index.d.ts","scripts":{"build":"tsc","lint":"eslint . --ext .ts","test":"jest --config jestconfig.json","prepare":"npm run build","prepublishOnly":"npm test && npm run lint","preversion":"npm run lint","version":"git add -A src","postversion":"git push && git push --tags","check-updates":"npx npm-check-updates","check-updates:minor":"npx npm-check-updates --target minor","check-updates:patch":"npx npm-check-updates --target patch"},"repository":{"type":"git","url":"git+https://github.com/el3um4s/decode-mdb-strange-chars.git"},"keywords":["typescript","npm","ts","mdb","msaccess","ms-access","utf8","utf-8","decoder","strange-chars","utf8-characters","utf-8-conversion-tool","utf-8-string","utf8-string","windows"],"author":{"name":"Samuele C. De Tomasi"},"license":"MIT","funding":[{"type":"patreon","url":"https://www.patreon.com/el3um4s"},{"type":"individual","url":"https://www.paypal.me/el3um4s"}],"bugs":{"url":"https://github.com/el3um4s/decode-mdb-strange-chars/issues"},"homepage":"https://github.com/el3um4s/decode-mdb-strange-chars#readme","devDependencies":{"@el3um4s/run-vbs":"^1.1.1","@types/jest":"^28.1.6","@types/node":"^18.0.6","@typescript-eslint/eslint-plugin":"^5.30.7","@typescript-eslint/parser":"^5.30.7","ansi-regex":">=6.0.1","eslint":"^8.20.0","eslint-config-prettier":"^8.5.0","eslint-config-standard":"^17.0.0","eslint-plugin-import":"^2.26.0","eslint-plugin-node":"^11.1.0","eslint-plugin-promise":"^6.0.0","jest":"^28.1.3","ts-jest":"^28.0.7","typescript":"^4.7.4"},"gitHead":"bb574056424342a01e45f83a97d9da876b1e95d3","_id":"@el3um4s/decode-mdb-strange-chars@1.0.1","_nodeVersion":"18.3.0","_npmVersion":"8.12.1","dist":{"integrity":"sha512-/e0aLLbNl1xdYyybx1202W3dEw1CKtuucV0UH4kNZg1F3tsDVvlgb6IUiWSDXZukfbcq7R/wx0fUi6ZhVG3+Vg==","shasum":"edbb1bb03be7b818867590be1cd462b7b0d8779a","tarball":"https://registry.npmjs.org/@el3um4s/decode-mdb-strange-chars/-/decode-mdb-strange-chars-1.0.1.tgz","fileCount":9,"unpackedSize":18519,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAOYkvs5gjJ8wG7Q4agh4bGrMb3Dwkwg3QFY8slNcJXNAiBl+eiiZhfp9hGSUkR+LvHSL+BKWQs3QGa/JXn+lVA/1A=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJi1dTLACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmrD6g/7BOu9Z7lQFer7tpE6eEcehC/vQWtHdIj9YEd5CPXR2l0PLRLx\r\nMBLAL3jPQojI58oMub2Z0DGlppvs29EhTa2w8TjW4SWOmZsyfqRY/1H08qYQ\r\nn3GVzKTQn4yjuj0V9SuQ9AH53yloU2BnxTnvFHxJqGQt89DzRrRM8DrQuEaC\r\noy7nPDvCtPcQlHyJ6M8sLz4dpxWVJ6XPdVJvEbmoTGr/ALKa69ZLM7JX+jef\r\n972YtZ4VDc97HdkM8fwvVeEhKqrsMicci0gOpdCP1yk1iCNK+QB29cJQPcvM\r\neHhmewWJGOSprjsKFOSl/c8qIO92JiMBc6UT1vEIT2T0xjEkVDgAqBk3FR2n\r\ndlIl/KMX21qk4ClR1x2jGqe8DJzjOwWL7lfzxlI8iMZpERv7RYEeouSuELyo\r\nE7Do4UyZb/D9FVPlIrcNRLNRU+bkZioGlVthec/pYPU7ZhZE9x7MAO4+rmSA\r\n5JHs9SjYkqvN9aPB9zufigNihUAC7gA58RofkjrL7yHn9z036ljFTb6IfQ8b\r\ndjt8ot0YMzxboaqeiRKAv75QXO/eyTr+hQU+F9tXlaJLmKQD1wVTMZOIgh0w\r\nThFJzk0h3nSlAZFOiBGrjIK6QLsXaPfi49/Rz7ELgc6j7xepZDjvcUQ99Cn1\r\n3DEkCT917SHwCSzmaK0MHMtcnLYsAjQmxdE=\r\n=AzA4\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"el3um4s","email":"el3um4s@gmail.com"},"directories":{},"maintainers":[{"name":"el3um4s","email":"el3um4s@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/decode-mdb-strange-chars_1.0.1_1658180810965_0.7179069526184976"},"_hasShrinkwrap":false}},"time":{"created":"2022-07-18T21:15:09.521Z","0.0.1":"2022-07-18T21:15:09.771Z","modified":"2022-07-18T21:46:51.247Z","1.0.0":"2022-07-18T21:16:31.150Z","1.0.1":"2022-07-18T21:46:51.157Z"},"maintainers":[{"name":"el3um4s","email":"el3um4s@gmail.com"}],"description":"A workaround to solve the character decoding problem of .mdb files (MS Access)","homepage":"https://github.com/el3um4s/decode-mdb-strange-chars#readme","keywords":["typescript","npm","ts","mdb","msaccess","ms-access","utf8","utf-8","decoder","strange-chars","utf8-characters","utf-8-conversion-tool","utf-8-string","utf8-string","windows"],"repository":{"type":"git","url":"git+https://github.com/el3um4s/decode-mdb-strange-chars.git"},"author":{"name":"Samuele C. De Tomasi"},"bugs":{"url":"https://github.com/el3um4s/decode-mdb-strange-chars/issues"},"license":"MIT","readme":"# Decode MDB Strange Chars\r\n\r\nA workaround to solve the character decoding problem of .mdb files (MS Access)\r\n\r\nNPM link: [@el3um4s/decode-mdb-strange-chars](https://www.npmjs.com/package/@el3um4s/decode-mdb-strange-chars)\r\n\r\n### Install and use the package\r\n\r\nTo use the package in a project:\r\n\r\n```bash\r\nnpm i @el3um4s/decode-mdb-strange-chars\r\n```\r\n\r\nand then in a file:\r\n\r\n```ts\r\nimport {\r\n  decodeString,\r\n  decodeVBSBuffer,\r\n} from \"@el3um4s/decode-mdb-strange-chars\";\r\n\r\nimport { vbs } from \"./sql\";\r\n\r\nconst file = path.resolve(\"./src/__tests__/test.mdb\");\r\n\r\nconst sqlString = `SELECT * FROM [test] WHERE [ordine]=${ordine};`;\r\n\r\nconst result = await runVbsBuffer({\r\n  vbs,\r\n  args: [file, `\"${sqlString}\"`, type],\r\n});\r\n\r\nconst decoded = decodeVBSBuffer(result);\r\nconsole.log(decoded);\r\n// {\"result\":[{\"ordine\": \"157\",\"carattere\": \"à\",\"utf-8 bytes\": \"c3 a0\",\"descrizione\": \"LATIN SMALL LETTER A WITH GRAVE\",\"codice win\": \"85\"}]}\r\n\r\nconst codeAccess = \"85\";\r\nconst decodedChar = decodeString(codeAccess);\r\nconsole.log(decodedChar);\r\n// à\r\n```\r\n\r\n### API\r\n\r\n- `decodeString(text: string): string` decode a string of hex code to a string of characters\r\n- `decodeVBSBuffer(buffer: string[]): string` decode a buffer of hex code to a string of characters\r\n\r\n### Acknowledgments\r\n\r\nMy problem is reading mdb files even when there are strange characters. This package is meant for [node-mdb](https://github.com/el3um4s/node-mdb). It serves as an intermediate step to convert the characters obtained from [run-vbs](https://github.com/el3um4s/run-vbs). I keep it as a separate package so that I can use it in other projects as well. And, above all, to be able to test it independently and, at the same time, keep the _node-mdb_ code clean.\r\n","readmeFilename":"README.md"}