Skip to content

Instantly share code, notes, and snippets.

@vinh0604
Created August 16, 2014 16:52
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vinh0604/6cd5af7d50d87085818c to your computer and use it in GitHub Desktop.
Save vinh0604/6cd5af7d50d87085818c to your computer and use it in GitHub Desktop.
Postgres unaccent rules for Vietnamese
À A
Á A
Ả A
Ạ A
 A
Ấ A
Ầ A
Ẩ A
Ậ A
Ẫ A
à A
Ä A
Å A
Æ A
à a
á a
ả a
ạ a
â a
ấ a
ầ a
ẩ a
ẫ a
ậ a
ã a
ä a
å a
æ a
Ā A
ā a
Ă A
Ắ A
Ằ A
Ẳ A
Ẵ A
Ặ A
ă a
ắ a
ằ a
ẳ a
ẵ a
ặ a
Ą A
ą a
Ç C
ç c
Ć C
ć c
Ĉ C
ĉ c
Ċ C
ċ c
Č C
č c
Ď D
ď d
Đ D
đ d
È E
É E
Ẹ E
Ê E
Ế E
Ề E
Ễ E
Ệ E
Ë E
è e
é e
ẹ e
ê e
ề e
ế e
ễ e
ệ e
ë e
Ē E
ē e
Ĕ E
ĕ e
Ė E
ė e
Ę E
ę e
Ě E
ě e
Ĝ G
ĝ g
Ğ G
ğ g
Ġ G
ġ g
Ģ G
ģ g
Ĥ H
ĥ h
Ħ H
ħ h
Ĩ I
Ì I
Í I
Ỉ I
Ị I
Î I
Ï I
ì i
í i
ỉ i
ị i
î i
ï i
ĩ i
Ī I
ī i
Ĭ I
ĭ i
Į I
į i
İ I
ı i
IJ I
ij i
Ĵ J
ĵ j
Ķ K
ķ k
ĸ k
Ĺ L
ĺ l
Ļ L
ļ l
Ľ L
ľ l
Ŀ L
ŀ l
Ł L
ł l
Ñ N
ñ n
Ń N
ń n
Ņ N
ņ n
Ň N
ň n
ʼn n
Ŋ N
ŋ n
Ò O
Ó O
Ỏ O
Ọ O
Ô O
Ố O
Ồ O
Ổ O
Ỗ O
Ộ O
Ố O
Ồ O
Ổ O
Ỗ O
Ộ O
Ơ O
Ớ O
Ờ O
Ở O
Ỡ O
Ợ O
Õ O
Ö O
ò o
ó o
ỏ o
ọ o
ô o
ố o
ồ o
ổ o
ỗ o
ộ o
ơ o
ớ o
ờ o
ỡ o
ợ o
ở o
õ o
ö o
Ō O
ō o
Ŏ O
ŏ o
Ő O
ő o
ΠE
œ e
Ø O
ø o
Ŕ R
ŕ r
Ŗ R
ŗ r
Ř R
ř r
ß S
Ś S
ś s
Ŝ S
ŝ s
Ş S
ş s
Š S
š s
Ţ T
ţ t
Ť T
ť t
Ŧ T
ŧ t
Ù U
Ú U
Ủ U
Ụ U
Ư U
Ừ U
Ứ U
Ử U
Ữ U
Ự U
Û U
Ü U
ù u
ú u
ủ u
ụ u
û u
ư u
ứ u
ừ u
ử u
ữ u
ự u
ü u
Ũ U
ũ u
Ū U
ū u
Ŭ U
ŭ u
Ů U
ů u
Ű U
ű u
Ų U
ų u
Ŵ W
ŵ w
Ý Y
ý y
ÿ y
Ŷ Y
ŷ y
Ÿ Y
Ź Z
ź z
Ż Z
ż z
Ž Z
ž z
ё е
Ё Е
@osteel
Copy link

osteel commented Oct 14, 2015

Thanks for this.

Just so you know (PostgreSQL 9.4):

WARNING:  duplicate TO argument, use first one
CONTEXT:  line 159 of configuration file "/usr/share/postgresql/9.4/tsearch_data/unaccent_custom.rules": "Ố   O
"
WARNING:  duplicate TO argument, use first one
CONTEXT:  line 160 of configuration file "/usr/share/postgresql/9.4/tsearch_data/unaccent_custom.rules": "Ồ   O
"
WARNING:  duplicate TO argument, use first one
CONTEXT:  line 161 of configuration file "/usr/share/postgresql/9.4/tsearch_data/unaccent_custom.rules": "Ổ   O
"
WARNING:  duplicate TO argument, use first one
CONTEXT:  line 162 of configuration file "/usr/share/postgresql/9.4/tsearch_data/unaccent_custom.rules": "Ỗ   O
"
WARNING:  duplicate TO argument, use first one
CONTEXT:  line 163 of configuration file "/usr/share/postgresql/9.4/tsearch_data/unaccent_custom.rules": "Ộ   O
"

@thuandt
Copy link

thuandt commented Dec 2, 2015

I have same WARNING when restore in 9.3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment