锘??xml version="1.0" encoding="utf-8" standalone="yes"?> 绔ā寮忥紙Endian錛夌殑榪欎釜璇嶅嚭鑷狫onathan
Swift涔﹀啓鐨勩婃牸鍒椾經娓歌銆嬨傝繖鏈功鏍規嵁灝嗛浮铔嬫暡寮鐨勬柟娉曚笉鍚屽皢鎵鏈夌殑浜哄垎涓轟袱綾伙紝浠庡渾澶村紑濮嬪皢楦¤泲鏁插紑鐨勪漢琚綊涓築ig
Endian錛屼粠灝栧ご寮濮嬪皢楦¤泲鏁插紑鐨勪漢琚綊涓篖ittile
Endian銆傚皬浜哄浗鐨勫唴鎴樺氨婧愪簬鍚冮浮铔嬫椂鏄┒绔熶粠澶уご錛圔ig-Endian錛夋暡寮榪樻槸浠庡皬澶達紙Little-Endian錛夋暡寮銆傚湪璁$畻鏈轟笟Big
Endian鍜孡ittle
Endian涔熷嚑涔庡紩璧蜂竴鍦烘垬浜夈傚湪璁$畻鏈轟笟鐣岋紝Endian琛ㄧず鏁版嵁鍦ㄥ瓨鍌ㄥ櫒涓殑瀛樻斁欏哄簭銆備笅鏂囦婦渚嬭鏄庡湪璁$畻鏈轟腑澶у皬绔ā寮忕殑鍖哄埆銆?/font> 濡傛灉灝嗕竴涓?2浣嶇殑鏁存暟0x12345678瀛樻斁鍒頒竴涓暣鍨嬪彉閲忥紙int錛変腑錛岃繖涓暣鍨嬪彉閲忛噰鐢ㄥぇ绔垨鑰呭皬绔ā寮忓湪鍐呭瓨涓殑瀛樺偍鐢變笅琛ㄦ墍紺恒備負綆鍗曡搗瑙侊紝鏈功浣跨敤OP0琛ㄧず涓涓?2浣嶆暟鎹殑鏈楂樺瓧鑺侻SB錛圡ost Significant Byte錛夛紝浣跨敤OP3琛ㄧず涓涓?2浣嶆暟鎹渶浣庡瓧鑺侺SB錛圠east Significant Byte錛夈?/font> 鍦板潃鍋忕Щ 澶х妯″紡 灝忕妯″紡 0x00 12錛圤P0錛?/font> 78錛圤P3錛?/font> 0x01 34錛圤P1錛?/font> 56錛圤P2錛?/font> 0x02 56錛圤P2錛?/font> 34錛圤P1錛?/font> 0x03 78錛圤P3錛?/font> 12錛圤P0錛?/font> 濡傛灉灝嗕竴涓?6浣嶇殑鏁存暟0x1234瀛樻斁鍒頒竴涓煭鏁村瀷鍙橀噺錛坰hort錛変腑銆傝繖涓煭鏁村瀷鍙橀噺鍦ㄥ唴瀛樹腑鐨勫瓨鍌ㄥ湪澶у皬绔ā寮忕敱涓嬭〃鎵紺恒?/font> 鍦板潃鍋忕Щ 澶х妯″紡 灝忕妯″紡 0x00 12錛圤P0錛?/font> 34錛圤P1錛?/font> 0x01 34錛圤P1錛?/font> 12錛圤P0錛?/font> 鐢變笂琛ㄦ墍鐭ワ紝閲囩敤澶у皬妯″紡瀵規暟鎹繘琛屽瓨鏀劇殑涓昏鍖哄埆鍦ㄤ簬鍦ㄥ瓨鏀劇殑瀛楄妭欏哄簭錛屽ぇ绔柟寮忓皢楂樹綅瀛樻斁鍦ㄤ綆鍦板潃錛屽皬绔柟寮忓皢
楂樹綅瀛樻斁鍦ㄩ珮鍦板潃銆傞噰鐢ㄥぇ绔柟寮忚繘琛屾暟鎹瓨鏀劇鍚堜漢綾葷殑姝e父鎬濈淮錛岃岄噰鐢ㄥ皬绔柟寮忚繘琛屾暟鎹瓨鏀懼埄浜庤綆楁満澶勭悊銆傚埌鐩墠涓烘錛岄噰鐢ㄥぇ绔垨鑰呭皬绔繘琛屾暟鎹瓨
鏀撅紝鍏跺浼樺鍔d篃娌℃湁瀹氳銆?/font> 鏈夌殑澶勭悊鍣ㄧ郴緇熼噰鐢ㄤ簡灝忕鏂瑰紡榪涜鏁版嵁瀛樻斁錛屽Intel鐨勫鑵俱傛湁鐨勫鐞嗗櫒緋葷粺閲囩敤浜嗗ぇ绔柟寮忚繘琛屾暟鎹瓨鏀撅紝濡侷BM鍗婂浣撳拰Freescale鐨凱owerPC澶勭悊鍣ㄣ備笉浠呭浜庡鐞嗗櫒錛屼竴浜涘璁劇殑璁捐涓篃瀛樺湪鐫浣跨敤澶х鎴栬呭皬绔繘琛屾暟鎹瓨鏀劇殑閫夋嫨銆?/font> 鍥犳鍦ㄤ竴涓鐞嗗櫒緋葷粺涓紝鏈夊彲鑳藉瓨鍦ㄥぇ绔拰灝忕妯″紡鍚屾椂瀛樺湪鐨勭幇璞°傝繖涓鐜拌薄涓虹郴緇熺殑杞‖浠惰璁″甫鏉ヤ簡涓嶅皬鐨勯夯鐑︼紝榪欒姹傜郴緇熻璁″伐紼嬪笀錛屽繀欏繪繁鍏ョ悊瑙eぇ绔拰灝忕妯″紡鐨勫樊鍒傚ぇ绔笌灝忕妯″紡鐨勫樊鍒綋鐜板湪涓涓鐞嗗櫒鐨勫瘎瀛樺櫒錛屾寚浠ら泦錛岀郴緇熸葷嚎絳夊悇涓眰嬈′腑銆?/font> 涓銆佸悓浣?/p>
鎴戜滑鏉ヤ簡瑙d竴涓嬩粈涔堟槸“鍚屼綑”銆傜畝鍗曟潵璇村氨鏄紝濡傛灉涓や釜鏁伴兘闄や互鏌愪釜鏁拌兘澶熸湁鐩稿悓鐨勪綑鏁幫紝閭d箞鎴戜滑灝辮榪欎袱涓暟“鍚屼綑”銆備笉榪囪繖嬈℃垜浠敤涓ヨ皚鐨勬暟瀛︽蹇墊潵琛ㄨ堪錛?/p>
涓や釜鏁存暟 a錛?em>b錛岃嫢瀹冧滑闄や互鏁存暟 m 鎵寰楃殑浣欐暟鐩哥瓑錛屽垯縐?a錛?em>b 瀵逛簬妯?m 鍚屼綑 璁頒綔 璇諱綔 a 鍚屼綑浜?b 妯?m 錛屾垨璇諱綔 a 涓?b 鍏充簬妯?m 鍚屼綑銆?/p>
姣斿 鎴戜滑鍐嶆潵浜嗚В涓涓嬬浉鍏崇殑鎬ц川錛?/p>
鏈変簡榪欎簺鎬ц川錛屽垽鏂袱涓暟鏄惁鍚屼綑灝卞彲浠ョ敤鏇寸畝鍗曠殑鏂規硶浜嗐傛牴鎹ц川涓錛屽師鏉ユ垜浠渶瑕佸垽鏂?(a mod m) == (b mod m)
鏄惁涓虹湡錛岀幇鍦ㄥ氨鍙互鐩存帴鍒ゆ柇 (a - b) mod m == 0
鏄惁涓虹湡浜嗐傝繖鏍峰氨鎶婂叾涓竴嬈℃眰浣欒繍綆楀彉涓哄噺娉曡繍綆椾簡銆備竴鑸潵璇村噺娉曡姣旈櫎娉曟洿瀹規槗鍦ㄨ綆楁満涓婂疄鐜幫紝榪愮畻閫熷害涔熸洿蹇?/p>
浜屻佹眰浣?(a * b * c * d) mod m = ? 鐢變簬璁$畻鏈鴻〃紺轟竴涓暣鏁伴氬父鐢?32bit 銆傝屽ぇ閲忚繛涔樿繍綆楀垯鍙兘浼氬鑷存暣鏁版孩鍑猴紝榪欐椂鎴戜滑灝辮鍒╃敤姹備綑涓浜涙ц川鏉ヨ繘琛屽鐞嗕簡銆傛妸浠ヤ笂寮忓瓙杞崲涓猴細 宸茬煡錛?(a * b) mod m == ((a mod m) * b) mod m 鎵浠ワ細 (a * b * c * d) mod m = ((((((a mod m) * b) mod m) * c) mod m) * d) mod m 榪欐牱灝辨妸榪炰箻榪愮畻鍒嗚В浜嗭紝姣忔鍙互鍏堣繘琛屾眰浣欒繍綆楃劧鍚庡啀榪涜涔樻硶榪愮畻銆?/p>
鍦ㄧ綉涓婃壘浜嗙偣璧勬枡錛屽湪ibus宸茬粡鍔犲叆鍒癠buntu鐨勬簮浜嗭紝濡傛灉闇瑕侊紝浣跨敤涓嬮潰鐨勫懡浠よ繘琛屽畨瑁咃細 鐢變簬瀹夎鍜屽嵏杞借蔣浠舵槸浣跨敤鐨勫繀欏誨墠鎻愶紝鎵浠ヨ繖閲屽apt鍛戒護榪涜涓浜涙葷粨銆傚湪鎬葷粨涔嬪墠錛岃繕寰楀ubuntu鐨勮蔣浠舵簮鐨勫湴鍧榪涜璇存槑錛屼負浜嗚揪鍒板ソ鐨勪笅杞芥簮鐨勯熷害錛屾渶濂介変竴涓渶蹇殑杞歡婧愶紝鐩墠鏉ヨhttp://ubuntu.srt.cn鏄渶蹇殑錛寀buntu鑷繁鎻愪緵浜嗘嫻嬬殑鍔熻兘錛屽彲浠ヨ嚜鍔ㄦ嫻嬶紙choose a download server -> select best server錛夈?/p>
鍏充簬apt-get鍛戒護鐨勮緇嗚岀畝鍗曠殑璇存槑錛屾槸銆?a >AptGetHowTo銆嬨傛敞鎰忥紝浣跨敤apt-get鍛戒護蹇呴』瑕佺敤root鏉冮檺銆傝繖閲岋紝鎽樻妱浜嗘渶甯哥敤鐨勫懡浠?...濡備笅 This command searches the repositories and installs the build dependencies for <package_name>. If the package is not in the repositories it will return an error. Aptitude is a [http://en.wikipedia.org/wiki/Ncurses Ncurses] viewer of packages installed or available. Aptitude can be used from the command line in a similar way to apt-get. See man aptitude for more information. This command will find packages that include <search_term>. This will find packages whose names contain <search_term>. Similar to apt-cache search, but also shows whether a package is installed on your system by marking it with ii (installed) and un (not installed). This command shows the description of package <package_name> and other relevant information including version, size, dependencies and conflicts. I want to feel the wind in my hair, I want the adrenaline of speed. So lets install a racing game. But what racing games are available? It gives me a lot of answers. I see a game named "torcs". Lets get some more information on this game. Hmmm... it seems interesting. But is this game not already installed on my computer? And what is the available version? Is it from Universe or main? Ok, so now, let's install it! What is the command I must type in the console to launch this game? In this example, it's straightforward ("torcs"), but that's not always the case. One way of finding the name of the binary is to look at what files the package has installed in "/usr/bin". For games, the binary will be in "/usr/games". For administrative programs, it's in "/usr/sbin". The first part of the command display all files installed by the package "torcs" (try it). With the second part, we ask to only display lines containing "/usr/games/". Hmmm, that game is cool. Maybe there are some extra tracks? But I'm running out of space. I will delete the apt cache! Oh no, my mother asked me to remove all games from this computer. But I want to keep the configuration files so I can simply re-install it later. If I want to also remove config files : 杞嚜 http://alexmogurenko.com/blog/programming/android-how-to-set-proxy-for-android-browser/ 涓嬮潰鏄師鏂?/p>
There are many reasons to make browser serf pages through proxy server: What to do if you want set proxy for android browser? there some ways: but as for me there exist simplier way, do it by your Java application using Settings provider: where proxy_ip/proxy_port = IP/port of proxy that you going to use. there left one problem, it will not work if we will not add one string to manifest file, here it is: <uses-permission android:name=”android.permission.WRITE_SETTINGS” /> Thats all, now it works, here is code: manifest file: <?xml version=”1.0″ encoding=”utf-8″?>
涓嬮潰鏄粠緗戜笂鎽樻妱鐨勪竴浜涗笢涓滐紝甯姪鐞嗚В鍜岃蹇嗭紝鏉ヨ嚜http://www.52rd.com/Blog/Detail_RD.Blog_imjacob_14837.html錛?br />
錛岄偅涔?m | (a − b) 錛岃繖閲?m | (a − b) 琛ㄧず (a − b) 鑳借 m 鏁撮櫎
錛?img alt="b " src="http://upload.wikimedia.org/math/7/2/c/72c4fa0bd69956b7e68d3d8cc2ec9d5c.png" />, 閭d箞
錛?img alt="c " src="http://upload.wikimedia.org/math/7/7/b/77b3768cf453ddc62ff2c3e668b93fad.png" />, 閭d箞
錛?img alt="a-c " src="http://upload.wikimedia.org/math/9/e/f/9ef96c57e3ad5d862af3178c718177d6.png" />錛?img alt="ac " src="http://upload.wikimedia.org/math/3/9/0/390116f8d52af94ccdb17c5ad2e199c0.png" />錛?img alt="a/c " src="http://upload.wikimedia.org/math/f/9/e/f9e3c5a2ad4272a6b596a641cb3bdb21.png" />
錛?閭d箞
Installation commands
apt-get install <package_name>
This command installs a new package.apt-get build-dep <package_name>
aptitude install <package_name>
apt-get install <package1_name> <package2_name> <package3_nam
Search commands
apt-cache search <search_term>
dpkg -l *<search_term>*
apt-cache show <package_name>
Typical usage example
apt-cache search racing game
apt-cache show torcs
apt-cache policy torcs
apt-get install torcs
dpkg -L torcs | grep /usr/games/
apt-cache search torcs
apt-get clean
apt-get remove torcs
apt-get purge torcs
鏂囩珷鏉ユ簮:http://localhost/wp2/?p=180
Settings.System.putString(getContentResolver(), Settings.System.HTTP_PROXY, "proxy_ip:proxy_port");
package com.BrowserSettings;
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.provider.Settings;
public class BrowserSettingsUI extends Activity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
final Button button = (Button) findViewById(R.id.Button01);
button.setOnClickListener(new Button.OnClickListener() {
public void onClick(View v) {
try
{
Settings.System.putString(getContentResolver(), Settings.System.HTTP_PROXY, "127.0.0.1:100");//enable proxy
}catch (Exception ex){
}
}
});
final Button button2 = (Button) findViewById(R.id.Button02);
button2.setOnClickListener(new Button.OnClickListener() {
public void onClick(View v) {
try
{
Settings.System.putString(getContentResolver(), Settings.System.HTTP_PROXY, "");//disable proxy
}catch (Exception ex){
}
}
});
}
}
<manifest xmlns:android=”http://schemas.android.com/apk/res/android”
package=”com.BrowserSettings”
android:versionCode=”1″
android:versionName=”1.0.0″>
<application android:icon=”@drawable/icon” android:label=”@string/app_name”>
<activity android:name=”.BrowserSettingsUI”
android:label=”@string/app_name”>
<intent-filter>
<action android:name=”android.intent.action.MAIN” />
<category android:name=”android.intent.category.LAUNCHER” />
</intent-filter>
</activity>
</application>
<uses-permission android:name=”android.permission.WRITE_SETTINGS” />
</manifest>
鏂囩珷鏉ユ簮:http://localhost/wp2/?p=172
鏁板褰掔撼娉曠敤鏉ュ湪鏁板涓婅瘉鏄庝笌鑷劧鏁?/b>N鏈夊叧鐨勫懡棰樼殑涓縐嶇壒孌婃柟娉曪紝瀹冧富瑕佺敤鏉ョ爺絀朵笌姝f暣鏁?/b>鏈夊叧鐨勬暟瀛﹂棶棰橈紝鍦ㄩ珮涓暟瀛︿腑甯哥敤鏉ヨ瘉鏄庣瓑寮忔垚绔嬪拰鏁板垪閫氶」鍏紡鎴愮珛銆?/p>
鐢ㄧ殑鏈澶氱殑鏄涓鏁板褰掔撼娉曞拰絎簩鏁板褰掔撼娉曪紝涓嬮潰璇︾粏璇存槑銆?/p>
絎竴鏁板褰掔撼娉?br />
鐢?錛?姝ワ紝鍙瘉鏄庡懡棰樻垚绔嬨?/p>
絎簩鏁板褰掔撼娉?br />
瀵圭涓鏁板褰掔撼娉曡繘琛屼簡鎵╁厖
鏈?錛?姝ワ紝鍙瘉鏄庡懡棰樻垚绔嬨?/p>
鍦ㄧ畻娉曟椂闂村鏉傚害鐨勮瘉鏄庝笂錛岀敱浜巒鍙栧兼槸涓涓嚜鐒舵暟錛屾墍浠ュ鐢ㄦ暟瀛﹀綊綰蟲硶鍘熺悊榪涜璇佹槑銆傚叾瀹烇紝璇佹槑寰幆姝g‘鎬х殑寰幆涓嶅彉寮忓氨鏄洿鎺ュ埄鐢ㄧ殑絎竴鏁板褰掔撼娉曘?/p>
鍙傝冿細
鐧懼害鐧劇錛屾暟瀛﹀綊綰蟲硶
閫掑綊瀹炵幇
鎬濊礬錛氬鏋滃彧鏈変竴涓妭鐐癸紝鍒欎粈涔堥兘涓嶅仛銆傚惁鍒欙紝灝嗗綋鍓嶉摼琛紙a1,a2...a3錛夌殑瀛愰摼琛紙a2,...an錛夎繘琛岄嗚漿錛岃繑鍥為嗚漿鍚庣殑絎竴涓妭鐐圭殑鎸囬拡錛屽啀灝哸1鑺傜偣鍔犲埌a2鑺傜偣鍚庨潰銆?/p>
浠g爜錛?榪欓噷娌℃湁浣跨敤澶磋妭鐐?
node * reverse(node * p){
if(p->next == null){
return p;
}
node * q = p->next;
node * head = reverse(q);
p->next = null;
q->next = p;
return head;
}
闈為掑綊瀹炵幇
鎬濊礬錛氫竴涓寚閽堣繘琛岄摼琛ㄧ殑閬嶅巻錛屼竴涓寚閽堟寚鍚戦嗚漿鍚庣殑閾捐〃鐨勭涓涓妭鐐癸紝鍦ㄩ亶鍘嗙殑榪囩▼涓紝灝嗗綋鍓嶈妭鐐瑰姞鍏ラ嗚漿鍚庣殑閾捐〃絎竴涓厓绱犲嵆鍙傝繑鍥為嗚漿鍚庣殑閾捐〃鐨勭涓涓妭鐐圭殑鎸囬拡銆?/p>
浠g爜錛氾紙榪欓噷娌℃湁浣跨敤澶磋妭鐐癸級
node * reverse(node * p){
node * p_reverse;
if(p != null){
p_reverse = p;
node * q = p->next;
p->next = null;
}
while(q != null){
p = q->next;
q->next = p_reverse;
p_reverse = q;
q = p;
}
}
瀵笴璇█鐢ㄧ殑澶皯錛屼笂闈㈢殑浠g爜瀹炵幇鍙兘鏈夌偣鎭跺績錛屼笉榪囧彲浠ュ疄鐜板姛鑳?...
浠ュ墠瀹夎Eclipse鎻掍歡鏃犻潪涓ょ鏂瑰紡, 鐩存帴copy鎻掍歡鍒癴eatures/plugins鐩綍鎴栬呭湪links鐩綍涓嬪垱寤洪摼鎺ユ枃浠? 鍒氬垰鍙戝竷鐨凟clipse 3.4鍙堟帹鍑哄彟涓縐嶆柊鐨勫畨瑁呴斿緞, 鏇村姞鐏墊椿銆侲clipse 3.4涓嬫湁涓猟ropins鐩綍, 鍙鎶婃彃浠舵斁鍒拌鐩綍涓嬪氨鍙互鍔犺澆, 鏈夊嚑縐嶆牸寮忓彲浠ラ夋嫨銆?/p>
1. 鏈綆鍗曠殑錛岀洿鎺ュ皢jar鍖呮斁鍒癲ropins鐩綍:
eclipse/
dropins/
com.essiembre.eclipse.i18n.resourcebundle_0.7.7
2. 浼犵粺鏍煎紡錛岀粺涓鏀懼埌涓涓猠clipse鐩綍涓?
eclipse/
dropins/
eclipse/
features/
plugins/
3. 鎸夌収鎻掍歡鍚嶇О鍖哄垎:
eclipse/
dropins/
resourcebundleeditor/
features/
plugins/
m2eclipse/
features/
plugins/
4. 綾諱技links鏂瑰紡娣誨姞閾炬帴:
eclipse/
dropins/
xfire.link
濡傛灉鍙畨瑁呬竴涓狤clipse鐨勮瘽寤鴻閲囩敤絎笁縐嶏紝鍚﹀垯閲囩敤絎洓縐嶃?/p>
濡傛灉鍙戠幇瀹夎浜嗘病鏈夋晥鏋滐紝鍙互鍒犻櫎eclipse涓葷洰褰曚笅鐨刓configuration\org.eclipse.update鍚庯紝鍐嶆墽琛宔clipse -clean璇曡瘯銆?/p>
鏂囩珷鏉ユ簮:http://localhost/wp2/?p=127
瀛楃鏁版嵁綾誨瀷
CHAR鏁版嵁綾誨瀷瀛樺偍鍥哄畾闀垮害鐨勫瓧絎﹀箋備竴涓狢HAR鏁版嵁綾誨瀷鍙互鍖呮嫭1鍒?000涓瓧絎︺傚鏋滃CHAR娌℃湁鏄庣‘鍦拌鏄庨暱搴︼紝瀹冪殑榛樿闀垮害鍒欒緗負1.濡傛灉瀵規煇涓狢HAR綾誨瀷鍙橀噺璧嬪鹼紝鍏墮暱搴﹀皬浜庤瀹氱殑闀垮害錛岄偅涔圤racle鑷姩鐢ㄧ┖鏍煎~鍏呫?/p>
VARCHAR2瀛樺偍鍙彉闀垮害鐨勫瓧絎︿覆銆傝櫧鐒朵篃蹇呴』鎸囧畾涓涓猇ARCHAR2鏁版嵁鍙橀噺鐨勯暱搴︼紝浣嗘槸榪欎釜闀垮害鏄寚瀵硅鍙橀噺璧嬪肩殑鐨勬渶澶ч暱搴﹁岄潪瀹為檯璧嬪奸暱搴︺備笉闇瑕佺敤絀烘牸濉厖銆傛渶澶氬彲璁劇疆涓?000涓瓧鑺傘傛墍浠ュ鏋滃瓨鍌ㄤ腑鏂囩殑鏃跺欙紝灝變笉鑳藉瓨鍌ㄥ埌4000涓瓧絎︿簡錛屽洜涓轟竴涓眽瀛椾細鍗犳湁澶氫釜瀛楄妭銆?/p>
鍥犱負VARCHAR2鏁版嵁綾誨瀷鍙瓨鍌ㄤ負璇ュ垪鎵璧嬬殑瀛楃錛堜笉鍔犵┖鏍鹼級錛屾墍浠ARCHAR2闇瑕佺殑瀛樺偍絀洪棿姣擟HAR鏁版嵁綾誨瀷瑕佸皬銆?/p>
Oracle鎺ㄨ崘浣跨敤VARCHAR2
NCHAR鍜孨VARCHAR2鏁版嵁綾誨瀷鍒嗗埆瀛樺偍鍥哄畾闀垮害涓庡彲鍙橀暱搴︾殑瀛楃鏁版嵁錛屼絾鏄畠浠嬌鐢ㄧ殑鏄拰鏁版嵁搴撳叾浠栫被鍨嬩笉鍚岀殑瀛楃闆嗐傚湪鍒涘緩鏁版嵁搴撴椂錛岄渶瑕佹寚瀹氭墍浣跨敤鐨勫瓧絎﹂泦錛屼互渚垮鏁版嵁搴撲腑鏁版嵁榪涜緙栫爜銆傝繕鍙互鎸囧畾涓涓緟鍔╃殑瀛楃闆嗭薊鍗蟲湰鍦拌璦闆嗭紙National Language Set錛岀畝縐癗LS錛夛冀銆侼CHAR鍜孨VARCHAR2綾誨瀷鐨勫垪浣跨敤杈呭姪瀛楃闆嗐?/p>
鍦∣racle9i涓紝鍙互浠ュ瓧絎﹁屼笉鏄瓧鑺備負鍗曚綅鏉ヨ〃紺篘CHAR鍜孨VARCHAR2鍒楃殑闀垮害銆?/p>
LONG鏁版嵁綾誨瀷鍙互瀛樻斁2GB鐨勫瓧絎︽暟鎹紝瀹冩槸浠庢棭鏈熺増鏈腑緇ф壙鏉ョ殑銆傜幇鍦ㄥ鏋滄兂瀛樺偍澶у閲忕殑鏁版嵁錛孫racle鎺ㄨ崘浣跨敤CLOB鍜孨CLOB鏁版嵁綾誨瀷銆傚湪琛ㄥ拰SQL璇彞涓嬌鐢↙ONG綾誨瀷鏈夎澶氶檺鍒躲?/p>
CLOB鍜孨CLOB鏁版嵁綾誨瀷鍙互瀛樺偍澶氳揪4GB鐨勫瓧絎︽暟鎹侼CLOB鏁版嵁綾誨瀷鍙瓨鍌∟LS鏁版嵁銆?/p>
鏁板瓧鏁版嵁綾誨瀷
Oracle浣跨敤鏍囧噯銆佸彲鍙橀暱搴︾殑鍐呴儴鏍煎紡鏉ュ瓨鍌ㄦ暟瀛椼傝繖涓唴閮ㄦ牸寮忕簿搴﹀彲浠ラ珮杈?8浣嶃?/p>
NUMBER鏁版嵁綾誨瀷鍙互鏈変袱涓檺瀹氱錛屽錛?/p>
column NUMBER 錛?precision錛?scale錛?/p>
precision琛ㄧず鏁板瓧涓殑鏈夋晥浣嶃傚鏋滄病鏈夋寚瀹歱recision鐨勮瘽錛孫racle灝嗕嬌鐢?8浣滀負綺懼害銆?/p>
scale琛ㄧず鏁板瓧灝忔暟鐐瑰彸杈圭殑浣嶆暟錛宻cale榛樿璁劇疆涓?銆傚鏋滄妸scale璁炬垚璐熸暟錛孫racle灝嗘妸璇ユ暟瀛楀彇鑸嶅埌灝忔暟鐐瑰乏杈圭殑鎸囧畾浣嶆暟銆?/p>
鏃ユ湡鏁版嵁綾誨瀷
Oracle鏍囧噯鏃ユ湡鏍煎紡涓猴細DD-MON-YY HH錛歁I錛歋S
閫氳繃淇敼瀹炰緥鐨勫弬鏁癗LS_DATE_FORMAT錛屽彲浠ユ敼鍙樺疄渚嬩腑鎻掑叆鏃ユ湡鐨勬牸寮忋傚湪涓涓細璇濇湡闂達紝鍙互閫氳繃ALTER SESSION SQL鍛戒護鏉ヤ慨鏀規棩鏈燂紝鎴栬呴氳繃浣跨敤SQL璇彞鐨凾O_DATE琛ㄨ揪寮忎腑鐨勫弬鏁版潵鏇存柊涓涓壒瀹氬箋?/p>
鍏跺畠鐨勬暟鎹被鍨?/p>
RAW鍜孡ONG RAW鏁版嵁綾誨瀷涓昏鐢ㄤ簬瀵規暟鎹簱榪涜瑙i噴銆傛寚瀹氳繖涓ょ綾誨瀷鏃訛紝Oracle浠ヤ綅鐨勫艦寮忔潵瀛樺偍鏁版嵁銆俁AW鏁版嵁綾誨瀷涓鑸敤浜庡瓨鍌ㄦ湁鐗瑰畾鏍煎紡鐨勫璞★紝濡備綅鍥俱?RAW鏁版嵁綾誨瀷鍙崰鐢?KB鐨勭┖闂達紝鑰孡ONG RAW鏁版嵁綾誨瀷鍒欏彲浠ュ崰鐢?GB澶у皬銆?/p>
ROWID ROWID鏄竴縐嶇壒孌婄殑鍒楃被鍨嬶紝縐頒箣涓轟吉鍒楋紙pseudocolumn錛夈俁OWID浼垪鍦⊿QL SELECT璇彞涓彲浠ュ儚鏅氬垪閭f牱琚闂侽racle鏁版嵁搴撲腑姣忚閮芥湁涓涓吉鍒椼俁OWID琛ㄧず琛岀殑鍦板潃錛孯OWID浼垪鐢≧OWID鏁版嵁綾誨瀷瀹氫箟銆?/p>
ROWID涓庣鐩橀┍鍔ㄧ殑鐗瑰畾浣嶇疆鏈夊叧錛屽洜姝わ紝ROWID鏄幏寰楄鐨勬渶蹇柟娉曘備絾鏄紝琛岀殑ROWID浼氶殢鐫鍗歌澆鍜岄噸杞芥暟鎹簱鑰屽彂鐢熷彉鍖栵紝鍥犳寤鴻涓嶈鍦ㄤ簨鍔?涓嬌鐢≧OWID浼垪鐨勫箋備緥濡傦紝涓鏃﹀綋鍓嶅簲鐢ㄥ凡緇忎嬌鐢ㄥ畬璁板綍錛屽氨娌℃湁鐞嗙敱淇濆瓨琛岀殑ROWID.涓嶈兘閫氳繃浠諱綍SQL璇彞鏉ヨ緗爣鍑嗙殑ROWID浼垪鐨勫箋?/p>
鍒楁垨鍙橀噺鍙互瀹氫箟鎴怰OWID鏁版嵁綾誨瀷錛屼絾鏄疧racle涓嶈兘淇濊瘉璇ュ垪鎴栧彉閲忕殑鍊兼槸涓涓湁鏁堢殑ROWID.
LOB
LOB錛堝ぇ鍨嬪璞★級鏁版嵁綾誨瀷錛屽彲浠ヤ繚瀛?GB鐨勪俊鎭侺OB鏈変互涓?縐嶇被鍨嬶細
銆侰LOB錛屽彧鑳藉瓨鍌ㄥ瓧絎︽暟鎹?/p>
銆侼CLOB錛屼繚瀛樻湰鍦拌璦瀛楃闆嗘暟鎹?/p>
銆侭LOB錛屼互浜岃繘鍒朵俊鎭繚瀛樻暟鎹?/p>
鍙互鎸囧畾灝嗕竴涓狶OB鏁版嵁淇濆瓨鍦∣racle鏁版嵁搴撳唴錛岃繕鏄寚鍚戜竴涓寘鍚鏁版嵁鐨勫閮ㄦ枃浠躲?/p>
LOB鍙互鍙備笌浜嬪姟銆傜鐞哃OB涓殑鏁版嵁蹇呴』閫氳繃DBMS_LOB PL/SQL鍐呯疆杞歡鍖呮垨鑰匫CI鎺ュ彛銆?/p>
涓轟簡渚夸簬灝哃ONG鏁版嵁綾誨瀷杞崲鎴怢OB錛孫racle9i鍖呭惈璁稿鍚屾椂鏀寔LOB鍜孡ONG鐨勫嚱鏁幫紝榪樺寘鎷竴涓狝LTER TABLE璇彞鐨勭殑鏂伴夋嫨錛屽畠鍏佽灝哃ONG鏁版嵁綾誨瀷鑷姩杞崲鎴怢OB.
BFILE
BFILE鏁版嵁綾誨瀷鐢ㄥ仛鎸囧悜瀛樺偍鍦∣racle鏁版嵁搴撲互澶栫殑鏂囦歡鐨勬寚閽堛?/p>
XMLType
浣滀負瀵筙ML鏀寔鐨勪竴閮ㄥ垎錛孫racle9i鍖呭惈浜嗕竴涓柊鐨勬暟鎹被鍨媂MLType.瀹氫箟涓篨MLType鐨勫垪灝嗗瓨鍌ㄤ竴涓湪瀛楃LOB鍒椾腑鐨刋ML鏂囨。銆傛湁璁稿鍐呯疆鐨勫姛鑳藉彲浠ヤ嬌浣犱粠鏂囧綋涓娊鍙栧崟涓妭鐐癸紝榪樺彲浠ュ湪XMLType鏂囨。涓浠諱綍鑺傜偣鍒涘緩绱㈠紩銆?/p>
鐢ㄦ埛鑷畾涔夋暟鎹?/strong>
浠嶰racle8浠ュ悗錛岀敤鎴峰彲浠ュ畾涔夎嚜宸辯殑澶嶆潅鏁版嵁綾誨瀷錛屽畠浠敱Oracle鍩烘湰鏁版嵁綾誨瀷緇勫悎鑰屾垚銆?/p>
AnyType銆丄nyData鍜孉nyDataSet
Oracle鍖呮嫭3涓柊鐨勬暟鎹被鍨嬶紝鐢ㄤ簬瀹氫箟鍦ㄧ幇鏈夋暟鎹被鍨嬩箣澶栫殑鏁版嵁緇撴瀯銆傚叾涓瘡縐嶆暟鎹被鍨嬪繀欏葷敤紼嬪簭鍗曞厓鏉ュ畾涔夛紝浠ヤ究璁㎡racle9i鐭ラ亾濡備綍澶勭悊榪欎簺綾誨瀷鐨勭壒瀹氬疄鐜般?/p>
棰濆鐨勶細
綾誨瀷杞崲
Oracle浼氳嚜鍔ㄥ皢鏌愪簺鏁版嵁綾誨瀷杞崲鎴愬叾浠栫殑鏁版嵁綾誨瀷錛岃漿鎹㈠彇鍐充簬鍖呮嫭璇ュ肩殑SQL璇彞銆?/p>
鏁版嵁杞崲榪樺彲浠ラ氳繃Oracle鐨勭被鍨嬭漿鎹㈠嚱鏁版樉紺哄湴榪涜銆?/p>
榪炴帴涓庢瘮杈?/strong>
鍦ㄥぇ澶氭暟騫沖彴涓奜racle SQL涓殑榪炴帴鎿嶄綔絎︾敤涓ゆ潯绔栫嚎錛坾|錛夎〃紺恒傝繛鎺ユ槸灝嗕袱涓瓧絎﹀艱繛鎺ャ侽racle鐨勮嚜鍔ㄧ被鍨嬭漿鎹㈠姛鑳戒嬌寰椾袱涓暟瀛楀間篃鍙互榪涜榪炴帴銆?/p>
NULL
NULL鍊兼槸鍏崇郴鏁版嵁搴撶殑閲嶈鐗瑰緛涔嬩竴銆傚疄闄呬笂錛孨ULL涓嶄唬琛ㄤ換浣曞鹼紝瀹冭〃紺烘病鏈夊箋傚鏋滆鍒涘緩琛ㄧ殑涓涓垪錛岃岃繖涓垪蹇呴』鏈夊鹼紝閭d箞搴斿皢瀹冩寚瀹氫負NOT NULL錛岃繖琛ㄧず璇ュ垪涓嶈兘鍖呭惈NULL鍊箋?/p>
浠諱綍鏁版嵁綾誨瀷閮藉彲浠ヨ祴浜圢ULL鍊箋侼ULL鍊煎紩鍏ヤ簡SQL榪愮畻鐨勪笁鎬侀昏緫銆傚鏋滄瘮杈冪殑涓鏂規槸NULL鍊鹼紝閭d箞浼氬嚭鐜?縐嶇姸鎬侊細TURE銆丗ALSE浠ュ強涓よ呴兘涓嶆槸銆?/p>
鍥犱負NULL鍊間笉絳変簬0鎴栧叾浠栦換浣曞鹼紝鎵浠ユ祴璇曟煇涓暟鎹槸鍚︿負NULL鍊煎彧鑳介氳繃鍏崇郴榪愮畻絎S NULL鏉ヨ繘琛屻?/p>
NULL鍊肩壒鍒傚悎浠ヤ笅鎯呭喌錛氬綋涓涓垪榪樻湭璧嬪兼椂銆傚鏋滈夋嫨涓嶄嬌鐢∟ULL鍊鹼紝閭d箞蹇呴』瀵硅鐨勬墍鏈夊垪閮借璧嬪箋傝繖瀹為檯涓婁篃鍙栨秷浜嗘煇鍒椾笉闇瑕佸肩殑鍙兘鎬э紝鍚屾椂瀵瑰畠璧嬬殑鍊間篃寰堝鏄撲駭鐢熻瑙c傝繖縐嶆儏鍐靛垯鍙兘璇緇堢鐢ㄦ埛錛屽茍涓斿鑷寸瘡璁℃搷浣滅殑閿欒緇撴灉銆?/p>
鍙傝冿細
銆奜racle鏁版嵁綾誨瀷銆嬶紝http://www.cnblogs.com/cxd4321/archive/2008/04/14/1153201.html