[DATABASE/PDW] COLLATE : 한글 완성형 코드 설정하기

icodebroker PDW 2024-06-18

■ COLLATE 키워드를 사용해 한글 완성형 코드를 설정하는 방법을 보여준다.

▶ 예제 코드 (SQL)


CREATE TABLE dbo.NewStudent
(
    ID   VARCHAR(10)  COLLATE Latin1_General_100_CI_AS_KS_WS NOT NULL
   ,NAME VARCHAR(100) COLLATE Latin1_General_100_CI_AS_KS_WS NOT NULL
)
WITH
(
    DISTRIBUTION = HASH(ID)
   ,CLUSTERED COLUMNSTORE INDEX
)
AS
SELECT
    ID,
    NAME
FROM dbo.STUDENT;

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

CREATE TABLE dbo.NewStudent

(

ID VARCHAR(10) COLLATE Latin1_General_100_CI_AS_KS_WS NOT NULL

,NAME VARCHAR(100) COLLATE Latin1_General_100_CI_AS_KS_WS NOT NULL

)

WITH

(

DISTRIBUTION = HASH(ID)

,CLUSTERED COLUMNSTORE INDEX

)

AS

SELECT

ID,

NAME

FROM dbo.STUDENT;