topic How to read data beyond ASCII(0) from ADO/MSDASQL in QlikView https://community.qlik.com/t5/QlikView/How-to-read-data-beyond-ASCII-0-from-ADO-MSDASQL/m-p/208945#M715476 <HTML><HEAD></HEAD><BODY><P>some additional information: the field is defined as a fixed length string (char(320)) database type. as I understood from articles on the net, the ADO/MSDASQL engine normally expects char(0) as the EOS character. However, when copying the table through DTS to a SQL Server 2000 database, ALL data in the field (including the null char) gets copied. So there must be a setting in the driver/receiving engine that capacitates that, I just haven't found it yet.........</P><P>Thanks</P></BODY></HTML> Fri, 15 Jan 2010 09:58:19 GMT happydays1967 2010-01-15T09:58:19Z How to read data beyond ASCII(0) from ADO/MSDASQL https://community.qlik.com/t5/QlikView/How-to-read-data-beyond-ASCII-0-from-ADO-MSDASQL/m-p/208944#M715475 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Hope that someone can help me on this one: I am reading data from a database using either ODBC or OLE DB connection. In the record, I have one field that contains a string of characters, of which some, or all are the ascii 0 character (chr(0)), which is usually the end of string character for this type of connection. Hence, only data up to the ascii 0 character is read, the rest is discarded. Does anybody know how to circumvent this, and load all data from this field, including the ascii 0 characters? All help is welcome!</P></BODY></HTML> Tue, 12 Jan 2010 17:15:16 GMT https://community.qlik.com/t5/QlikView/How-to-read-data-beyond-ASCII-0-from-ADO-MSDASQL/m-p/208944#M715475 happydays1967 2010-01-12T17:15:16Z How to read data beyond ASCII(0) from ADO/MSDASQL https://community.qlik.com/t5/QlikView/How-to-read-data-beyond-ASCII-0-from-ADO-MSDASQL/m-p/208945#M715476 <HTML><HEAD></HEAD><BODY><P>some additional information: the field is defined as a fixed length string (char(320)) database type. as I understood from articles on the net, the ADO/MSDASQL engine normally expects char(0) as the EOS character. However, when copying the table through DTS to a SQL Server 2000 database, ALL data in the field (including the null char) gets copied. So there must be a setting in the driver/receiving engine that capacitates that, I just haven't found it yet.........</P><P>Thanks</P></BODY></HTML> Fri, 15 Jan 2010 09:58:19 GMT https://community.qlik.com/t5/QlikView/How-to-read-data-beyond-ASCII-0-from-ADO-MSDASQL/m-p/208945#M715476 happydays1967 2010-01-15T09:58:19Z