Subject | Problem with special german characters |
---|---|
Author | ille7 |
Post date | 2006-05-29T06:22:11Z |
Hi,
I've got the following problem if I try to select records from my db:
I've got an table (named "texte") with an column named "title" and the
characterset is "NONE".
One of the records has in this column the string "Förderung".
If I try
SELECT title FROM texte WHERE (UPPER(title) = 'FÖRDERUNG')
I get no records return!
If I try
SELECT title FROM texte WHERE (title = 'Förderung')
I get the right record return.
I use FB Server 1.5.2.4731 and the FireBird .Net-Provider 1.7.0b.
Thanks for your help.
Carsten
[Non-text portions of this message have been removed]
I've got the following problem if I try to select records from my db:
I've got an table (named "texte") with an column named "title" and the
characterset is "NONE".
One of the records has in this column the string "Förderung".
If I try
SELECT title FROM texte WHERE (UPPER(title) = 'FÖRDERUNG')
I get no records return!
If I try
SELECT title FROM texte WHERE (title = 'Förderung')
I get the right record return.
I use FB Server 1.5.2.4731 and the FireBird .Net-Provider 1.7.0b.
Thanks for your help.
Carsten
[Non-text portions of this message have been removed]