Subject | Re: [ib-support] UpperCase |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2003-01-07T13:09:42Z |
Hi Keld!
I just asked Aage and he said that he did something along the lines of
SELECT UPPER(NAVN1 COLLATE NO_NO) FROM KUNDER
(We use ISO8859_1 as character set)
I suppose you ought to replace NO_NO with DK_DK. Note that we only use
Firebird under Windows. I doubt Linux makes any difference, but don't know
for sure.
HTH,
Set
- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.FirebirdSQL.org/Foundation
I just asked Aage and he said that he did something along the lines of
SELECT UPPER(NAVN1 COLLATE NO_NO) FROM KUNDER
(We use ISO8859_1 as character set)
I suppose you ought to replace NO_NO with DK_DK. Note that we only use
Firebird under Windows. I doubt Linux makes any difference, but don't know
for sure.
HTH,
Set
- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.FirebirdSQL.org/Foundation