oracle-databaseoracle11gcapitalize

Oracle sql capitalized turkish characters

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

Solution

  • 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')