{"action":"created","issue":{"url":"https://api.github.com/repos/theconst/aodbc/issues/1","repository_url":"https://api.github.com/repos/theconst/aodbc","labels_url":"https://api.github.com/repos/theconst/aodbc/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/theconst/aodbc/issues/1/comments","events_url":"https://api.github.com/repos/theconst/aodbc/issues/1/events","html_url":"https://github.com/theconst/aodbc/issues/1","id":383818092,"node_id":"MDU6SXNzdWUzODM4MTgwOTI=","number":1,"title":"Some charset problems on Windows","user":{"login":"adaptun","id":1929255,"node_id":"MDQ6VXNlcjE5MjkyNTU=","avatar_url":"https://avatars2.githubusercontent.com/u/1929255?v=4","gravatar_id":"","url":"https://api.github.com/users/adaptun","html_url":"https://github.com/adaptun","followers_url":"https://api.github.com/users/adaptun/followers","following_url":"https://api.github.com/users/adaptun/following{/other_user}","gists_url":"https://api.github.com/users/adaptun/gists{/gist_id}","starred_url":"https://api.github.com/users/adaptun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adaptun/subscriptions","organizations_url":"https://api.github.com/users/adaptun/orgs","repos_url":"https://api.github.com/users/adaptun/repos","events_url":"https://api.github.com/users/adaptun/events{/privacy}","received_events_url":"https://api.github.com/users/adaptun/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-23T13:05:22Z","updated_at":"2018-11-23T13:58:16Z","closed_at":null,"author_association":"NONE","body":"npm test on Windows prints garbled Cyrillic symbols:\r\n\r\n```\r\nC:\\work\\aodbc-master>npm test\r\n\r\n> cacheodbc@0.0.2 test C:\\work\\aodbc-master\r\n> mocha test/**spec.js --reporter spec --full-trace --timeout 5000\r\n\r\n\r\n\r\nODBC Connection integration tests\r\n1) should connect with dsn, username, password\r\n√ should return connected for new instance\r\nDBMS Name: InterSystems Iris\r\n√ should display name of the dbms\r\nDBMS version: Cache Objects Version 2017.2.2.865 Cache xDBC Server 8.01\r\n√ should display version of the database\r\nDriver name: IrisODBC3564.DLL\r\n√ should display driver name\r\n- should display catalog name\r\nDatabase name: SAMPLES\r\n√ should display dabase name\r\n- should return disconnected after disconnect\r\n- should reconnect after disconnect\r\n√ should do do nothing on connection close\r\n√ should create with default constructor and no timeout args (100ms)\r\n√ should create with default constructor and timeout args (44ms)\r\nError: null\r\n√ should execute query 1 (73ms)\r\nError: null\r\n√ should execute query 2 (241ms)\r\nError: null\r\n√ should execute query 3 (87ms)\r\nError: null\r\n√ should execute query 4 (619ms)\r\nError: null\r\n√ should execute query 5\r\n- should execute query 6\r\n[ { Name: 'Davis,Brian O.',\r\nDOB: 1969-12-31T23:59:59.000Z,\r\nSpouse: 51 },\r\n{ Name: 'Davis,Dave Z.',\r\nDOB: 1970-01-11T09:24:22.784Z,\r\nSpouse: 29 },\r\n{ Name: 'DeLillo,Xavier U.',\r\nDOB: 1969-12-31T23:59:59.000Z,\r\nSpouse: null },\r\n{ Name: 'Drabek,Alexandra O.',\r\nDOB: 1969-12-31T23:59:59.000Z,\r\nSpouse: 19 },\r\n{ Name: 'Dunlap,Jane A.',\r\nDOB: 1969-12-31T23:59:59.000Z,\r\nSpouse: 84 },\r\n{ Name: 'Dunlap,Mark J.',\r\nDOB: 1969-12-31T23:59:59.000Z,\r\nSpouse: 6 },\r\n{ Name: 'Dunlap,Pam U.',\r\nDOB: 1969-12-29T00:13:19.872Z,\r\nSpouse: null } ]\r\n√ should call stored procedure (196ms)\r\n\r\nODBC Statement integration tests\r\n√ should create prepared statement\r\n√ should execute prepared statement with no args 1\r\n√ should execute prepared statement with no args 2\r\n[ { Q: '1' } ]\r\n[ { Q: '2' } ]\r\n√ should execute prepared statement twice 1\r\n[ { ID: 111, Name: 'MacroSoft Corp.' },\r\n{ ID: 129, Name: 'MacroSoft Corp.' },\r\n{ ID: 198, Name: 'MacroSoft Corp.' },\r\n{ ID: 149, Name: 'MetaData Partners' },\r\n{ ID: 116, Name: 'MetaPedia Partners' },\r\n{ ID: 154, Name: 'MetaTel Corp.' },\r\n{ ID: 187, Name: 'OptiData Holdings Inc.' },\r\n{ ID: 141, Name: 'OptiSystems Holdings Inc.' },\r\n{ ID: 115, Name: 'TeraDynamics Associates' },\r\n{ ID: 136, Name: 'YoyoTel LLC.' } ]\r\n[ { ID: 110, Name: 'MacroSoft Corp.' },\r\n{ ID: 111, Name: 'MacroSoft Corp.' },\r\n{ ID: 125, Name: 'MacroSoft Corp.' },\r\n{ ID: 129, Name: 'MacroSoft Corp.' },\r\n{ ID: 198, Name: 'MacroSoft Corp.' },\r\n{ ID: 149, Name: 'MetaData Partners' },\r\n{ ID: 116, Name: 'MetaPedia Partners' },\r\n{ ID: 112, Name: 'MetaSoft Group Ltd.' },\r\n{ ID: 122, Name: 'MetaSoft Group Ltd.' },\r\n{ ID: 154, Name: 'MetaTel Corp.' },\r\n{ ID: 187, Name: 'OptiData Holdings Inc.' },\r\n{ ID: 141, Name: 'OptiSystems Holdings Inc.' },\r\n{ ID: 191, Name: 'QuantaGlomerate Corp.' },\r\n{ ID: 115, Name: 'TeraDynamics Associates' },\r\n{ ID: 136, Name: 'YoyoTel LLC.' } ]\r\n√ should execute prepared statement twice 2 (75ms)\r\n[ { ID: 111, Name: 'MacroSoft Corp.' },\r\n{ ID: 129, Name: 'MacroSoft Corp.' },\r\n{ ID: 198, Name: 'MacroSoft Corp.' },\r\n{ ID: 149, Name: 'MetaData Partners' },\r\n{ ID: 116, Name: 'MetaPedia Partners' },\r\n{ ID: 154, Name: 'MetaTel Corp.' },\r\n{ ID: 187, Name: 'OptiData Holdings Inc.' },\r\n{ ID: 141, Name: 'OptiSystems Holdings Inc.' },\r\n{ ID: 115, Name: 'TeraDynamics Associates' },\r\n{ ID: 136, Name: 'YoyoTel LLC.' } ]\r\n√ should execute no args prepared statement\r\n[Error: c:\\users\\travis\\build\\theconst\\aodbc\\nanodbc\\nanodbc\\nanodbc.cpp:1843: ]\r\n√ should close statment and not query thereafter\r\n\r\nODBC Transaction integration tests\r\n√ should create transaction\r\n√ should commit transation (91ms)\r\n√ should rollback transation (101ms)\r\n\r\nBIGINT spec\r\n[2018-11-23T12:49:27.514Z] [{\"id\":\"M13\",\"val\":\"8191\"},{\"id\":\"M17\",\"val\":\"131071\"},{\"id\":\"M31\",\"val\":\"2147483647\"},{\"id\":\"ZMAX\",\"val\":\"9223372036854775807\"},{\"id\":\"ZMINA\",\"val\":\"-999999999999999999\"},{\"id\":\"ZZZZ\",\"val\":null}]\r\n√ should convert big integer datatype (48ms)\r\n\r\nBINARY spec\r\n√ should convert binary datatype (39ms)\r\n\r\nBIT spec\r\n√ should convert bit datatype\r\n\r\nshould convert VARCHAR(15) datatype\r\n√ should successfully convert values\r\n√ should not fail if value is not in range\r\n\r\nshould convert CHARACTER VARYING(15) datatype\r\n[2018-11-23T12:49:28.376Z] c:\\users\\travis\\build\\theconst\\aodbc\\nanodbc\\nanodbc\\nanodbc.cpp:1626: 4200: [Iris ODBC][State : 42000][Native Code 1]\r\n[C:\\Program Files\\nodejs\\node.exe]\r\n[SQLCODE: <-1>:<������������ SQL-��������>]\r\n[Location: <Prepare>]\r\n[%msg: < ��������� SELECT, ���������� ������������� (name)^INSERT INTO ( name>]\r\n√ should successfully convert values\r\n√ should not fail if value is not in range\r\n[2018-11-23T12:49:28.622Z] c:\\users\\travis\\build\\theconst\\aodbc\\nanodbc\\nanodbc\\nanodbc.cpp:1626: 4200: [Iris ODBC][State : 42000][Native Code 1]\r\n[C:\\Program Files\\nodejs\\node.exe]\r\n[SQLCODE: <-1>:<������������ SQL-��������>]\r\n[Location: <Prepare>]\r\n[%msg: < ��������� SELECT, ���������� ������������� (name)^INSERT INTO ( name>]\r\n\r\nshould convert CHAR VARYING(15) datatype\r\n√ should successfully convert values\r\n√ should not fail if value is not in range\r\n[2018-11-23T12:49:28.896Z] c:\\users\\travis\\build\\theconst\\aodbc\\nanodbc\\nanodbc\\nanodbc.cpp:1626: 4200: [Iris ODBC][State : 42000][Native Code 1]\r\n[C:\\Program Files\\nodejs\\node.exe]\r\n[SQLCODE: <-1>:<������������ SQL-��������>]\r\n[Location: <Prepare>]\r\n[%msg: < ��������� SELECT, ���������� ������������� (name)^INSERT INTO ( name>]\r\n\r\nshould convert CHARACTER(15) datatype\r\n√ should successfully convert values\r\n√ should not fail if value is not in range\r\n[2018-11-23T12:49:29.166Z] c:\\users\\travis\\build\\theconst\\aodbc\\nanodbc\\nanodbc\\nanodbc.cpp:1626: 4200: [Iris ODBC][State : 42000][Native Code 1]\r\n[C:\\Program Files\\nodejs\\node.exe]\r\n[SQLCODE: <-1>:<������������ SQL-��������>]\r\n[Location: <Prepare>]\r\n[%msg: < ��������� SELECT, ���������� ������������� (name)^INSERT INTO ( name>]\r\n\r\nshould convert CHAR(15) datatype\r\n√ should successfully convert values\r\n√ should not fail if value is not in range\r\n[2018-11-23T12:49:29.447Z] c:\\users\\travis\\build\\theconst\\aodbc\\nanodbc\\nanodbc\\nanodbc.cpp:1626: 4200: [Iris ODBC][State : 42000][Native Code 1]\r\n[C:\\Program Files\\nodejs\\node.exe]\r\n[SQLCODE: <-1>:<������������ SQL-��������>]\r\n[Location: <Prepare>]\r\n[%msg: < ��������� SELECT, ���������� ������������� (name)^INSERT INTO ( name>]\r\n\r\nshould convert LONG VARCHAR(15) datatype\r\n2) should successfully convert values\r\n√ should not fail if value is not in range\r\n[2018-11-23T12:49:29.744Z] c:\\users\\travis\\build\\theconst\\aodbc\\nanodbc\\nanodbc\\nanodbc.cpp:1626: 4200: [Iris ODBC][State : 42000][Native Code 1]\r\n[C:\\Program Files\\nodejs\\node.exe]\r\n[SQLCODE: <-1>:<������������ SQL-��������>]\r\n[Location: <Prepare>]\r\n[%msg: < ��������� SELECT, ���������� ������������� (name)^INSERT INTO ( name>]\r\n\r\nshould convert LONGVARCHAR(15) datatype\r\n3) should successfully convert values\r\n√ should not fail if value is not in range\r\n[2018-11-23T12:49:30.021Z] c:\\users\\travis\\build\\theconst\\aodbc\\nanodbc\\nanodbc\\nanodbc.cpp:1626: 4200: [Iris ODBC][State : 42000][Native Code 1]\r\n[C:\\Program Files\\nodejs\\node.exe]\r\n[SQLCODE: <-1>:<������������ SQL-��������>]\r\n[Location: <Prepare>]\r\n[%msg: < ��������� SELECT, ���������� ������������� (name)^INSERT INTO ( name>]\r\n\r\nshould convert date and time\r\n4) should convert dates and times datatype\r\n\r\nshould convert integers\r\n√ should convert integers in range (43ms)\r\n√ should fail to convert integers not in range\r\n\r\n\r\n41 passing (7s)\r\n4 pending\r\n4 failing\r\n\r\n1) ODBC Connection integration tests\r\nshould connect with dsn, username, password:\r\nUncaught AssertionError: expected [Error: c:\\users\\travis\\build\\theconst\\aodbc\\nanodbc\\nanodbc\\nanodbc.cpp:996: 0100: [Iris ODBC][State : HY000][Native Code 417]\r\n[C:\\Program Files\\nodejs\\node.exe]\r\n�������� � ������� [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). ] to be null\r\nat nc.ODBCConnection.connect.err (C:\\work\\aodbc-master\\test\\connection.integration.spec.js:25:30)\r\n\r\n2) should convert LONG VARCHAR(15) datatype\r\nshould successfully convert values:\r\n\r\nAssertionError: expected [ Array(4) ] to deeply equal [ Array(4) ]\r\n+ expected - actual\r\n\r\n[\r\n{\r\n- \"info\": \"\\u0003\\u00011\\u0019\\u0001%Stream.GlobalCharacter\\u001e\\u0001^Sample.CharacterTestTable0S\"\r\n+ \"info\": \"First party\"\r\n\"name\": \"Alice\"\r\n}\r\n{\r\n\"info\": \"\"\r\n\"name\": \"Bob\"\r\n}\r\n{\r\n- \"info\": \"\\u0003\\u00013\\u0019\\u0001%Stream.GlobalCharacter\\u001e\\u0001^Sample.CharacterTestTable0S\"\r\n+ \"info\": \"Eavesdropper\"\r\n\"name\": \"Eve\"\r\n}\r\n{\r\n- \"info\": \"\\u0003\\u00012\\u0019\\u0001%Stream.GlobalCharacter\\u001e\\u0001^Sample.CharacterTestTable0S\"\r\n+ \"info\": \"Man in the\"\r\n\"name\": \"Mallory\"\r\n}\r\n]\r\n\r\nat Promise.all.then.then.queryResult (C:\\work\\aodbc-master\\test\\types.integration.spec.js:302:45)\r\nat tryCatcher (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\util.js:16:23)\r\nat Promise._settlePromiseFromHandler (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:512:31)\r\nat Promise._settlePromise (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:569:18)\r\nat Promise._settlePromise0 (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:614:10)\r\nat Promise._settlePromises (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:694:18)\r\nat Promise._fulfill (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:638:18)\r\nat C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\nodeback.js:42:21\r\n\r\n3) should convert LONGVARCHAR(15) datatype\r\nshould successfully convert values:\r\n\r\nAssertionError: expected [ Array(4) ] to deeply equal [ Array(4) ]\r\n+ expected - actual\r\n\r\n[\r\n{\r\n- \"info\": \"\\u0003\\u00011\\u0019\\u0001%Stream.GlobalCharacter\\u001e\\u0001^Sample.CharacterTestTable1S\"\r\n+ \"info\": \"First party\"\r\n\"name\": \"Alice\"\r\n}\r\n{\r\n\"info\": \"\"\r\n\"name\": \"Bob\"\r\n}\r\n{\r\n- \"info\": \"\\u0003\\u00013\\u0019\\u0001%Stream.GlobalCharacter\\u001e\\u0001^Sample.CharacterTestTable1S\"\r\n+ \"info\": \"Eavesdropper\"\r\n\"name\": \"Eve\"\r\n}\r\n{\r\n- \"info\": \"\\u0003\\u00012\\u0019\\u0001%Stream.GlobalCharacter\\u001e\\u0001^Sample.CharacterTestTable1S\"\r\n+ \"info\": \"Man in the\"\r\n\"name\": \"Mallory\"\r\n}\r\n]\r\n\r\nat Promise.all.then.then.queryResult (C:\\work\\aodbc-master\\test\\types.integration.spec.js:302:45)\r\nat tryCatcher (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\util.js:16:23)\r\nat Promise._settlePromiseFromHandler (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:512:31)\r\nat Promise._settlePromise (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:569:18)\r\nat Promise._settlePromise0 (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:614:10)\r\nat Promise._settlePromises (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:694:18)\r\nat Promise._fulfill (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:638:18)\r\nat C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\nodeback.js:42:21\r\n\r\n4) should convert date and time\r\nshould convert dates and times datatype:\r\n\r\nAssertionError: expected [ Array(1) ] to deeply equal [ Array(1) ]\r\n+ expected - actual\r\n\r\n[\r\n{\r\n- \"birthday\": [Date: 1969-12-17T04:26:57.536Z]\r\n- \"last_visit\": [Date: 1970-01-18T11:31:17.888Z]\r\n- \"last_visit2\": [Date: 1970-01-19T08:31:17.888Z]\r\n+ \"birthday\": [Date: 1995-01-01T21:00:00.000Z]\r\n+ \"last_visit\": [Date: 2003-08-31T21:00:00.000Z]\r\n+ \"last_visit2\": [Date: 2003-09-01T18:00:00.000Z]\r\n\"name\": \"Alice\"\r\n}\r\n]\r\n\r\nat Promise.all.then.then.queryResult (C:\\work\\aodbc-master\\test\\types.integration.spec.js:376:41)\r\nat tryCatcher (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\util.js:16:23)\r\nat Promise._settlePromiseFromHandler (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:512:31)\r\nat Promise._settlePromise (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:569:18)\r\nat Promise._settlePromise0 (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:614:10)\r\nat Promise._settlePromises (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:694:18)\r\nat Promise._fulfill (C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\promise.js:638:18)\r\nat C:\\work\\aodbc-master\\node_modules\\bluebird\\js\\release\\nodeback.js:42:21\r\n\r\nnpm ERR! Test failed. See above for more details\r\n```"},"comment":{"url":"https://api.github.com/repos/theconst/aodbc/issues/comments/441247597","html_url":"https://github.com/theconst/aodbc/issues/1#issuecomment-441247597","issue_url":"https://api.github.com/repos/theconst/aodbc/issues/1","id":441247597,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTI0NzU5Nw==","user":{"login":"theconst","id":22099031,"node_id":"MDQ6VXNlcjIyMDk5MDMx","avatar_url":"https://avatars0.githubusercontent.com/u/22099031?v=4","gravatar_id":"","url":"https://api.github.com/users/theconst","html_url":"https://github.com/theconst","followers_url":"https://api.github.com/users/theconst/followers","following_url":"https://api.github.com/users/theconst/following{/other_user}","gists_url":"https://api.github.com/users/theconst/gists{/gist_id}","starred_url":"https://api.github.com/users/theconst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theconst/subscriptions","organizations_url":"https://api.github.com/users/theconst/orgs","repos_url":"https://api.github.com/users/theconst/repos","events_url":"https://api.github.com/users/theconst/events{/privacy}","received_events_url":"https://api.github.com/users/theconst/received_events","type":"User","site_admin":false},"created_at":"2018-11-23T13:58:16Z","updated_at":"2018-11-23T13:58:16Z","author_association":"OWNER","body":"Hi, the problem is that you are currently trying to use Unicode enabled driver.\r\nThe support is intentionally disabled for the first release (this will cause issues for people trying to use unixodbc + cache driver on Linux and MacOS). \r\nI probably will need some help on correctly setting up ODBC via iODBC driver manager. I was blocked by the issue https://github.com/nanodbc/nanodbc/issues/99. I will submit PR to guys as soon as I figure out how to fix it.\r\nPlease download artifacts from https://github.com/theconst/aodbc/releases/tag/release-0.0.3 and copy them to /build/Release/ folder inside the project folder and rerun the tests again (you may copy only windows release files)."}}
{"actor":{"display_login":"theconst"}}