Re: Initcap screws spanish characters

You need to use an NLS aware version of this function called NLS_INITCAP Hth,

Sybrand Bakker, Oracle DBA

"RazorWings18" <razorwings18_at_usa.net> wrote in message news:9547ln$1s0$1_at_nnrp1.deja.com...
> I´ve got an issue with the Initcap function I need to solve as soon as
> possible:
> My (Oracle8)database is currently storing several records containing
> spanish characters like ñ, á, é, í, ó and ú. NLS_LANG is set to
> SPANISH, and I can both store and retrieve these characters. But when
> using the Initcap function in a SQL query to get records containing
> these characters they're screwed up and, for example, returns "Espaqa"
> when it should return "España".
>
> Here's a sample query:
>
> SELECT
> INITCAP(name)
> FROM
> COUNTRIES
> ORDER BY
> name;
>
> returns
>
> name
> ----
>
> Canadq (should be Canadá)
> Espaqa (should be España)
> Gran Bretaqa (should be Gran Bretaña)
>
> The funny part is that no such thing happens in our staging server,
> even though ini and several other files look just the same.
>
> Any ideas are most welcome.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 29 2001 - 11:31:47 CST