今天遇到一个问题是往 SQL Server 中导入像m²、m³这样的单位数据,可是在 SQL Server 中查看到的都是 m2、m3,于是在网上查了一下资料,顺便摘录下来供日后查阅。
一 Windows 系统下快速键入一些特殊字符
ALT+小键盘0153 ™
ALT+小键盘0169 ©
ALT+小键盘0174 ®
ALT+小键盘0177 ±
ALT+小键盘0178 ²
ALT+小键盘0179 ³
ALT+小键盘0188 ¼
ALT+小键盘0189 ½
下面是从 http://www.wikihow.com/Type-Symbols-Using-the-ALT-Key 查到的特殊字符键入方法总结:
SYMBOL |
NAME |
CODE (ALT +) |
SYMBOL |
NAME |
CODE (ALT +) |
© |
Copyrighted |
0169 |
♄ |
Saturn |
9796 |
® |
Reserved mark |
0174 |
♅ |
Uranus |
9797 |
℠ |
Service mark |
8480 |
♆ |
Neptune |
9798 |
℃ |
Celsius |
8451 |
♇ |
Pluto |
9799 |
℅ |
Care of |
8453 |
♈ |
Aries |
9800 |
℉ |
Fahrenheit |
8457 |
♉ |
Taurus |
9801 |
№ |
Number symbol |
8470 |
♊ |
Gemini |
9802 |
℗ |
Sound recording copyright |
8471 |
♋ |
Cancer |
9803 |
℞ |
Prescription/pharmaceutical symbol |
8478 |
♌ |
Leo |
9804 |
Ω |
Ohm |
8486 |
♍ |
Virgo |
9805 |
℧ |
Inverted ohm |
8487 |
♎ |
Libra |
9806 |
☀ |
Sunshine |
9728 |
♏ |
Scorpio |
9807 |
☁ |
Cloud |
9729 |
♐ |
Sagittarius |
9808 |
☂ |
Umbrella |
9730 |
♑ |
Capricorn |
9809 |
☃ |
Snowman |
9731 |
♒ |
Aquarius |
9810 |
☄ |
Comet |
9732 |
♓ |
Pisces |
9811 |
★ |
Star (solid) |
9733 |
♔ |
White king |
9812 |
☆ |
Star (outline) |
9734 |
♕ |
White queen |
9813 |
☇ |
Lightning |
9735 |
♖ |
White rook |
9814 |
☈ |
Thunderstorm |
9736 |
♗ |
White bishop |
9815 |
☉ |
Sun |
9737 |
♘ |
White knight |
9816 |
☊ |
Ascending node |
9738 |
♙ |
White pawn |
9817 |
☋ |
Descending node |
9739 |
♚ |
Black king |
9818 |
☌ |
Conjunction |
9740 |
♛ |
Black queen |
9819 |
☍ |
Opposition |
9741 |
♜ |
Black rook |
9820 |
☎ |
Phone (solid) |
9742 |
♝ |
Black bishop |
9821 |
☏ |
Phone (outline) |
9743 |
♞ |
Black knight |
9822 |
☐ |
Checkbox |
9744 |
♟ |
Black pawn |
9824 |
☑ |
Ballot box |
9745 |
♠ |
Black spade suit |
9824 |
☒ |
Ballot box with X |
9746 |
♡ |
Red heart suit |
9825 |
☓ |
Saltire (St. Andrew's Cross) |
9747 |
♢ |
Red diamond suit |
9826 |
☚ |
Left-pointing index finger (solid) |
9754 |
♣ |
Black club suit(or shamrock) |
9827 |
☛ |
Right-pointing index finger (solid) |
9755 |
♤ |
Red spade suit |
9828 |
☜ |
Left-pointing index finger (outline) |
9756 |
♥ |
Black heart suit (or valentine) |
9829 |
☝ |
Upwards-pointing index finger (outline) |
9757 |
♦ |
Black diamond suit |
9830 |
☞ |
Right-pointing index finger (outline) |
9758 |
♧ |
Red club suit |
9831 |
☟ |
Downwards-pointing index finger (outline) |
9759 |
♨ |
Hot springs |
9832 |
☠ |
Skull & crossbones |
9760 |
♩ |
Musical quarter note |
9833 |
☡ |
Caution sign |
9761 |
♪ |
Musical eighth note |
9834 |
☢ |
Radioactive sign |
9762 |
♫ |
Musical single bar note |
9742 |
☣ |
Biohazard sign |
9763 |
♬ |
Musical double bar note |
9836 |
☤ |
Caduceus or "Kerykeion" |
9764 |
♭ |
Flat note |
9837 |
☥ |
Ankh |
9765 |
♮ |
Natural note |
9838 |
☦ |
Eastern Christian cross |
9766 |
♯ |
Sharp note |
9839 |
☧ |
Chi Rho cross |
9767 |
✁ |
Cut above |
9985 |
☨ |
Patriarchal cross |
9768 |
✂ |
Cut here |
9986 |
☩ |
Greek cross |
9769 |
✃ |
Cut below |
9987 |
☪ |
Crescent moon & star |
9770 |
✄ |
Scissors |
9988 |
☫ |
Farsi symbol |
9771 |
✆ |
Public pay phone |
9990 |
☬ |
Adi Shakti |
9772 |
✇ |
Film reel (tape spool) |
9991 |
☭ |
Hammer & sickle |
9773 |
✈ |
Airport/airplane |
9992 |
☮ |
Peace sign |
9774 |
✉ |
Envelope/mail/email |
9993 |
☯ |
Yin & yang |
9775 |
✌ |
Victory sign |
9996 |
☰ |
Trigram Heaven |
9776 |
✍ |
Signature/sign here |
9997 |
☱ |
Trigram Lake |
9777 |
✎ |
Pencil diagonal down |
9998 |
☲ |
Trigram Fire |
9778 |
✏ |
Pencil |
9999 |
☳ |
Trigram Thunder |
9779 |
✐ |
Pencil diagonal up |
10000 |
☴ |
Trigram Wind |
9780 |
✓ |
Checkmark |
10003 |
☵ |
Trigram Water |
9781 |
✔ |
Heavy checkmark |
10004 |
☶ |
Trigram Mountain |
9782 |
✕ |
Multiplication sign/X |
10005 |
☷ |
Trigram Earth |
9783 |
✖ |
Heavy multiplication sign/X |
10006 |
☸ |
Dharma wheel |
9784 |
✗ |
Ballot X |
10007 |
☹ |
Frowning face |
9785 |
✘ |
Heavy ballot X |
10008 |
☺ |
Smiley face |
9786 |
✝ |
Latin Roman cross |
10013 |
☻ |
Black smiley face |
9787 |
✞ |
Latin cross 3D shadow |
10014 |
☽ |
Waxing crescent moon |
9789 |
✟ |
Latin cross outline |
10015 |
☾ |
Waning crescent moon |
9790 |
✠ |
Maltese Cross |
10016 |
☿ |
Mercury |
9791 |
✡ |
Star of David |
10017 |
♀ |
Venus (female symbol) |
9792 |
❛ |
Quotation mark single comma |
10075 |
♁ |
Earth symbol |
9793 |
❜ |
Quotation mark single comma |
10076 |
♂ |
Mars (male symbol) |
9794 |
❝ |
Quotation mark double turned comma |
10077 |
♃ |
Jupiter |
9795 |
❞ |
Quotation mark double comma |
10078 |
二 SQL 中查询和插入特殊字符数据
唯一区别是第二句在含有特殊字符的字符串前面加了一个 N ,两句导入的结果就是,前一句的数据在 SQL Server 中是 m2,后者看到的才是 m²。
同样,要查找的时候也是要在含特殊字符的字符串前面加上一个 N 才可匹配。