﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2005 / SQL Server 2005 General Discussion  / Barcode 128 generator (using scalar function) / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Tue, 18 Jun 2013 19:24:03 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Barcode 128 generator (using scalar function)</title><link>http://www.sqlservercentral.com/Forums/Topic1065554-149-1.aspx</link><description>[quote]The way the barcode functions work is always the same: you pass a string with the source code ('bananas') and you get the coded barcode string ( ÑbananasÈÓ, always starts with capital Ñ and ends with Ó).[/quote]I expect one or more of the functions/tools people have suggested will do the business.But I wanted to point out that Code 128 is not quite like that.  Unlike eg Code 39, it is not a straight character-for-character substitution, so just applying a font with static bracketing values doesn't work.  It needs a calculated checksum (which is not shown in the human-readable version nor transmitted to the receiving system, but ensures the quality of the data read by the scanner), which is why you need to apply a function to the data you want to encode.  And I do not think the control characters are universal - I have seen different font sets that have made different choices with regard to the extended characters they use to represent the control values.  Presumably the ones you specify will work for your environment.</description><pubDate>Mon, 08 Apr 2013 04:20:25 GMT</pubDate><dc:creator>Ewan Hampson</dc:creator></item><item><title>RE: Barcode 128 generator (using scalar function)</title><link>http://www.sqlservercentral.com/Forums/Topic1065554-149-1.aspx</link><description>Sorry, can you tell me what is the purpose of [url=http://www.barcodelib.com/net_barcode/main.html]generating[/url] such a [url=http://www.barcodelib.com/net_reporting_services/main.html]Code 128 barcode[/url]? I have no idea what you are trying to achieve. By the way, I know a website that has many conversion tools for class code. Hope it works.[url=http://www.developerfusion.com/tools/convert/][b]http://www.developerfusion.com/tools/convert/[/b][/url]</description><pubDate>Tue, 26 Mar 2013 21:57:30 GMT</pubDate><dc:creator>aframiller326</dc:creator></item><item><title>RE: Barcode 128 generator (using scalar function)</title><link>http://www.sqlservercentral.com/Forums/Topic1065554-149-1.aspx</link><description>To encode data string in Code 128, you may find a code 128 font or barcode control supports Code 128 generating in .NET app. I guess the[url=http://www.tarcode.com/barcode-reporting-service/barcodes/code128.html] SSRS CODE 128[/url] control is OK.</description><pubDate>Wed, 30 Jan 2013 21:13:09 GMT</pubDate><dc:creator>tarcode_winforms</dc:creator></item><item><title>RE: Barcode 128 generator (using scalar function)</title><link>http://www.sqlservercentral.com/Forums/Topic1065554-149-1.aspx</link><description>You can test this[url=http://www.rasteredge.com/online-barcode-generator/code-128/] code 128 generator[/url].Hope this fits your needs.</description><pubDate>Sun, 27 Jan 2013 19:57:46 GMT</pubDate><dc:creator>earlmason986</dc:creator></item><item><title>RE: Barcode 128 generator (using scalar function)</title><link>http://www.sqlservercentral.com/Forums/Topic1065554-149-1.aspx</link><description>I am using this [url=http://www.onbarcode.com/products/net_barcode_reporting_service/]SQL Server Reporting Service Barcode Generator[/url]. It's good and you can adjust the parameters of QR Code easily. I suggest you have a try. You can also find many other barcode generators on the site, such as [url=http://www.onbarcode.com/products/java_barcode/barcodes/qrcode.html]Java QR Code barcode generator with detailed guide[/url]. Hope it's helpful.</description><pubDate>Sun, 20 Jan 2013 19:48:07 GMT</pubDate><dc:creator>Kirk_Brown_1986</dc:creator></item><item><title>RE: Barcode 128 generator (using scalar function)</title><link>http://www.sqlservercentral.com/Forums/Topic1065554-149-1.aspx</link><description>please check out the [url="http://www.keepdynamic.com/dotnet-barcode-reporting-service/code-128.shtml"]Code128 barcode generation library for SQL Server[/url].</description><pubDate>Tue, 23 Oct 2012 02:19:31 GMT</pubDate><dc:creator>andrewfyl2</dc:creator></item><item><title>Barcode 128 generator (using scalar function)</title><link>http://www.sqlservercentral.com/Forums/Topic1065554-149-1.aspx</link><description>I'm looking for a barcode generating Function that uses the standard Code128. Apparently no function that fixes this has been posted before in the forum.The way the barcode functions work is always the same: you pass a string with the source code ('bananas') and you get the coded barcode string ( ÑbananasÈÓ, always starts with capital Ñ and ends with Ó).I have the right function in Access VBA (code attached), but I'm not able to translate this into SQL Server. Does anyone have the equivalent SQL Server function (or knows how to translate this) ?Thanks in advance, a.</description><pubDate>Thu, 17 Feb 2011 04:47:30 GMT</pubDate><dc:creator>a_ud</dc:creator></item></channel></rss>