https://sourceforge.net/p/squirrel-sql/feature-requests/599/2021-03-22T15:21:01.683000ZRecent changes to 599: System i / Power 9 / AS400 - UTF-8 Column Infos2021-03-22T15:21:01.683000Z2021-03-22T15:21:01.683000ZClaushttps://sourceforge.net/u/cwittmann/https://sourceforge.net2321ebbefe8cacafb2e556d557117086c16b7cfc

<div class="markdown_content"><p>Works fine. Thank you!!</p></div>

2021-03-13T22:28:20.179000Z2021-03-13T22:28:20.179000ZGerd Wagnerhttps://sourceforge.net/u/gerdwagner/https://sourceforge.netd8dc9e7323c30ddc7b5b7c548f738b37d1beb320

<div class="markdown_content"><ul> <li><strong>status</strong>: open --&gt; accepted</li> </ul></div>

2021-03-11T08:06:12.724000Z2021-03-11T08:06:12.724000ZClaushttps://sourceforge.net/u/cwittmann/https://sourceforge.netf716c66f43c0ddf171b85dd72b3a5a7058369f07

<div class="markdown_content"><p>We use a System i / Power 9 / AS400 Database and changed Database Columns to UTF-8 (yes - every single column has to be defined).<br/> This can be read out like the following:</p> <div class="codehilite"><pre><span></span><span class="err">select TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, DATA_TYPE, LENGTH, NUMERIC_SCALE, IS_NULLABLE, IS_UPDATABLE, CCSID</span> <span class="err">from qsys2.SYSCOLUMNS</span> <span class="err">where TABLE_SCHEMA = 'ABC'</span> </pre></div> <p>Is it possible to add Column CCSID to Column Overview, so we can see if it is <code>1208 (UTF-8)</code> or <code>null (nothing defined / default)</code><br/> I think if you call it CCSID for every Language - everyone should know what it means as IBM System i Navigator calls it the same.</p></div>

2021-03-11T08:06:12.724000Z2021-03-11T08:06:12.724000ZClaushttps://sourceforge.net/u/cwittmann/https://sourceforge.netba80209c57ffe8eba19dfbf4a6fbbdb14cc4cfce

<div class="markdown_content"><p>Ticket 599 has been modified: System i / Power 9 / AS400 - UTF-8 Column Infos<br/> Edited By: Gerd Wagner (gerdwagner)<br/> Status updated: 'open' =&gt; 'accepted'</p></div>