Re: Function like translate in oracle

Currently there is no built-in function for this, but it may be added.
In the meantime, Write a function in SQL or Java.

Fred

SQL function body looks like this:

CREATE FUNCTION TRANSLATE(str VARCHAR(100000), source VARCHAR(1000),
dest VARCHAR(1000) )
RETURNS VARCHAR(100000)
BEGIN ATOMIC

-- form a string using LOCATE and OVERLAY functions in a loop

-- return the string
END


On Sat, May 4, 2013, at 12:20, Vinícius Rabelo wrote:

Hi,

I need one function to remove the accents from one column, like the
translate function in oracle:
translate( pString, 'ÁÇÉÍÓÚÀÈÌÒÙÂÊÎÔÛÃÕËÜáçéíóúàèìòùâêîôûãõëü',
'ACEIOUAEIOUAEIOUAOEUaceiouaeiouaeiouaoeu');

How to make this in HSQLDB?

Thanks a lot

-----------------------------------------------------------------------
-------

Get 100% visibility into Java/.NET code with AppDynamics Lite

It's a free troubleshooting tool designed for production

Get down to code-level detail for bottlenecks, with <2% overhead.

Download for free and get started troubleshooting in minutes.

[1]http://p.sf.net/sfu/appdyn_d2d_ap2

_______________________________________________

Hsqldb-user mailing list

[2][email protected]

[3]https://lists.sourceforge.net/lists/listinfo/hsqldb-user

References

1. http://p.sf.net/sfu/appdyn_d2d_ap2
2. mailto:[email protected]
3. https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite
It's a free troubleshooting tool designed for production
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap2

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user