var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: national characters
I am new to postgre and have following problem
I have table that has column surname that contain also national characters like á í ľ š č š ú ľ .....
I would like to write procedure which will convert data from this column to ascii encoding only so I can try to find matches also in case user has wrong spelling.
for example it should turn 'barcíková' into 'barcikova'
I was thinking about one function that would replace all vowels in searched name into regular expression
it would turn 'barcíková' into 'b(a|á)r(c|4)(í|i)k)(o|ó)v(á|a)'
and than use regexp to proceed the search
Am I on the right way ?
Is it possible ?
I don't know which character set you are using, but if it is LATIN1, LATIN2 or WIN1250 you might find the function to_ascii useful, see:
Originally Posted by mikosan
thanx a lot
it works perfectly with to_acii()
SELECT surname, name, pid, FROM pacient WHERE to_ascii(surname) ILIKE to_ascii('Holecka%') || '' || ''ORDER BY priezvisko "