UNICODE()
UNICODE() 함수는 입력 식의 첫 번째 문자에 대해 정수 값(유니코드 값)을 반환한다.
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse에서 작동한다.
형식
UNICODE(character_expression)
매개변수
character_expression
:
nchar 또는 varchar 식
예제
입력 표현식의 첫 번째 문자에 대해 유니코드 값을 반환해보자.
SELECT UNICODE('Atlanta');
기본 예시
| 65 |
입력 표현식의 첫 번째 문자에 대해 유니코드 값을 반환해보자.
SELECT UNICODE(CustomerName) AS UnicodeOfFirstChar FROM Customers;
기본 예시
| UnicodeOfFirstChar | CustomerName |
|---|---|
| 65 | Alfreds Futterkiste |
| 65 | Ana Trujillo Emparedados y helados |
| 65 | Antonio Moreno Taquería |
| 65 | Around the Horn |
| 66 | Berglunds snabbköp |
| 66 | Blauer See Delikatessen |
| 66 | Blondel père et fils |
| 66 | Bólido Comidas preparadas |
| 66 | Bon app |
| 66 | Bottom-Dollar Marketse |
| 66 | Bs Beverages |
| 67 | Cactus Comidas para llevar |
| 67 | Centro comercial Moctezuma |
| 67 | Chop-suey Chinese |
| 67 | Comércio Mineiro |
| 67 | Consolidated Holdings |
| 68 | Drachenblut Delikatessend |
| 68 | Du monde entier |
| 69 | Eastern Connection |
| 69 | Ernst Handel |
| 70 | Familia Arquibaldo |
| 70 | FISSA Fabrica Inter. Salchichas S.A. |
| 70 | Folies gourmandes |
| 70 | Folk och fä HB |
| 70 | Frankenversand |
| 70 | France restauration |
| 70 | Franchi S.p.A. |
| 70 | Furia Bacalhau e Frutos do Mar |
| 71 | Galería del gastrónomo |
| 71 | Godos Cocina Típica |
| 71 | Gourmet Lanchonetes |
| 71 | Great Lakes Food Market |
| 71 | GROSELLA-Restaurante |
| 72 | Hanari Carnes |
| 72 | HILARIÓN-Abastos |
| 72 | Hungry Coyote Import Store |
| 72 | Hungry Owl All-Night Grocers |
| 73 | Island Trading |
| 75 | Königlich Essen |
| 76 | La corne dabondance |
| 76 | La maison dAsie |
| 76 | Laughing Bacchus Wine Cellars |
| 76 | Lazy K Kountry Store |
| 76 | Lehmanns Marktstand |
| 76 | Lets Stop N Shop |
| 76 | LILA-Supermercado |
| 76 | LINO-Delicateses |
| 76 | Lonesome Pine Restaurant |
| 77 | Magazzini Alimentari Riuniti |
| 77 | Maison Dewey |
| 77 | Mère Paillarde |
| 77 | Morgenstern Gesundkost |
| 78 | North/South |
| 79 | Océano Atlántico Ltda. |
| 79 | Old World Delicatessen |
| 79 | Ottilies Käseladen |
| 80 | Paris spécialités |
| 80 | Pericles Comidas clásicas |
| 80 | Piccolo und mehr |
| 80 | Princesa Isabel Vinhoss |
| 81 | Que Delícia |
| 81 | Queen Cozinha |
| 81 | QUICK-Stop |
| 82 | Rancho grande |
| 82 | Rattlesnake Canyon Grocery |
| 82 | Reggiani Caseifici |
| 82 | Ricardo Adocicados |
| 82 | Richter Supermarkt |
| 82 | Romero y tomillo |
| 83 | Santé Gourmet |
| 83 | Save-a-lot Markets |
| 83 | Seven Seas Imports |
| 83 | Simons bistro |
| 83 | Spécialités du monde |
| 83 | Split Rail Beer & Ale |
| 83 | Suprêmes délices |
| 84 | The Big Cheese |
| 84 | The Cracker Box |
| 84 | Toms Spezialitäten |
| 84 | Tortuga Restaurante |
| 84 | Tradição Hipermercados |
| 84 | Trails Head Gourmet Provisioners |
| 86 | Vaffeljernet |
| 86 | Victuailles en stock |
| 86 | Vins et alcools Chevalier |
| 68 | Die Wandernde Kuh |
| 87 | Wartian Herkku |
| 87 | Wellington Importadora |
| 87 | White Clover Markets |
| 87 | Wilman Kala |
| 87 | Wolski |
참고
W3C School - SQL UNICODE() Function
W3C School - SQL Tutorial
공부 목적 블로그