How load Image in QML from SQLite "BLOB"

[filipdns]

Hello,

I'm using QSLite to store data and one of the column named logo contain "BLOB" file with the image of the company logo.

When I'm trying the have Image source with this data, I receive an error:

QML Image: Cannot open: qrc:/qml/?PNG%0D%0A%1A%0A%00%00%00%0DIHDR%00%00%00?%00%00%00?%08%06%00%00%00?%3Ea?%00%00%11.IDATx??%09x%13????4I[Z?%22?(??.X%11?%1D?C?,?%17%3C?@?E%04D?%02?%5C+ ?p???%7BYG,?A.?%01%05AV?+.(e) ???I?4i?m&s??Bi:i?.?$3????4_f????o?m?OV??%3C?hn?(@?lWG?U?IHe%7CK?qxo???%25?e?%1B??%05T??%25?B?%25.s$%12??b?????v??L?UCC ?[@??%3E?%02?%7C?:%7D0?%0F%3E?z%13u%06%60??%5E???%15!?B7k%0E ???U_?x1vl?U%03S%0Ah%06%0E?UC%7D?Z%03?%06??F??%0F?? ?B?5???%1B??5%00?%017%09sv6?'??A??8?]??-??%12?%06%60?%1DN??%1B%03w?O?i???[??%25?%0D?@[?Q2f%04??.?%22?k?%021a%00%06????a?%18%0Ay??ZK??1%00%03y?%00F?%04???%1D??@L%19??w%1E??%1Du?%1D??@?%19??y?%14L?%5E%04(2??Fc)%10?%06%60p%7C?%1F??fTv%18??h+%05b?%00%0C%15[??,???%19m?@L%1B??%7C?%7F??%15a?3?J??7%00?%25?=??%09[~????f?P%10%06?mv?%17?%1A?%0C?%14F%01?0%00%03u?zX??%02?0??es$.%0F??()%05?%5CW%0Dy?%191%0A??-%01???9!??Pj?%07Qi@%10??D-?-R%00%22?%5E?,%05?#??%0EF?%01%08?%1AMw?%05???-??%60J???%60??Z??[%00mw?c1?-??Q?%1F%0Cy??%7C??1%00(%0FJgN?%0F?Q!%08???@?%18%00???0??%00u?%1A?R%1A%14U?%0C(?:?-?'%11e%00%06??%1FP???p%1C??? ???=@&?[%09??3%00???%0A??????.??4%18???P?%1F?28D?%01?N?%60?????%1F?-???N??%19?%11k%00%06??F?Y???%18?=%7C?7???G7?ex%11?%06???o?%60?6%3E&Z%08?%08%1B)?%0A%030?w%7D?%10%3C?[%7CK?%17L)%10I?%05??%00??B??%07??Y???%0Bu?t?%25T%11U%06%60?%0A??0(%1D?#??Rg??x?%25T%11u%06%60?X?a%1C?%09??k?%3E?!p%7D%7B?o%09UD?%01XH%0A???Q2~%14h??o5?A?mZ%07??%7C+?%22?V%08?%3C?!$m?%04?%7D?%1A4??%5C%02??%03?????tE9%7B%11????'?H?v??,p?p%1A?????????%3E%7B%1E?%01%7D??a#d6L??c?%170?%0A???A?E?%7B%0B?%01Ud?a?%10?%7F%3C?%00?H????X2%00%03s???yh??W/?2?%1ALW$%13S%06?%16???????9?$%3E??E??F?%19??m!?????%07%3CT?K?s?%1BEZ?%11?%06?M?%07kQ21???%1E%22?9?%1BES?%11?%06??D%0D??v%25??%14i]????tE%0A1o%00%06??gQ?;?%7Bv?t%5E?Q?%0E%60 b??%02???(%7F?7?G?em?#nCF??'?1%00??F??90?%01?t%05u?n?k ?F??%17?2?ml???d???%12??G%0Bh'L%08?.%3E%10?%01%18?G??0?/??C??Y?$%25?EW?%11?%01%18??+0e?%03Ut??q?.%01??Y%17%10?%01?%10?%60H?%03??%1F?%1E???$%09??%0A%17?7%00%03u?%08?!%19?%08%60mH?@7?U?%0A%07?%01nC??(y?E??%10?%05i?fa???%06?%0E?L%5C?%18??1%3E[%08?B%05????%22%16%0D?%03??0d?Z?f?Hv%06R? %1A?%16?KW%60??%07?w???H??%16?%1A%1C?%00~??8?y?wn?JWu?%03e???jHD%03%04?v?a?1%1D?%159%5Ec%08?%0B%16%01??5%22%1A %18h?%3C%17??%13A?%1Cl??'??%18?z#%1A %04?;v?4i,p%7B I?k.$M???X4@?8?%1F?q?%08x?e?=?0?2??-?%5E?%06?%03?o??0?%0Fp??%1DT=z?-?%5E?eA?A%00?Z%09???:#?%00LFT_%7C?%06%10%11%0D pD%03%08%1C?%00%02G4??%11%0D pD%03%08%1C?%00%02'j??Q??%09?l?4O?%01?Q#y?%14?D?%01$%09%09????+?Sr?7=?x%0B%108?%01%04N??%02?E?%07??%5Cu%5Cg~%01u3?%17?n(b?%00M?%07??y????%1D;x?%14I??%00?#%1A@??~%0B ?j???$?%09?B'so&%7F?%15???U?e%12(;%3E%09??Ai?),????n%15?=????;@?M%00e,???Ix?u[?Z??%0A?;C??%5EH?%09??- %0B??y?%18?%1B?????a?oA??%1E74?B?a?5Q??%01?78?e?%05?%11?%25?em~???%17???%1B?6%0F?O??%15 /??q? l%1B??seM7s6???%7D?5???%0D?i?????Z2?#?S?C?/ ???1u?%00?? /?#%3E;?%13????U??%0F??v?T??cD???%7C%0E??KA?8?Z??%06??%0CN,Ir?S?#!?O?%7C?1%14??#X?a?%06??@E?h??KN?e?BXW??????(?!?%5C@Q????l?r%19?%0B%16@;~???%0B??@??%5CXV?%7Dp?:?!C???%7F??%3C%257Q??Q????%02?%5C4??%10@?E?4??9e%3C??G?h??I?%1B?????%0BB??5????%3E?F???6?+M??%11Ik7B?i?%7F%0B??K(%19;%02??=?o%1D?u??%0D%1C??O%06?lx?g;q.%3E?e?;w/?B??%0F7B;qf??O??f/@?5??)%1C???%01/%3E??%7B?%7D?%1E????%15~/%3E???%08%22??H??/%3E??%1E??%01$%7D?%19???%02W%01+??ur????%0C????t?fq?u??%04?%17????%7F%1D?n?O?V?7%14????A?%14?f?m?x?%04=%12??ew%0Dm%08??%03B?B???%5E%18%06?c??P?x??%1DT?!k?%0E??,?:%03e???g8???%3C??W)%7F4%15??s?%7F?ws??ny?6??~Mh%0F?9?i?x??N???%09?:t3?@%12?%0B$?%0A?(?y%03??;k??S?3?E%15V?%1Fh?%00?%12u?JgMBq?N0?%19%02??A?%1F?9%06?%04?=????%19%13p?S*%0C%19???2???????%1AQ?5%11?%1F??=%06%13??J?4???]?:?V%00SQQ?N????'??c?B???%03?eQ3%17??'???u?%7B??%3E?%7D?k3?e??%60?%15?K?@3?%25??%08?%0E???CRm?H????K??k?%5C?rc?~NG??W%1FN%0C?K6%0C?%7F??%7F?%12?G????%22????U?;?15u????%5C???%5E??%09?n%03T%7Dj%7F?P?+??T??9?J?k??YK??A%5E??3vP?%00?s%17%60??%19'];u&%14??B?o ?3???z????+?%7D?g????a??%06U?m????%16??!T2H[??Wl???#)XW?5%60L?C??x?m???U?u?%0A??d?S8iL?O?t%17?K?%7B???6??%0E?#?%7C%09g?.E?????%16????y?%00?G??J?&??I%5E:?3/?M??%7C??.m?%18????r?I???e??e??j-7?-???%22?Tq%01??D[?%03?Aw%041E%08?%60??L???5%17M?aY?m#S?%22????DYJ?ZTI M????)m???%3CV%07??%15j?%14%1D?%02??%1C?x??1i?%1D?R?%7D?SL)?]?J???r3'???NX???Uu????!u%05[s?U=%1A]%1B???:?#'?u????%3C?1h??%7D0m??7?%25Zk?%3E?K(r??C?%7D?%1B[?%3E%18?%5E???C?/;%60H?%0A?%04Su?%0D??!??Z6??N~c???8i??D??%22????5?%1DB?%0A&%0Bn????%7D?L??%7D??b?fhF??'?%0Fi???%0D%12?%1E?W?B?%3E?%1B???8?x??:??%07?#5~?%12)??o??up?8%0AY???N??%19%18%08Oo %7F?C?T%02?+%3E??[w8%0F%1D??UkL45%60%3C???m?j?heZ%17?%1Fi?.ty%07?=IH??O%10q?n?%1E%0A?%7Dz?c?iF?O%07?S%1F?=%7B%0F?l?N%1D?a??Z?M?t;???%07??%17?]?%60?z?%19%19?'?%0E???%1A?p??y3?%7B?$%08%15??8X??%04?????lZ%06C???%15%7F??~?V?%7D?.?%7F?$%5E??Qc!m?]%09t%1C?%17J%5E??G4??@??sl)?eo?=?%3C?%15Vt??%05W%60~sA??%02u?%10eos?1?%0A?%7F%05?%5C??G(?-%5E%08??%7B?:Ib2?F?GB?r?%7B?s?i?%0Deo??o?:%0D%07?u?%1A?19%0E%7D%09???G?v%0D?%11?B?????0%0E%1B?????6?%03e9?%3E?V??=p%7C?;?x??aY?%08 k?GW??%7B%7B?X?R3??%06??G0x?f?L?%04y????4%1C?p%09?K!??xU???%25?w%1EE%7F?%06?,?e??Y?c???%0Bl%1B??y3?T%09Ut%13??%7B??h%0Bw????%7D?B?9?6??%7C%00A=?N?%02?s? I???N?p??%7FX?/??R%06???v%18%13???A???Pv?%06Y?6?%18%07e(?????%5E%09e?4n??i?R?x@?h?%1F??1/@?#?%09?1?%7D??u?%60FR?]!?%00?%0F?????'?C?%1Bp??%03UT?????h?).???8;??p~?wK??-%1FE?r;??i???%1CDB%02?t?*)%02u=??s~'???%7C%3E?Hh??i%00%60%08???7%17@?????%0A?@?%199?s%1C?%1F?;???p??%07??%19A1?L%09?s???Ra]?%1CT?5??@;i:d??%1Db??%07?%22S%5C$?????%14?%1C8%5E?%0Dm??W?Q?WP3z?8)????%0C0M%1E?6?B??sq??%5C%7C?%06h%5C?G???%07??%7D?q?%22a?%1E??????x%0B%08%13??i?%0C%1B%05U???$?%1D????c?W(_?%16?%15???%1A%03?%00%3C@h%14 ?R?N%12??O?S%18%10[%01%3C@W?????%11?%00%02G4??%11%0D pD%03%08%1C?%00%02G4??%11%0D pD%03%08%1C?%00%02G4??%11%0D pD%03%08%1C?%00%02G4??%11%0D pD%03%08%1C?%00%02G4??%11%0D pD%03%08%1C?%00%02G4??%11%0D pd?FA%11Z%25w%05%06%11A??%00%00%00??LD%04?%3E???%00%00%00%00IEND?B%60?

my code is a simple SQLite JS query working with all other column:

function dbReaddata(i)
{
    var name;
    var meta;
    var flux;
    var logo;
    var row;
    var db = dbGetHandle()
    db.transaction(function (tx) {
        var results = tx.executeSql(
                    'SELECT rowid,name,metadata,flux,logodir,logo FROM radiolist order by rowid asc')
                                 row= results.rows.item(i).rowid
                                 name= results.rows.item(i).name
                                 meta= results.rows.item(i).metadata
                                 flux= results.rows.item(i).flux
                                 logo= results.rows.item(i).logo

    })
    return{row:row,name:name,meta:meta,flux:flux,logo:logo}
}

import QtQuick.LocalStorage 2.0
import "../js/database.js" as Db

Image{
        height:500
        width:500
       source: Db.dbReaddata(index).logo
}

How can I solve my problem please?

Kind regards

[dheerendra]

I don't think you will be able to achieve this from JS Script method. Please note that source property is Url type. So when you give the name, it is searching the same in resource file. Hence it is giving the error. I feel the only option is to go through QQuickImageProvider from C++ side & register custom ImageProvider.

[raven-worx]

@filipdns
In QML it's only possible to display images by specifying an url (except for a custom painted item of course)

I am not 100% sure, but it should be possible to display base64 encoded data url.
Try the following (untested):

var base64Str = btoa(unescape(encodeURIComponent(results.rows.item(i).logo))) // or 'btoa(results.rows.item(i).logo)'
var imgUrl = "data:image/png;base64," + base64Str

[filipdns]

@raven-worx Thank you very much, I will try that this evening

[filipdns]

@raven-worx thank you very much.

the part of code is working when I encode to base64 the image with online encoder

var base64Str = "iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAYAAADDPmHLAAARLklEQVR4nOydCXgT5b7G38meNElbWvQiy6EoqPQqLlgR4bAdlkOlLLIXPIhA2UUERKoC51wrIPZwgIPXe1n0oCzCQS7KAQVBVoErLihlKSCWpbRJ0zRpmm0mc56ZQmk6aZYumSQzv+fJ8zRfZv7f28ybb75tvk9W1POxPMpoboEoQPlsV0eTVetJSGV8S4FxeG+t+8IlvmXUG6LwibYFVJGpJd9CgiUucyQSlq5ipPOqw/75dpimTOZVQ0Mg4VtAqNg+2QLLkoV8y4A6fTDkDz7At4x6E3UGYLCuXoPytav4FSGRQjdrDiCNyq+wiqhVX7Z4MSp2bOJVA1MKaAYO5FVDfYlaA4AGzK/ORsXWD/nTIJFCmzWVv/wbgOg1AOMBNwlzdjacJ4/ypkGe+jiUXZ7hLf/6EtUGYKAdTpSMGwN33k+8adDPnsdb3vUl6g3AQFvLUTJmBMjfLvOSvyKta9SWAjFhAAaq2IiSzGHwGAp5yT9aS4GYMQADebUARsYEltKw5x2tpUBMGYDBnXcepvGZoB32sOcdjaVAzBmAwXniFEzTXgQoMqz5RmMpEJMGYHB8uR+l82ZUdhiEkWgrBWLWAAwVW7ehLOfNsOYZbaVATBuAoXzNf6P8gxVhzTOaSoGYNwCDJfc9uM+dCVt+io6do2akUBAGoG12mBe8Gr4M74wURgGCMAADdfN6WPOLlvkCgjCAtGVzJC4P8/yBKCkF+J9cVw15+4egGTEKspYtAbmc8zkhlYJQavwHUWlAENKqt5JELaQtUgAi/F6vLAWWI5LnDkaMAQitGk137gWh0fItpeFgSoHZ82DKmsS3klqJmFsAbXfCYzHzLaPBUfcfDHnqw3zLqJWIMQAoD0pnTuGlD79RIQjoX4ncukDkGACA8/i3MI7IAHXrGt9SGhRV3wwo0jryLcMnEWUABtfpH1Dc6/dwHNzLt5SGgyCQuPQ9QCblWwmHiDMAg6fMCtP4P8Hx1S6+pTQYsrapUP+xH98yOESkAcBO+KRgmpyFiu0f8y2lwdBOirwZxBFrAAba5UbprFmwvLsYoD18y6k3isefhqpHN75leBHRBriD9W+rYJo2PiZaCLoIGymMCgMw2Hd9wbYQPMZbfEupF0wpEEnzBaLGALjTQsjoB/LiWb6l1At133S+JVQRVQZgoAquwzAoHc4j+/mWUmeIhHi+JVQRdQZg8FjKYRybCdvHa8M+8bMhcH17jG8JVUSlAVhICub581EyfhRom4VvNcFB07BtWgfblq18K6ki6lYI8YU89SEkbdgE6X2tGjSux1wC5+EDoIqL2fd0RTl7Eb2h4bHZuCe7SNB2192jKixw/XAa5NXI6uaOmOHg+uA+ex6GAX2RtGEj5I82TJ+7Y98XMM2YCrq8okHiRSrRewuoAVVkgGH4ELh/PNUAwUiY582O+YuPWDIAA3PBjKOHw3loX73ikFcvgDKYGkxXJBNTBsCdFsKfxsD28f/WOYYkPpHvRcjCRswZgIVtIbyOsr/MBzxUyKdLku+D8pmnG0VapBGbBrhN+QdrUTIxs7L2HiL6OfMbRVOkEdMGwO2HRA3Pp4O6diWk8xRpXaHq3avRdEUKMW8ABvfPZ1Hcuzvse3aGdF78goVRvw5gIGL7v6uGp7wCpqyJKH8/N+hHxmVt2yNuxIhG18YngjEAi4dG2ds5MM+bAZp0BXWKbvZrINSqRpfGF8IywG1sm7agZOzQoNYSkv5HC2gnTAiLLj4QpAEYnEeOwzCwL8iCwJVD3dRZkCQlhEVXuBGsARjI/CswZY0DVXTD73GELgGa4bFZFxC0AcC2EPJgSO8D99kf/B6nm/4qJAn6sOkKF4I3AAN1qwiGIRnsCGBtSOKbQDfj5bDqCgeiAW5D2+woeelFv/sQxL2YBWmLZmHV1diIBqgO00xctBimrDE+WwiEQgX93NjqIhYN4AP77r0wZPT1ufi0ZvBIdgZSrCAaoBbIS1dgyOgH13fHvT+QSKFf8BZfshoc0QB+8JSUwjj8edh3bvFKV3XrA2XXzrzpakhEAwSAdrlhmjEd1hU5XmMI8QsWAZLonzUiGiAYaMCyPBemmRNBuxxskvyRJ6DOGMC3snojGiAE7Dt2wjRpLHB7IEk/ay4kTaK7i1g0QIg49h+EcdwIeKxlkD3wMOIyx/ItqV6IBqgDzm+OwDDgD3D/9B1UPXrzLadexMSTQbxBAIRaCbrCybeSOiOWAPWBRlRffIgGEBENIHBEAwgc0QACRzSAwBENIHBEAwgc0QACJ2qXiFH17An9nGyvNE+ZAcZRI3nTFI1ErQEkCQmQP9rBK81TcpM3PdGKeAsQOKIBBE7U3gKCRdW7B7vdXHVcZ34BdTO6F51uKGLeAE3WrAeh1nmllc6chIodO3jTFEmItwCBIxpA4PB+CyC0asjbtoMkqQm7QidzbyZ//RW0i+dVwGUSKDs+CdmD7UHEqeApLILz2+OgbhXXPeT9v4P8PztAok0AZSyE6+RJeMx1W+haltIKyqc7Q9LsXkj0CaDLLSALrsF5/BioG4XBx/H3Yfybb0H5jPceNzTpQsmYYeyCjDVR9ewB/Zw3OOll77wF5xHvJdJlbX6HuMwXoOrVG7I2D7JP3LDxnRUgL+TBceggbBs/qnNlTTdzNtT90n3uNayfmw3thGns36aXp4DMv+j1uTKtI7RTp0PVoy8gvbuHMXWzANbVuSAv5yM+O4cTt7i/71XF5A+1g3byVKj69IdE36Qqnbx8DpblS0HbKjidWrTTBsPgDE4sSXLlU8qaoSMhiU/ifO4xFMK26SNY16xh4wbC75xARdqTaLrjS066ZclCWFf/nZPe9PPd7JYo1SGvXEBRj67szqBshnIZ9AsWQDt+iteX6wva5UD56lxYVvyVfXCzOpohQ5C48n+80jwlN1HY4VH274SluazBAsFcNPeZnyrfEED8okXQvjTd7znklTzI2rTnpN9okcxJixubifg/vwtCrqg1nvvs95CnPuGVRtutuNk2xStNkdYRSWs3QtKkaaB/C+TVSygZOwLkr7/5Pc5vHcB16rTPDRzjxk8GofS+eMpnO3EuPoNl+Tt3L75CjqQPN0I7cWbAi4/bT+PqZi9AkzXvh+UpHP3s2QEvPtjSi3vxfaEekI6EnBV+Lz7Y5e6fCCLP1kj+x6e+Lz7l5h7f+gEkfbQZhMb/AlcBK4HW95Zy1siX3tMMmqHDvNJ002ZxznXn/QT7F7ur3utffx3KbqFPo1Y/NxS6qY27557sgRToZsxtsHiSBD0S3slldw1tCOL/kgNC671CifPgXhgG9MSN1s1Q+Hi7yh1UqiFr0w66rCz/OgNl7PrxZzi++pyTrp08vepXKX80Fcrfc+9/lndzqopuebs2lcV+TWgPuzmkadp4mOdOh+v0CZ86dDPnQBKvCyS3CvuenSjLeQO0mztr177rU/Yz5kUVVo4faF+cAMi4pRJ1/SpKZ01Ccc9OMI4ZAueJw0HlH5c5BpIE7j2aKryG0hkTcKtTKgwZveD4MvDuqLLWraCq8cPxlBpRkjURrh/OsLOTPQYTu4NKzb2UNKPH+V34OqhWAFNRUfVOr6qosSemtGO3QrXv3gPd9JdRMxfX9yfh2Pd11XvthMk+i33zazPZZdvuYNu6FYlLlkAz+iWv4wiNDqo/9kPFlm3BSIbzm8PsS//Ka4Bc6fWZY/9+TkeQqlcfTgzmSzYM6n+35n/xEpxHj6Hpp/+EIq2L3/xV/bg7gzE1dcPzz4EqqFyUirpehJIJ45G0bgNUfWp/zlDZpSvn+4VUhuSNmznHSu9r7v2+WUv29kFevuozdlD9AO5zF2Df/RknXTt1JhSPpULdbyDnM8uy//J6r+jE3SvPff5nr4vP4qFhzs4GVcxtysjbPxaM3JAhVDJIW7TmpFds+4Tb7CMpWFf9NWBM+UOp3Hifba26+FXQgHX1Cr+xZK1TOGlM00/xdBfOS9qSe6zs/ja1xg66I8iyfAlnhy5Fh6eQ9OEWr5KBwXnsAJxHv/VKkybfw4lJXjrvMy/aTYK6fJGTLm2aGKzckKis0HLLSeqG7+Fl8ob/ZeXYmGotN94t3/Go4iL/sVRxAfPzh0Rb+wOsQXcEMUUI42DN0Ezv4Mk1F02iYVnGbSNTxiLI9N73RFlK21pUSSBNuZ+T7CltnN3BPFYHwNQVatwqFB2fAtat4xyveOLJgDFppx2EUu193lNMKchdhEqZ1sm/vnIzJ83+xU5Y19S+oFV1qILam4IhdQVbc5dVPRpdG479u+E6/SMn3XWKu5ePPPUxaIbUuH0wbfHsN9glWmviPvdLKHKDx0PDfZ4bW50+GKpe3b3SpK2aQz8vO2BI8gq3BFN17w3N0CHe8Vo2h/71hX5jufPyOGmS5ES2/yKYl8fMNdAdQuoKJgtuwP6vz6DOqH3VTOvffbuyYvtmaEaO46Qn5r4PabPmqNi5DRKdHrpX5kKdPpQbgKbhONB4u4U6vt4H+SM1ftkSKZLWb4Htk3VwnjgKWcr90E6aya4ZGAjnkW8gf7hDjVQCiSs+gLJbdzgPHYCsVWvEvTQ1YDzn0cOVbf1qlWhlWhfIH2nPLnR5B+k9SUje9k8QcdVuPx4KxX16wWP2vWlGyE8Hy1Mfxj17D/ts37pOHYFhyOBaz03+dDuUnbsHm5UX9l3bYJp6txkZqCfwDvfl/xrUcLC0eTPce+gkCBW36zhYqvcEytq2wb37jvlsWgZDzZ7AxBV/49x+mVaKfc8uuH/JgyRej7hRYyFt5V0JdBz4F0peqL1HNOTRQPfZc2wp4IuyZW/7Pdc89xVWdKiQBVdgfnNByOeFAnWjEGVvc8cx6gqZfwWWXP/fRyiULV4IssB72TpJYjLiRo9HQs5y6F97i3PxabsNZW//2W/cOg0Hs3WBGpsxOQ59CdeJ7/yeR/52DcYRg0LavsX98/cwDhvIrtjV2Ng2/ANlOdk+u1aroD1wfLM7qHjWlathWbYIIGuPR1eUw757e8BYnlIzjMMGsd9HMHisZpRMyAR54ZLf4+o0HOy+cAnWlUsh7/B4VZr13SXBnZt3HkV/6AbtpCzEZY7zWdljj7v4C2wb1sK2eTPb9q4JVXQTjoN7vNJoC3evP+fhfYBCzTm3NsrXfADHnj3QTpoC9XODIEm83fdO03Cd+X9Yly+Bx1IG0MH9dhgT2PfsQdzI0VB27QZZ6zbsGAdlKITj4Newrl4JZcc0br3Hh2mYUqp4QD9onh+GuDEvQNGhI6cJ7jHegn33/7F1sWBGUvldIYQA5A+2heyBtpDEJ7NDzZ6iG3CfywNVVMKLpJr6pM2agtBo4SkugsfSODuJ6qbPgH6+d0uA/C0fRc9yO8+85GnVkN3XHERCAuB0gyopAnU9tOFzfieE0ID7fD77ikhogLppAGAI+dT4NxdA2pz7u7K8k8PeCu9AxKmhGTmacxyZH/g7ocvtcF/0X8QHgvcZQTGLTAn1c8O4ye1SYV25HFTBNcjapEA7aTpkrbkdYs7DB8MiU1wkqpGQ3tsU9xw4XrkNbYiQV/NR3LdXUDN66os4KbSRoIoMME0exzbFQoHMz4Nx+OCwXHyIBmhcnEeOwZDRB67vfc9x8IIiYdu0HoaB/cP60Ip4CwgTys5p0AwbBVWPnpAk3x2zp65fhmP/VyhfvxbkFf/z9xoD0QA8QGgUIORS0E4StMNPp1MYEFsBPEBXuILcvLbxEesAAkc0gMARDSBwRAMIHNEAAkc0gMARDSBwRAMIHNEAAkc0gMARDSBwRAMIHNEAAkc0gMARDSBwRAMIHNEAAkc0gMARDSBwRAMIHNEAAkc0gMARDSBwZIRGQRFaJXcFBhFB8O8AAAD//0xEBMQ+lf3VAAAAAElFTkSuQmCC"
var imgUrl = "data:image/png;base64," + base64Str

I try that but

var logo=results.rows.item(i).logo
var base64Str = Qt.btoa(encodeURIComponent(logo))

or

var base64Str = Qt.btoa(escape(logo))

or

var base64Str = Qt.btoa(logo)

or

var base64Str = Qt.btoa(escape(encodeURIComponent(logo))

or

var base64Str = Qt.btoa(unescape(encodeURIComponent(logo))

no one return same data as the online encoder... and I got an error

Do you know why?

[raven-worx]

@filipdns
Ok. Since the SQL data type is BLOB, QSql will return QByteArray data type for. In QML QByteArray will be translated to an JS ArrayBuffer. And there is the issue i guess.

You may want to try this (should be also working in the QML engine)