antonscheffer / as_barcode Goto Github PK
View Code? Open in Web Editor NEWA PL/SQL package to create a QR-code, Aztec or datamatrix barcode.
License: MIT License
A PL/SQL package to create a QR-code, Aztec or datamatrix barcode.
License: MIT License
hi, i test your package after you update version , if we use single byte , qrcode is fine,
but i found if i use text with multi-byte language to create qrcode image ,ex:chinese
it will lost , and qrcode reader can not parse it .
Hello,
Thank you for your incredible codes.... i want to ask you if there is a way to set the size of the qr barcode from the plsql
hi, thank for share , but body compile error with below,can you help ?
and can you please create qrcode sample plsql for us?
[Error] PLS-00201 (2398: 9): PLS-00201: identifier 'T_X2' must be declared
[Error] PLS-00201 (2403: 11): PLS-00201: identifier 'T_W2' must be declared
[Error] PLS-00201 (2405: 11): PLS-00201: identifier 'T_X1' must be declared
[Error] PLS-00201 (2406: 11): PLS-00201: identifier 'T_X2' must be declared
[Error] PLS-00201 (2407: 62): PLS-00201: identifier 'T_W2' must be declared
[Error] PLS-00201 (2412: 22): PLS-00201: identifier 'T_X1' must be declared
[Error] PLS-00201 (2413: 22): PLS-00201: identifier 'T_X2' must be declared
[Error] PLS-00201 (2414: 25): PLS-00201: identifier 'T_X1' must be declared
[Error] PLS-00201 (2415: 25): PLS-00201: identifier 'T_X2' must be declared
[Error] PLS-00201 (2416: 22): PLS-00201: identifier 'T_X1' must be declared
br,nolem
Hi,
I feed into the function AS_BARCODE.barcode('a\n'||CHR(13)||CHR(10)||'\Nb','QR')
the QR code generated seems doesn't include the line breaks. it show as a\n\ \Nb.
is this an issue?
Hi Anton,
awesome tool, thanks alot for putting it together !
Small note: I think the logic to calc the length of the chunk IDAT has a small typo, instead of "+ 4" it should read "- 4" (probably just a typo), i.e.
...
return utl_raw.concat( '89504E470D0A1A0A' -- signature
, '0000000D'
, t_ihdr
, crc32( t_ihdr )
, to_char( utl_raw.length( t_idat ) - 4, 'fm0XXXXXXX' )
, t_idat
, crc32( t_idat )
, '0000000049454E44AE426082' -- IEND
);
...
As far as I can understand, the length of a chunk should only include the length of the data, not the chunk type, the length of the chunk or the CRC of the chunk (found this note here).
We stumbled across the issue because Oracle XML Publisher wouldn't render the PNG (while Oracle's BI Publisher would ;-)); after verifying the PNG file itself using pngcheck we found the issue.
thanks alot for looking into this!
Herbert
Hi.
It works with latin encoding, with multilines, but generate non readable QR code with cyrillic text.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.