Subject | UpperCase |
---|---|
Author | kjokker2003 <keld.jakobsen@microcom.dk> |
Post date | 2003-01-07T12:02:26Z |
We are using a firebird database under Linux.
Our problem is that can't perform a text-search when there are
specials characters (ÆØÅ) in the fields because we cant upper these
characters.
I have tried to install a UDF which have a ANSI_UPPER function but i
doesnt solve the problem, the result looks like this.
SQL Sentence "SELECT UDF_ANSIUPPER(NAVN1) FROM KUNDER"
Result:
A. CHRISTENSEN
A. Engstrøm
Is there anybody who have a function which can convert these
characters(æøå) to uppercase
Our problem is that can't perform a text-search when there are
specials characters (ÆØÅ) in the fields because we cant upper these
characters.
I have tried to install a UDF which have a ANSI_UPPER function but i
doesnt solve the problem, the result looks like this.
SQL Sentence "SELECT UDF_ANSIUPPER(NAVN1) FROM KUNDER"
Result:
A. CHRISTENSEN
A. Engstrøm
Is there anybody who have a function which can convert these
characters(æøå) to uppercase