SQL ORACLE Polish letters translate

Question

I want find a solutions to change letters in sql In Polish language we have 'ą','ć','ł','ń'

when i make select lower(translate(sname,'łńą','lna')) from emplo it dosn't work as it should be.

help friends :)

Hi @Artur Stolc. Lower function should be executed before translate. Could you provide sample data? — Jacek Wróbel, Oct 29 '18 at 08:42
@jacek Wróbel select sname, lower(translate(sname,'łńą','lna')) as snamet from emplo; sname snamet Łącka Łacka Ńika Nika — Artur Stolc, Oct 29 '18 at 08:56

score 1 · Accepted Answer · answered Oct 29 '18 at 09:50

1

The polish letters are stored with the same ascii value as the west european letters, e.g.

select ascii('Ł'), ascii('ł'), ascii('L'), ascii('l') from dual;

>> 76 108 76 108

You can change the representation by changing the character set:

select convert('Fuß', 'WE8ISO8859P1', 'US7ASCII') from dual

>> Fu¿

Find character sets supported by Oracle by:

select * from  V$NLS_VALID_VALUES where parameter = 'CHARACTERSET'

Polish character set is ISO 8859-2 (Eastern European)

answered Oct 29 '18 at 09:50

Frank Ockenfuss

and how to view with one is default on database ?? – Artur Stolc Oct 29 '18 at 11:08
@ArturStolc default on database: select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET'; – Frank Ockenfuss Oct 30 '18 at 13:30

1 Answers1