Skip to Main Content

Software Globalization Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ
Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Header container

September 10

18:00 UTC   Start Times Around the World

Stripping accents from letters in a string - simulating NLS_BASELETTER
In this session we answered a question about simulating a currently non-existent SQL function NLS_BASELETTER that would return a string with all accents (diacritic marks) stripped. Such function could be useful to prepare a version of text data (e.g. people names) for approximate search. (Note, however, that we recommend Oracle Text for advanced searching functionality.)

Subscribe to give us feedback and be notified of upcoming sessions!


Your Experts
Sergiusz Wolicki
Sergiusz Wolicki, Database Globalization Architect    
With Oracle since August 1994. In Oracle Support until October 2005. Now providing globalization advice to DB development and developing new globalization features.
Weiran Zhang
Weiran Zhang, Director of Development
Weiran Zhang is a Director of Development, Globalization Technology for Database Globalization.