List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:February 7 2006 3:06pm
Subject:Re: replacement for Oracle initcap function
View as plain text  
Hello.

It seems that there is no such functions:
  http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

However, it should be possible to do with:
  http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html
  http://dev.mysql.com/doc/refman/5.0/en/adding-functions.html



Sid Lane wrote:
> I am finishing up on performing an Oraclectomy on a bunch of legacy java
> code (don't ask why the DBA got stuck w/this - sore subject) and have one
> outstanding problem to solve:
> 
> Oracle has a function, initcap(), which capitalizes the 1st character of
> each word and lowercases the rest.  for example, initcap('ABC DEF GHI') =
> 'Abc Def Ghi'.
> 
> I have not found a (my)sql way to do this.  did I overlook something or do I
> need to do this client side after I fetch the results?
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com
Thread
replacement for Oracle initcap functionSid Lane6 Feb
  • Re: replacement for Oracle initcap functionGleb Paharenko7 Feb