POSTGRESQL HOW TO DISTINCT Fullwidth

Question

I have data in my dataset like below,in varchar data type.

123456789X
123456789x
123456789x
１２３４５６７８９X

Please advise how to use distinct lower to distinct above 4 to 1? Thanks.

I found how to solve this problem by:

SELECT DISTINCT(TRANSLATE(LOWER(telephone),
'－０１２３４５６７８９ＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ',
'-0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'))

user_9678924 · Answer

This is the solution:

SELECT DISTINCT(TRANSLATE(LOWER(telephone),
'－０１２３４５６７８９ＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ',
'-0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'))

user_2422776 · Answer

I'd remove the spaces (using replace) and then apply distinct:

SELECT DISTINCT REPLACE(data, ' ', '')
FROM   mytable