JUNCTION X: Oracle

<span style="color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px;">มีคนถามผมมาก เกี่ยวกับปัญหาการ ข้อมูลของ Oracle ที่เป็นภาษาไทย   แสดงผลออกมาเป็น ??? หรือ ฟฟฟฟ   โดยเฉพาะอย่างยิ่ง เครื่อง Client  ที่เป็น Windows  ซึ่งปัญหานี้เกิดจาก  Character Set ของ เครื่อง Client  ไม่ตรงกับ Character Set ของ Database  นั่นเอง   เราสามารถตรวจสอบได้ ดังนี้</span><br />
<div style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
<br /></div>
<div class="bold_purpule" style="background-attachment: initial; background-clip: initial; background-image: url(http://www.oracleskill.com/templates/beez/images/bg/bg-listarticle1.gif); background-origin: initial; background-repeat: repeat no-repeat; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #ff7000; font-family: 'Ms Sans Serif', Arial; font-size: 14px; font-weight: bold; height: 26px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 20px; padding-right: 0px; padding-top: 3px; vertical-align: baseline; width: 685px;">
ที่ฝั่ง Database</div>
<div style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
1. login  Oracle Database เป็น sys หรือ system</div>
<div style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
2. ใช้ SQL ตรวจสอบ NLS ดังนี้</div>
<pre style="border-bottom-color: rgb(119, 119, 119); border-bottom-style: dashed; border-bottom-width: 1px; border-color: initial; border-image: initial; border-left-color: rgb(119, 119, 119); border-left-style: dashed; border-left-width: 1px; border-right-color: rgb(119, 119, 119); border-right-style: dashed; border-right-width: 1px; border-style: initial; border-top-color: rgb(119, 119, 119); border-top-style: dashed; border-top-width: 1px; color: #0066ff; font-family: Courier; font-size: 14px; margin-bottom: 5px; margin-left: auto; margin-right: auto; margin-top: 5px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 3px; padding-left: 25px; padding-right: 10px; padding-top: 3px; vertical-align: baseline; width: 630px;">SELECT  *  FROM   NLS_DATABASE_PARAMETERS;</pre>
<div style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
<br /></div>
<div style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
3. ดูค่า NLS_CHARACTERSET ต้องเป็น <span class="bold" style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">TH8TISASCII</span> จึงจะสามารถจัดเก็บภาษาไทยได้ <img alt="NLS_DATABASE_PARAMETERS" border="1" height="407" src="http://www.oracleskill.com/oracle-tutorials/images/display-NLS-thai/NLS_DATABASE_PARAMETERS.gif" style="border-bottom-color: rgb(218, 218, 218); border-bottom-style: solid; border-bottom-width: 2px; border-color: initial; border-image: initial; border-left-color: rgb(218, 218, 218); border-left-style: solid; border-left-width: 2px; border-right-color: rgb(218, 218, 218); border-right-style: solid; border-right-width: 2px; border-style: initial; border-top-color: rgb(218, 218, 218); border-top-style: solid; border-top-width: 2px; border-width: initial; margin-bottom: 0px; margin-left: 20px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; vertical-align: baseline;" width="450" />  </div>
<div class="moduletable" style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
<u><br /></u></div>
<div class="moduletable" style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
<u><br /></u></div>
<div class="bold_purpule" style="background-attachment: initial; background-clip: initial; background-image: url(http://www.oracleskill.com/templates/beez/images/bg/bg-listarticle1.gif); background-origin: initial; background-repeat: repeat no-repeat; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #ff7000; font-family: 'Ms Sans Serif', Arial; font-size: 14px; font-weight: bold; height: 26px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 20px; padding-right: 0px; padding-top: 3px; vertical-align: baseline; width: 685px;">
ที่ฝั่ง Client (Windows)</div>
<div style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
1. ปุ่ม Start--> run --> พิมพ์ regedit แล้วกด OK</div>
<div style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
<img alt="regedit to see Oracle registry" border="1" height="217" src="http://www.oracleskill.com/oracle-tutorials/images/display-NLS-thai/regedit.gif" style="border-bottom-color: rgb(218, 218, 218); border-bottom-style: solid; border-bottom-width: 2px; border-color: initial; border-image: initial; border-left-color: rgb(218, 218, 218); border-left-style: solid; border-left-width: 2px; border-right-color: rgb(218, 218, 218); border-right-style: solid; border-right-width: 2px; border-style: initial; border-top-color: rgb(218, 218, 218); border-top-style: solid; border-top-width: 2px; border-width: initial; margin-bottom: 0px; margin-left: 20px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; vertical-align: baseline;" width="347" /></div>
<span style="color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px;"> </span><div style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
2. ไปที่ HKEY_LOCAL_MACHINE--> Software --> Oracle --> HOME0</div>
<div style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; overflow-x: hidden; overflow-y: hidden; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">
3. ที่หน้าต่างขวามือ ดูค่า NLS_LANG  ตัวหลังจุดต้องเป็น <span class="bold" style="border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">TH8TISASCII</span> เช่น AMERICAN_AMERICA.TH8TISASCII หรือ THAI_THAILAND.TH8TISASCII</div>
<img alt="NLS_LANG registry in windows" border="1" height="271" src="http://www.oracleskill.com/oracle-tutorials/images/display-NLS-thai/oracle-client-registry.gif" style="border-bottom-style: none; border-color: initial; border-image: initial; border-left-style: none; border-right-style: none; border-style: initial; border-top-style: none; border-width: initial; color: #666666; font-family: 'Ms Sans Serif', Arial; font-size: 14px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;" width="450" />

ปัญหาการแสดงผลภาษาไทยเป็น ??? หรือ ฟฟฟ ใน Oracle

มีคนถามผมมาก เกี่ยวกับปัญหาการ ข้อมูลของ Oracle ที่เป็นภาษาไทย แสดงผลออกมาเป็น ??? หรือ ฟฟฟฟ โดยเฉพาะอย่างยิ่ง เครื่อง Client ที่เป็น W...

อ่านเพิ่มเติม »