Oracle sql capitalized turkish characters

user_13736655 0
Viewed 556

Hello In my table I have a string like that TAKIM ELBİSE FABRİKASI I want to capitalize it with INITCAP() but it returns like Takim Elbise Fabrikasi but My expected result is Takım Elbise Fabrikası how can I do it ?

Thanks in advance

capitalize oracle11g oracle
1 Answers

I don't know Turkish, but - try

NLS_INITCAP('TAKIM ELBİSE FABRİKASI')

or

NLS_INITCAP('TAKIM ELBİSE FABRİKASI', 'nls_sort = xturkish')
user_90979060
Related