디비 언어설정때문에 한글정렬이 안될경우

Built-in Conversions

Conversion Name [a]	Source Encoding	Destination Encoding
`ascii_to_mic`	`SQL_ASCII`	`MULE_INTERNAL`
`ascii_to_utf_8`	`SQL_ASCII`	`UNICODE`
`big5_to_euc_tw`	`BIG5`	`EUC_TW`
`big5_to_mic`	`BIG5`	`MULE_INTERNAL`
`big5_to_utf_8`	`BIG5`	`UNICODE`
`euc_cn_to_mic`	`EUC_CN`	`MULE_INTERNAL`
`euc_cn_to_utf_8`	`EUC_CN`	`UNICODE`
`euc_jp_to_mic`	`EUC_JP`	`MULE_INTERNAL`
`euc_jp_to_sjis`	`EUC_JP`	`SJIS`
`euc_jp_to_utf_8`	`EUC_JP`	`UNICODE`
`euc_kr_to_mic`	`EUC_KR`	`MULE_INTERNAL`
`euc_kr_to_utf_8`	`EUC_KR`	`UNICODE`
`euc_tw_to_big5`	`EUC_TW`	`BIG5`
`euc_tw_to_mic`	`EUC_TW`	`MULE_INTERNAL`
`euc_tw_to_utf_8`	`EUC_TW`	`UNICODE`
`gb18030_to_utf_8`	`GB18030`	`UNICODE`
`gbk_to_utf_8`	`GBK`	`UNICODE`
`iso_8859_10_to_utf_8`	`LATIN6`	`UNICODE`
`iso_8859_13_to_utf_8`	`LATIN7`	`UNICODE`
`iso_8859_14_to_utf_8`	`LATIN8`	`UNICODE`
`iso_8859_15_to_utf_8`	`LATIN9`	`UNICODE`
`iso_8859_16_to_utf_8`	`LATIN10`	`UNICODE`
`iso_8859_1_to_mic`	`LATIN1`	`MULE_INTERNAL`
`iso_8859_1_to_utf_8`	`LATIN1`	`UNICODE`
`iso_8859_2_to_mic`	`LATIN2`	`MULE_INTERNAL`
`iso_8859_2_to_utf_8`	`LATIN2`	`UNICODE`
`iso_8859_2_to_windows_1250`	`LATIN2`	`WIN1250`
`iso_8859_3_to_mic`	`LATIN3`	`MULE_INTERNAL`
`iso_8859_3_to_utf_8`	`LATIN3`	`UNICODE`
`iso_8859_4_to_mic`	`LATIN4`	`MULE_INTERNAL`
`iso_8859_4_to_utf_8`	`LATIN4`	`UNICODE`
`iso_8859_5_to_koi8_r`	`ISO_8859_5`	`KOI8`
`iso_8859_5_to_mic`	`ISO_8859_5`	`MULE_INTERNAL`
`iso_8859_5_to_utf_8`	`ISO_8859_5`	`UNICODE`
`iso_8859_5_to_windows_1251`	`ISO_8859_5`	`WIN`
`iso_8859_5_to_windows_866`	`ISO_8859_5`	`ALT`
`iso_8859_6_to_utf_8`	`ISO_8859_6`	`UNICODE`
`iso_8859_7_to_utf_8`	`ISO_8859_7`	`UNICODE`
`iso_8859_8_to_utf_8`	`ISO_8859_8`	`UNICODE`
`iso_8859_9_to_utf_8`	`LATIN5`	`UNICODE`
`johab_to_utf_8`	`JOHAB`	`UNICODE`
`koi8_r_to_iso_8859_5`	`KOI8`	`ISO_8859_5`
`koi8_r_to_mic`	`KOI8`	`MULE_INTERNAL`
`koi8_r_to_utf_8`	`KOI8`	`UNICODE`
`koi8_r_to_windows_1251`	`KOI8`	`WIN`
`koi8_r_to_windows_866`	`KOI8`	`ALT`
`mic_to_ascii`	`MULE_INTERNAL`	`SQL_ASCII`
`mic_to_big5`	`MULE_INTERNAL`	`BIG5`
`mic_to_euc_cn`	`MULE_INTERNAL`	`EUC_CN`
`mic_to_euc_jp`	`MULE_INTERNAL`	`EUC_JP`
`mic_to_euc_kr`	`MULE_INTERNAL`	`EUC_KR`
`mic_to_euc_tw`	`MULE_INTERNAL`	`EUC_TW`
`mic_to_iso_8859_1`	`MULE_INTERNAL`	`LATIN1`
`mic_to_iso_8859_2`	`MULE_INTERNAL`	`LATIN2`
`mic_to_iso_8859_3`	`MULE_INTERNAL`	`LATIN3`
`mic_to_iso_8859_4`	`MULE_INTERNAL`	`LATIN4`
`mic_to_iso_8859_5`	`MULE_INTERNAL`	`ISO_8859_5`
`mic_to_koi8_r`	`MULE_INTERNAL`	`KOI8`
`mic_to_sjis`	`MULE_INTERNAL`	`SJIS`
`mic_to_windows_1250`	`MULE_INTERNAL`	`WIN1250`
`mic_to_windows_1251`	`MULE_INTERNAL`	`WIN`
`mic_to_windows_866`	`MULE_INTERNAL`	`ALT`
`sjis_to_euc_jp`	`SJIS`	`EUC_JP`
`sjis_to_mic`	`SJIS`	`MULE_INTERNAL`
`sjis_to_utf_8`	`SJIS`	`UNICODE`
`tcvn_to_utf_8`	`TCVN`	`UNICODE`
`uhc_to_utf_8`	`UHC`	`UNICODE`
`utf_8_to_ascii`	`UNICODE`	`SQL_ASCII`
`utf_8_to_big5`	`UNICODE`	`BIG5`
`utf_8_to_euc_cn`	`UNICODE`	`EUC_CN`
`utf_8_to_euc_jp`	`UNICODE`	`EUC_JP`
`utf_8_to_euc_kr`	`UNICODE`	`EUC_KR`
`utf_8_to_euc_tw`	`UNICODE`	`EUC_TW`
`utf_8_to_gb18030`	`UNICODE`	`GB18030`
`utf_8_to_gbk`	`UNICODE`	`GBK`
`utf_8_to_iso_8859_1`	`UNICODE`	`LATIN1`
`utf_8_to_iso_8859_10`	`UNICODE`	`LATIN6`
`utf_8_to_iso_8859_13`	`UNICODE`	`LATIN7`
`utf_8_to_iso_8859_14`	`UNICODE`	`LATIN8`
`utf_8_to_iso_8859_15`	`UNICODE`	`LATIN9`
`utf_8_to_iso_8859_16`	`UNICODE`	`LATIN10`
`utf_8_to_iso_8859_2`	`UNICODE`	`LATIN2`
`utf_8_to_iso_8859_3`	`UNICODE`	`LATIN3`
`utf_8_to_iso_8859_4`	`UNICODE`	`LATIN4`
`utf_8_to_iso_8859_5`	`UNICODE`	`ISO_8859_5`
`utf_8_to_iso_8859_6`	`UNICODE`	`ISO_8859_6`
`utf_8_to_iso_8859_7`	`UNICODE`	`ISO_8859_7`
`utf_8_to_iso_8859_8`	`UNICODE`	`ISO_8859_8`
`utf_8_to_iso_8859_9`	`UNICODE`	`LATIN5`
`utf_8_to_johab`	`UNICODE`	`JOHAB`
`utf_8_to_koi8_r`	`UNICODE`	`KOI8`
`utf_8_to_sjis`	`UNICODE`	`SJIS`
`utf_8_to_tcvn`	`UNICODE`	`TCVN`
`utf_8_to_uhc`	`UNICODE`	`UHC`
`utf_8_to_windows_1250`	`UNICODE`	`WIN1250`
`utf_8_to_windows_1251`	`UNICODE`	`WIN`
`utf_8_to_windows_1256`	`UNICODE`	`WIN1256`
`utf_8_to_windows_866`	`UNICODE`	`ALT`
`utf_8_to_windows_874`	`UNICODE`	`WIN874`
`windows_1250_to_iso_8859_2`	`WIN1250`	`LATIN2`
`windows_1250_to_mic`	`WIN1250`	`MULE_INTERNAL`
`windows_1250_to_utf_8`	`WIN1250`	`UNICODE`
`windows_1251_to_iso_8859_5`	`WIN`	`ISO_8859_5`
`windows_1251_to_koi8_r`	`WIN`	`KOI8`
`windows_1251_to_mic`	`WIN`	`MULE_INTERNAL`
`windows_1251_to_utf_8`	`WIN`	`UNICODE`
`windows_1251_to_windows_866`	`WIN`	`ALT`
`windows_1256_to_utf_8`	`WIN1256`	`UNICODE`
`windows_866_to_iso_8859_5`	`ALT`	`ISO_8859_5`
`windows_866_to_koi8_r`	`ALT`	`KOI8`
`windows_866_to_mic`	`ALT`	`MULE_INTERNAL`
`windows_866_to_utf_8`	`ALT`	`UNICODE`
`windows_866_to_windows_1251`	`ALT`	`WIN`
`windows_874_to_utf_8`	`WIN874`	`UNICODE`
Notes: a. The conversion names follow a standard naming scheme: The official name of the source encoding with all non-alphanumeric characters replaced by underscores followed by `_to_` followed by the equally processed destination encoding name. Therefore the names might deviate from the customary encoding names.

예를 들면 이렇게 사용하면 됩니다

select * from event_memb order by Convert(memb_nm using mic_to_euc_kr)

'Story > postgresql' 카테고리의 다른 글

그누보드 게시판 글작성시 submit 버튼을 이미지 버튼으로 교체시 문제 해결 (0)	2017.10.27
postgres 특정 테이블만 백업 (0)	2011.11.15
postgres dump (0)	2011.11.15
postgresql backup (0)	2009.02.28
대소문자 가리지 않고 검색하기 (0)	2009.01.19

Stdio

디비 언어설정때문에 한글정렬이 안될경우

'Story > postgresql' 카테고리의 다른 글

티스토리툴바

디비 언어설정때문에 한글정렬이 안될경우

'Story > postgresql' 카테고리의 다른 글

'Story/postgresql' Related Articles

티스토리툴바