defaria.com/blogs/Status/2005/09/clearquest-code.html

   1 <!DOCTYPE html>
   2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
   3   <head>
   4     <meta charset="utf-8">
   5     <meta name="description" content="Clearquest 2003.06.15 now uses Code Pages to insure that data entered into Clearquest databases are correct. When incorrect data is encountered there is a problem. The question is, which code page should we use?...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>Clearquest Code Pages - Status</title>
   8     <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
   9     <link rel="canonical" href="http://defaria.com/blogs/Status/2005/09/clearquest-code.html">
  10     <meta name="viewport" content="width=device-width,initial-scale=1">
  11     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
  12     <!--[if lt IE 9]>
  13     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
  14     <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
  15     <![endif]-->
  16
  17     <link rel="start" href="http://defaria.com/blogs/Status/">
  18
  19     <link rel="prev" href="http://defaria.com/blogs/Status/2005/09/clearquest-fran.html" title="Clearquest Franchise/PQA Invalid ASCII characters">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2005/09/rgy-switchoverc.html" title="Code Page/rgy_switchover">
  21     <!-- Open Graph Protocol -->
  22     <meta property="og:type" content="article">
  23     <meta property="og:locale" content="en-us">
  24     <meta property="og:title" content="Clearquest Code Pages">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2005/09/clearquest-code.html">
  26     <meta property="og:description" content="Clearquest 2003.06.15 now uses Code Pages to insure that data entered into Clearquest databases are correct. When incorrect data is encountered there is a problem. The question is, which code page should we use?...">
  27     <meta property="og:site_name" content="Status">
  28     <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  29     <!-- Metadata -->
  30     <meta itemprop="description" content="Clearquest 2003.06.15 now uses Code Pages to insure that data entered into Clearquest databases are correct. When incorrect data is encountered there is a problem. The question is, which code page should we use?...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2005/09/clearquest-code.html">
  32     <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  33
  34   </head>
  35   <body>
  36     <div id="container">
  37       <div id="container-inner">
  38         <header id="header" role="banner">
  39           <div id="header-inner">
  40             <div id="header-content">
  41               <h1>
  42                 <a href="http://defaria.com/blogs/Status/">
  43
  44                   Status
  45
  46                 </a>
  47               </h1>
  48
  49             </div>
  50
  51             <nav role="navigation">
  52           <ul>
  53             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
  54
  55
  56           </ul>
  57         </nav>
  58
  59           </div>
  60         </header>
  61         <div id="content">
  62           <div id="content-inner">
  63             <ul class="breadcrumb breadcrumb-list">
  64               <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
  65               <li class="breadcrumb-list-item">Clearquest Code Pages</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1700" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">Clearquest Code Pages</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2005-09-26T18:32:00-08:00" itemprop="datePublished">September 26, 2005</time></li>
  74                       <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
  75
  76
  77                       <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/pqa/">PQA</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <p>Clearquest 2003.06.15 now uses Code Pages to insure that data entered into Clearquest databases are correct. When incorrect data is encountered there is a problem. The question is, which code page should we use?</p>
  85                   <p>Chris had went through this decision when he migrated Clearquest data to San Diego. We are faced with this decision now by moving to 2003.06.15.</p>
  86
  87 <blockquote>If you have ClearQuest databases that were created with previous versions of ClearQuest, they may contain data from a variety of code pages. When you set the ClearQuest data code page, the data in your databases is not converted to characters in the selected code page. If your database contains characters that do not map to the newcode page characters, data corruption will occur.
  88 </blockquote>
  89
  90 <p>There seems to be 4 choices for code pages:</p>
  91
  92 <ol>
  93   <li>ASCII</li>
  94
  95   <li>Latin-1</li>
  96
  97   <li>Chinese - Simplified</li>
  98
  99   <li>Japanese</li>
 100 </ol>
 101
 102 <p>I'm going to assume 3 and 4 are non issues. This leaves 1 and 2. Chris went with #1 and I think that's a good choice because ASCII is a base code set. However going with #1 means we need to clean up data now as we already have non ASCII characters in the databases.</p>
 103
 104 </p>There is also a <strong>NOCHECKING</strong> option which essentially turns off checking and allows any character in. Using <strong>NOCHECKING</strong> would mean that Clearquest Multisite will not be an option in the future as it does not support <strong>NOCHECKING</strong></p>.
 105
 106 <p>I believe if we went with #2 our non ASCII characters would not be a problem. However:</p>
 107
 108 <blockquote>All Windows clients must run the same operating system code page, and that code page must match the ClearQuest data code page. If you have mixed-platform environments (both Windows and UNIX clients), or clients using different operating system code pages, you must set the ClearQuest data code page to 20217 (ASCII), which is the common character set of all code pages. An alternate usage model is to set the ClearQuest data code page to a non-ASCII value and require that all users with UNIX systems interact with ClearQuest only with the Webclient.</blockquote>
 109
 110 <p>And</p>
 111
 112 <ul>
 113   <li>If you set the ClearQuest data code page to a non-ASCII value, users can only modify data in that database from a Windows client running the same operating system code page. If the code pages do not match, the database is opened in read-only mode.</li>
 114
 115   <li>If you set the ClearQuest data code page to a non-ASCII value, UNIX clients will have read-only access to the databases. (UNIX users can choose to use the only the Web client, which prevents data corruption if a non-ASCII data code page value is selected.)</li>
 116
 117   <li>If you set the ClearQuest data code page to a non-ASCII value, invalid characters can still potentially enter the database without being detected by ClearQuest. For example, ClearQuest cannot validate text that you cut from an e-mail or Web page and paste into a database record. If the e-mail or Web page text contains characters outside of the ClearQuest data code page, the characters are corrupted during display and may show up as invalid characters (for example, a question mark (?) character).</li>
 118 </ul>
 119
 120 <p>Bottom line appears to be use ASCII and bite the bullet now by cleaning up data or use Latin-1 and avoid data cleanup now with potentially a larger clean up later.</p>
 121                 </div>
 122                 <nav class="page-navigation entry-navigation pagination content-nav">
 123                   <ul class="page-navigation-list">
 124
 125                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2005/09/clearquest-fran.html" title="Clearquest Franchise/PQA Invalid ASCII characters">Previous entry</a></li>
 126
 127
 128                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2005/09/rgy-switchoverc.html" title="Code Page/rgy_switchover">Next entry</a></li>
 129
 130                   </ul>
 131                 </nav>
 132                 <!--
 133 <aside id="zenback" class="zenback feedback">
 134   Please paste Zenback script code here.
 135 </aside>
 136 -->
 137
 138
 139               </article>
 140             </div>
 141             <aside class="widgets related" role="complementary">
 142               <nav class="widget-search widget">
 143   <div class="widget-content">
 144     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 145       <div>
 146         <input type="text" name="search" value="" placeholder="Search...">
 147
 148         <input type="hidden" name="IncludeBlogs" value="8">
 149
 150         <input type="hidden" name="limit" value="20">
 151         <button type="submit" name="button">
 152           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 153         </button>
 154       </div>
 155     </form>
 156   </div>
 157 </nav>
 158 <nav class="widget-archive-category widget">
 159   <h3 class="widget-header">Categories</h3>
 160   <div class="widget-content">
 161
 162
 163     <ul class="widget-list">
 164
 165
 166       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 167
 168
 169       </li>
 170
 171
 172
 173
 174       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 175
 176
 177       </li>
 178
 179
 180
 181
 182       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 183
 184
 185       </li>
 186
 187
 188
 189
 190       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 191
 192
 193       </li>
 194
 195
 196
 197
 198       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 199
 200
 201       </li>
 202
 203
 204
 205
 206       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 207
 208
 209       </li>
 210
 211
 212
 213
 214       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 215
 216
 217       </li>
 218
 219
 220
 221
 222       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 223
 224
 225       </li>
 226
 227
 228
 229
 230       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 231
 232
 233       </li>
 234
 235
 236
 237
 238       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 239
 240
 241       </li>
 242
 243
 244
 245
 246       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 247
 248
 249       </li>
 250
 251
 252
 253
 254       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 255
 256
 257       </li>
 258
 259     </ul>
 260
 261
 262   </div>
 263 </nav>
 264
 265
 266 <nav class="widget-archive-dropdown widget">
 267   <h3 class="widget-header">Archives</h3>
 268   <div class="widget-content">
 269     <select>
 270       <option>Select a Month...</option>
 271
 272       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 273
 274
 275
 276       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 277
 278
 279
 280       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 281
 282
 283
 284       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 285
 286
 287
 288       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 289
 290
 291
 292       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 293
 294
 295
 296       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 297
 298
 299
 300       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 301
 302
 303
 304       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 305
 306
 307
 308       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 309
 310
 311
 312       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 313
 314
 315
 316       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 317
 318
 319
 320       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 321
 322
 323
 324       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 325
 326
 327
 328       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 329
 330
 331
 332       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 333
 334
 335
 336       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 337
 338
 339
 340       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 341
 342
 343
 344       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 345
 346
 347
 348       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 349
 350
 351
 352       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 353
 354
 355
 356       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 357
 358
 359
 360       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 361
 362
 363
 364       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 365
 366
 367
 368       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 369
 370
 371
 372       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 373
 374
 375
 376       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 377
 378
 379
 380       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 381
 382
 383
 384       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 385
 386
 387
 388       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 389
 390
 391
 392       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 393
 394
 395
 396       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 397
 398
 399
 400       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 401
 402
 403
 404       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 405
 406
 407
 408       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 409
 410
 411
 412       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 413
 414
 415
 416       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 417
 418
 419
 420       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 421
 422
 423
 424       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 425
 426
 427
 428       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 429
 430
 431
 432       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 433
 434
 435
 436       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 437
 438
 439
 440       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 441
 442
 443
 444       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 445
 446
 447
 448       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 449
 450
 451
 452       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 453
 454
 455
 456       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 457
 458
 459
 460       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 461
 462
 463
 464       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 465
 466
 467
 468       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 469
 470
 471
 472       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 473
 474
 475
 476       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 477
 478
 479
 480       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 481
 482
 483
 484       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 485
 486
 487
 488       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 489
 490
 491
 492       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 493
 494
 495
 496       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 497
 498
 499
 500       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 501
 502
 503
 504       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 505
 506
 507
 508       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 509
 510
 511
 512       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 513
 514
 515
 516       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 517
 518
 519
 520       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 521
 522
 523
 524       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 525
 526
 527
 528       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 529
 530
 531
 532       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 533
 534
 535
 536       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 537
 538
 539
 540       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 541
 542
 543
 544       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 545
 546
 547
 548       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 549
 550
 551
 552       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 553
 554
 555
 556       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 557
 558     </select>
 559   </div>
 560 </nav>
 561
 562
 563
 564 <div class="widget-syndication widget section">
 565   <div class="widget-content">
 566     <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
 567
 568   </div>
 569 </div>
 570
 571             </aside>
 572           </div>
 573         </div>
 574         <footer id="footer" role="contentinfo">
 575           <div id="footer-inner">
 576             <div id="footer-content">
 577   <nav role="navigation">
 578           <ul>
 579             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 580
 581
 582           </ul>
 583         </nav>
 584
 585   <p class="license">&copy; Copyright 2016.</p>
 586   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 587 </div>
 588           </div>
 589         </footer>
 590       </div>
 591     </div>
 592     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 593     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 594   </body>
 595 </html>