{"id":2021,"date":"2026-10-28T17:24:50","date_gmt":"2026-10-28T17:24:50","guid":{"rendered":"https:\/\/clarionsharp.com\/blog\/?p=2021"},"modified":"2026-10-28T17:24:50","modified_gmt":"2026-10-28T17:24:50","slug":"clarion-unicode-beta-refresh-14523","status":"publish","type":"post","link":"https:\/\/clarionsharp.com\/blog\/clarion-unicode-beta-refresh-14523\/","title":{"rendered":"Clarion Unicode \u2013 beta refresh (14523)"},"content":{"rendered":"\n<style>\n.ustring-wp6 { --u-fg:#1c1917; --u-muted:#6b6560; --u-line:#e2dcd3; --u-card:#fff; --u-soft:#dbeafe; --u-accent:#1d4ed8; --u-bg:#f7f5f1; --u-link:#0b5cad; font-family:system-ui,-apple-system,\"Segoe UI\",sans-serif; color:var(--u-fg); line-height:1.55; max-width:1080px; margin:0 auto; }\n@media (prefers-color-scheme: dark) {\n  .ustring-wp6 { --u-fg:#f5f5f4; --u-muted:#a8a29e; --u-line:#3f3a36; --u-card:#1c1917; --u-soft:#1e3a5f; --u-accent:#93c5fd; --u-bg:#121110; --u-link:#7dd3fc; }\n}\n.ustring-wp6 * { box-sizing:border-box; }\n.ustring-wp6 .uw-hero { background:linear-gradient(135deg,#0f2a44 0%,#1e3a5f 45%,#14532d 100%); color:#fafaf9; border-radius:14px; padding:1.75rem 1.5rem 1.5rem; margin:0 0 1.25rem; }\n.ustring-wp6 .uw-eyebrow { display:inline-block; font-size:.72rem; letter-spacing:.12em; text-transform:uppercase; color:#93c5fd; font-weight:700; margin-bottom:.55rem; }\n.ustring-wp6 .uw-hero h2 { margin:0 0 .65rem; font-size:clamp(1.45rem,3.5vw,2rem); line-height:1.2; letter-spacing:-.02em; color:#fafaf9; }\n.ustring-wp6 .uw-hero p { margin:0; color:#e7e5e4; font-size:1.05rem; max-width:42rem; }\n.ustring-wp6 .uw-pills { display:flex; flex-wrap:wrap; gap:.4rem; margin-top:1rem; }\n.ustring-wp6 .uw-pill { display:inline-block; padding:.3rem .7rem; border-radius:999px; background:rgba(255,255,255,.08); border:1px solid rgba(255,255,255,.12); color:#fafaf9; font-size:.82rem; }\n.ustring-wp6 .uw-pill strong { color:#bfdbfe; font-weight:650; }\n.ustring-wp6 .uw-lead { color:var(--u-muted); margin:0 0 1.1rem; font-size:1rem; }\n.ustring-wp6 .uw-grid { display:grid; grid-template-columns:repeat(auto-fit,minmax(230px,1fr)); gap:.85rem; margin:0 0 1.5rem; }\n.ustring-wp6 .uw-card { background:var(--u-card); border:1px solid var(--u-line); border-radius:14px; padding:1rem 1.05rem 1.1rem; min-width:0; overflow-wrap:anywhere; }\n.ustring-wp6 .uw-icon { width:2rem; height:2rem; border-radius:10px; display:grid; place-items:center; background:var(--u-soft); color:var(--u-accent); font-weight:700; margin-bottom:.55rem; font-size:1rem; }\n.ustring-wp6 .uw-card h3 { margin:0 0 .35rem; font-size:1rem; letter-spacing:-.01em; color:var(--u-fg); }\n.ustring-wp6 .uw-card p { margin:0; color:var(--u-muted); font-size:.92rem; line-height:1.5; }\n.ustring-wp6 .uw-shot { display:block; width:100%; height:auto; margin:.75rem 0 0; border:1px solid var(--u-line); border-radius:8px; }\n.ustring-wp6 .uw-wide { grid-column:1 \/ -1; border-color:var(--u-accent); }\n.ustring-wp6 .uw-shots { display:grid; grid-template-columns:repeat(auto-fit,minmax(260px,1fr)); gap:.75rem; align-items:start; }\n.ustring-wp6 .uw-shots figure { margin:0; min-width:0; }\n.ustring-wp6 .uw-shots figcaption { font-size:.82rem; color:var(--u-muted); margin-top:.35rem; }\n.ustring-wp6 code { font-family:Consolas,\"Cascadia Mono\",ui-monospace,monospace; font-size:.88em; background:var(--u-bg); border:1px solid var(--u-line); border-radius:5px; padding:.05em .3em; color:var(--u-fg); overflow-wrap:anywhere; word-break:break-word; }\n.ustring-wp6 .uw-cta { background:var(--u-card); border:1px solid var(--u-line); border-left:4px solid var(--u-accent); border-radius:12px; padding:1rem 1.15rem; }\n.ustring-wp6 .uw-cta p { margin:0 0 .65rem; color:var(--u-muted); }\n.ustring-wp6 .uw-cta p:last-child { margin:0; }\n.ustring-wp6 .uw-btn { display:inline; background:none; color:var(--u-link) !important; text-decoration:underline !important; font-weight:650; padding:0; border-radius:0; margin-top:.15rem; }\n.ustring-wp6 .uw-btn:hover { color:var(--u-accent) !important; text-decoration:underline !important; }\n.ustring-wp6 .uw-note { font-size:.88rem; color:var(--u-muted); margin-top:.75rem; }\n<\/style>\n\n<div class=\"ustring-wp6\">\n  <div class=\"uw-hero\">\n    <div class=\"uw-eyebrow\">Clarion \u00b7 Unicode Preview \u00b7 Beta Refresh<\/div>\n    <h2>Refresh build 14523 \u2014 NOW, NOWUTC, DATE, TIME and DATETIME as built-in procedures, TopSpeedW keys in your locale&#8217;s order, and a Dictionary Editor that keeps every description in your language<\/h2>\n    <p>\n      A date-time value comes from one clock read: <code>NOW(dt)<\/code> fills a DATETIME,\n      <code>NOW(d, t)<\/code> a date and a time that can never straddle midnight, and\n      <code>DATE(dt)<\/code> \/ <code>TIME(dt)<\/code> take it apart again. TopSpeedW USTRING keys\n      sort the way your QUEUE sorts, by the Windows locale stored in the file. The Dictionary\n      Editor keeps table, key and version descriptions and every comment in your language and\n      shows the tables flat or grouped by category, the Applications pad sorts from a list and\n      shows when each procedure last changed, and a report blob prints from SQL tables too.\n      Already testing? Everything below is new since build 14487.\n    <\/p>\n    <div class=\"uw-pills\">\n      <span class=\"uw-pill\"><strong>Language<\/strong> <code>NOW<\/code> \u00b7 <code>NOWUTC<\/code> \u00b7 <code>DATE(dt)<\/code> \u00b7 <code>TIME(dt)<\/code> \u00b7 <code>DATETIME(dt, d, t)<\/code> built in<\/span>\n      <span class=\"uw-pill\"><strong>TopSpeedW<\/strong> USTRING keys in the Windows locale order \u00b7 <code>\/COLLATE=OFF<\/code> \u00b7 <code>COLLATELOCALE<\/code><\/span>\n      <span class=\"uw-pill\"><strong>Dictionary Editor<\/strong> descriptions and comments in any script \u00b7 Group by Category on or off<\/span>\n      <span class=\"uw-pill\"><strong>AppGen<\/strong> Applications pad sort list \u00b7 last-modified stamp per procedure \u00b7 Defaults-tab font<\/span>\n      <span class=\"uw-pill\"><strong>Report to PDF<\/strong> Image 2 PDF keeps your output name \u00b7 auto-sized TRN fields print whole<\/span>\n      <span class=\"uw-pill\"><strong>SQL<\/strong> report blobs from SQL tables \u00b7 exact BLOB size after ADD \u00b7 three new how-do-I topics<\/span>\n    <\/div>\n  <\/div>\n\n  <p class=\"uw-lead\">\n    First the two changes every Clarion developer meets in the first minute \u2014 the Applications pad\n    and the Dictionary Editor \u2014 then the Unicode and language highlights of this drop, then the full\n    tester guide, whose <em>&#8220;What&#8217;s new&#8221;<\/em> section lists everything that changed since you last read it.\n  <\/p>\n\n  <div class=\"uw-grid\">\n    <article class=\"uw-card uw-wide\">\n      <div class=\"uw-icon\">\u2261<\/div>\n      <h3>For every developer: one-click sort in the Applications pad, and when each procedure last changed<\/h3>\n      <p>\n        The Applications pad&#8217;s sort button is now a split button: the face still cycles Name, Generation order and\n        Modification date, and the arrow opens the three orders with the current one checked, so one click takes\n        you straight to the order you want; the pad&#8217;s bottom line names the order in force and your choice carries\n        over. Two check marks on Tools \u203a Options \u203a Clarion \u203a Applications (AppGen) put the date and time of the\n        last edit where you work: <em>Always show modification date and time in the Applications pad<\/em> keeps\n        the stamp beside every application, and <em>Show last modified date and time after each procedure in the\n        Application Tree<\/em> adds it after every procedure row in the Procedure, Module, Template, Name and\n        Category views, with Procedure Properties showing the same stamp as a read-only <em>Last modified<\/em>\n        line. The names still lead, so the order and the locator are as before. A procedure made from the Defaults\n        tab now starts with your default font too. From beta requests and a beta report.\n      <\/p>\n      <!-- >>> confirm the image URLs after uploading guide-img <<< -->\n      <div class=\"uw-shots\" style=\"margin-top:.75rem\">\n        <figure>\n          <img decoding=\"async\" class=\"uw-shot\" style=\"margin:0\" src=\"https:\/\/softvelocity.com\/docs\/guide-img\/AppSort-2.gif\" alt=\"The Applications pad: the sort button's drop list picks Name, Generation order or Modification date\" loading=\"lazy\">\n          <figcaption>The Applications pad: one click on the arrow, pick the order.<\/figcaption>\n        <\/figure>\n        <figure>\n          <img decoding=\"async\" class=\"uw-shot\" style=\"margin:0\" src=\"https:\/\/softvelocity.com\/docs\/guide-img\/AppProcStamp.png\" alt=\"Tools, Options, Applications (AppGen): the two last-modified check marks\" loading=\"lazy\">\n          <figcaption>Tools \u203a Options \u203a Applications (AppGen): the two last-modified check marks.<\/figcaption>\n        <\/figure>\n        <figure>\n          <img decoding=\"async\" class=\"uw-shot\" style=\"margin:0\" src=\"https:\/\/softvelocity.com\/docs\/guide-img\/ProcModStamp.png\" alt=\"Procedure Properties with the read-only Last modified line\" loading=\"lazy\">\n          <figcaption>Procedure Properties: the same stamp as a read-only line.<\/figcaption>\n        <\/figure>\n      <\/div>\n    <\/article>\n\n    <article class=\"uw-card\">\n      <div class=\"uw-icon\">\u25a4<\/div>\n      <h3>Dictionary Editor: the whole dictionary flat, or grouped by category \u2014 one check mark<\/h3>\n      <p>\n        Below the nine sort orders, Sort Tables has a <em>Group by Category<\/em> check mark. Checked, the DCT\n        Explorer and the Tables pad show one folder per category as before. Clear it and every table lists flat\n        under Tables, so the order you picked runs across the whole dictionary: Driver, for example, puts all the\n        MSSQL tables together whatever category they sit in. Your categories are untouched and come back the\n        moment you check it again. The same switch is on the Dictionary menu under Sort Tables and in Tools \u203a\n        Options \u203a Clarion \u203a Dictionary Editor \u203a Table Options. From a beta report.\n      <\/p>\n    <\/article>\n\n    <article class=\"uw-card\">\n      <div class=\"uw-icon\">&#x23f1;<\/div>\n      <h3>Date and time: the conversions are built-in procedures<\/h3>\n      <p>\n        <code>NOW(dt)<\/code> fills a DATETIME from one clock read (100 ns where Windows gives it); <code>NOW(d, t)<\/code> returns today&#8217;s date and the time of the same instant, so the pair can never straddle midnight the way <code>TODAY()<\/code> followed by <code>CLOCK()<\/code> can. <code>NOWUTC<\/code> gives the same instant in UTC with the local offset, <code>DATE(dt)<\/code> and <code>TIME(dt)<\/code> return the two parts of a DATETIME, <code>TIME(h, m, s)<\/code> builds a time the way <code>DATE(m, d, y)<\/code> builds a date, and <code>DATETIME(dt, date, time)<\/code> puts them together. Every result is exact and the same as the DateTimeUtil class gives; the class stays. A prototype of your own that clashes with a built-in now names it. From a beta request.\n      <\/p>\n    <\/article>\n\n    <article class=\"uw-card\">\n      <div class=\"uw-icon\">&#x2195;<\/div>\n      <h3>TopSpeedW: USTRING keys sort by the Windows locale<\/h3>\n      <p>\n        A TopSpeedW file created from this build on sorts a USTRING key the way a keyed QUEUE or <code>SORT()<\/code> sorts the same values: <code>\u0106up<\/code> sits between <code>Cena<\/code> and <code>Dan<\/code> on a Croatian file, <code>\u00e9<\/code> sorts with <code>e<\/code>, and NOCASE is the locale&#8217;s case-insensitive order. The locale in force at CREATE is stored in the file, so the order travels with it to any machine; <code>SEND(File,'COLLATELOCALE')<\/code> answers it, and <code>DRIVER('TopSpeedW','\/COLLATE=OFF')<\/code> keeps the code-unit order of earlier builds. Files created by earlier builds keep their order; re-create a file to move it. From a beta report.\n      <\/p>\n    <\/article>\n\n    <article class=\"uw-card\">\n      <div class=\"uw-icon\">\u25a4<\/div>\n      <h3>Dictionary Editor: every description and comment in your language<\/h3>\n      <p>\n        The Description of a table, an alias, a key, a table category and a dictionary version, and every Comment, round-trip Unicode text exactly through save and reopen, the same as the column properties do; a key description the templates quote reaches the running application as the exact text. From a beta report.\n      <\/p>\n    <\/article>\n\n    <article class=\"uw-card\">\n      <div class=\"uw-icon\">\u25a3<\/div>\n      <h3>Report to PDF: your output name, and every auto-sized field whole<\/h3>\n      <p>\n        With <em>PDF Library to Use<\/em> = Image 2 PDF, a report whose Output Name Type is Fixed or Variable, or whose code sets the name with <code>SetFileName<\/code>, writes that file when you choose Save As in the previewer, the same as the Clarion PDF library does; the Save dialog appears only when no name is set. A report STRING with the TRN attribute and no width or height in its AT() now prints whole on a Unicode page in the PDF, matching the Clarion 11 output of the same application. The page reader compiles into the application, so rebuild it after installing. From beta reports.\n      <\/p>\n    <\/article>\n\n    <article class=\"uw-card\">\n      <div class=\"uw-icon\">\u25c6<\/div>\n      <h3>Reports and SQL: a blob per detail from SQL tables, exact sizes after ADD<\/h3>\n      <p>\n        A report <code>TEXT,USE(blob)<\/code> or <code>IMAGE,USE(blob)<\/code> fed from a VIEW over a SQL Server, PostgreSQL, ODBC or SQLite table prints each detail&#8217;s own blob, as it has on TopSpeed since build 14487, and <code>SIZE(blob)<\/code> after <code>NEXT(view)<\/code> answers on a SQL file too. On the MSSQL and ODBC drivers the size a blob carries after the ADD that streamed it is the length of the data you stored, so a second ADD from the same record buffer lands its row on ODBC Driver 18 for SQL Server as well. From a beta report.\n      <\/p>\n    <\/article>\n\n    <article class=\"uw-card\">\n      <div class=\"uw-icon\">\\<\/div>\n      <h3>Designers and templates: @K escapes everywhere, locators typed from the key<\/h3>\n      <p>\n        <code>ENTRY(@K(###)@@@-##\\@##K)<\/code>, the Key-in picture from the help, now opens in the Window and Report Designers and generates and evaluates the way it compiles: inside a <code>@K<\/code> picture a <code>\\<\/code> makes the next character a display character. The Clarion-chain browse locator value takes its type from the key component it locates on: a USTRING key gets a <code>USTRING(31)<\/code> value, any other key keeps the <code>CSTRING(31)<\/code> or <code>STRING(30)<\/code> the templates always wrote, so an application without wide fields generates the same locator code as before. From beta reports.\n      <\/p>\n    <\/article>\n\n    <article class=\"uw-card\">\n      <div class=\"uw-icon\">?<\/div>\n      <h3>Help: three SQL how-do-I topics, and the manuals from the same source<\/h3>\n      <p>\n        How do I spell a PostgreSQL table name in the dictionary (an unquoted name folds to lower case; the one quoted spelling that opens), how do I define an ODBC data source (DSN) for a Clarion application (the 32-bit odbcad32, User vs System DSN, how OWNER and the import wizard use it), and how do I fill in Owner Name and Full Path Name for a SQL table. The seven manuals now print from the help project, so a topic reads the same in F1, in the PDF and in the new Markdown edition of each book made for AI tools; the current set is posted on the beta forum.\n      <\/p>\n    <\/article>\n\n  <\/div>\n\n  <div class=\"uw-cta\">\n    <p>\n      <strong style=\"color:var(--u-fg)\">Full tester guide<\/strong> \u2014\n      mental model, conversion rules, DCT import table, screen controls, reports, blobs,\n      SQL \/ SQLite \/ text drivers \/ TopSpeedW \/ Memory \/ IP, recipes, the new-language-surface\n      quick reference, and what to focus on when testing. The guide&#8217;s <em>&#8220;What&#8217;s new&#8221;<\/em>\n      section lists everything in this drop, and every section has its task topic in the\n      F1 help&#8217;s &#8220;How do I &#8230;&#8221; chapter.\n    <\/p>\n    <!-- >>> confirm these URLs match the deployed static docs <<< -->\n    <a class=\"uw-btn\" href=\"https:\/\/softvelocity.com\/docs\/Clarion-Unicode-Tester-Guide.html\" target=\"_blank\" rel=\"noopener\">Open the full Unicode Tester Guide<\/a>\n    <p style=\"margin:.85rem 0 .35rem; color:var(--u-muted)\">\n      <strong style=\"color:var(--u-fg)\">Report tool authors<\/strong> \u2014\n      the wide generator surface (<code>IReportGeneratorW<\/code>), format detection, the\n      EMF record set, transition paths per integration style, and the\n      <code>PageTextIndexClass<\/code> text index the previewer searches with:\n    <\/p>\n    <a class=\"uw-btn\" href=\"https:\/\/softvelocity.com\/docs\/Clarion-Unicode-EMF-Transition-Note.html\" target=\"_blank\" rel=\"noopener\">EMF Page Files \u2014 Transition Note<\/a>\n    <p class=\"uw-note\">\n      Standalone pages (best full-width). Everything described there is implemented unless marked as a known limitation \u2014\n      if you see something different, the beta forum is the place.\n    <\/p>\n  <\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Clarion \u00b7 Unicode Preview \u00b7 Beta Refresh Refresh build 14523 \u2014 NOW, NOWUTC, DATE, TIME and DATETIME as built-in procedures, TopSpeedW keys in your locale&#8217;s order, and a Dictionary Editor that keeps every description in your language A date-time value comes from one clock read: NOW(dt) fills a DATETIME, NOW(d, t) a date and a &hellip; <a href=\"https:\/\/clarionsharp.com\/blog\/clarion-unicode-beta-refresh-14523\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Clarion Unicode \u2013 beta refresh (14523)<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,5],"tags":[],"class_list":["post-2021","post","type-post","status-publish","format-standard","hentry","category-clarion-12","category-clarionnews"],"_links":{"self":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts\/2021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/comments?post=2021"}],"version-history":[{"count":1,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts\/2021\/revisions"}],"predecessor-version":[{"id":2022,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts\/2021\/revisions\/2022"}],"wp:attachment":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/media?parent=2021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/categories?post=2021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/tags?post=2021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}