資源描述：
《plsql字符集問題》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、PLsql字符集問題EntertheSQLstatementselect*fromV$NLS_PARAMETERStoviewthecharactersettoseeifthefirstlinevalueissimplifiedChineseIntotheregistryregedit,clicktheHKEYLOCALMACHINEinturn->SOFTWARE--------->>ORACLEhome(smallmakeuptoinstallORACLE11g,shownhereasKEYOraDbllghomel
2、),findtheNLSLANG,checktoseeifthenumericaldatafor:SIMPLIFIEDCHINESE_CHINA?ZHS16GBKIftheaboveSettingsareok,thenlookattheSettingsoftheenvironmentvariableandseeifthereisavariableNLSLANGandnonewvariableiscreatedNewvariable,setvariablename:NLSLANG,variablevalue:SIMPLIF
3、IEDChinese.zhsl6gbkPicktoTheimpropersetofcharactersetsisakeyissueaffectingthedisplayoftheORACLEdatabase?Basedonpracticalexperience,thispaperintroducestheclassification,compositionandsettingmethodsofORACLEaboutthecharacterset,analyzesthecommonphenomenonandthereaso
4、nsoftheChinesecharactersdisplaygarbledORACLEdatabase,andputsforwardeffectiveforawidevarietyofphenomenaandthereasonofthesolution.Keywords:ORACLEcharactersetChinesescrambledtosolveutf-81theintroductionAstheleadingdatabaseproductintheindustry,ORACLEdatabasehasbeenwi
5、delyusedinlargeandmedium-sizedenterprisesinChinainrecentyears?AlthoughtheORACLEdatabaseproductitselfhasbeenfairlymatureinlocalization,therearestillanumberofuserresponsecharactersthatdisplaytheproblem?Differentusersofthesamedatabasehavedifferentresultsfromthesamet
6、able:"ORACLE??????"AndORACLEChinaLTD?“，apparently,theChinesecharactersaredisplayedasscrambled,sowhy?TheimpropersetofcharactersetsisakeyissueaffectingthedisplayoftheORACLEdatabase?ThecharactersetThecharactersetissetbyORACLEfordisplayindifferentlanguages?Thecharact
7、ersetforChinesecharactersisZHS16CGB231280,ZHS16GBK,US7ASCIIandutf-&Thecharactersetalsoexistsonboththeserverandtheclient?Theserver-sidecharactersetisspecifiedintheinstallationofORACLE,andthecharactersetregistrationinformationisstoredintheV$NLS_PARAMETERStableinthe
8、ORACLEdatabasedictionary;Theclientcharactersetissetinthesystemregistry(WINDOWSsystem)orintheuser'senvironmentvariable(UNIXsystem)?Thecompositionandsettingofthe
