Error when sorting with german charakters
"Horst Lehmann" <[email protected]> Wed, 3 Sep 2003 15:06:06 +0200
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
As a Newbie I tried to solve the problem of sorting the result of a query in the following way: ------------- SELECT ........... ORDER BY REPLACE(REPLACE(REPLACE(REPLACE(UPPER(NACHNAME),'Ö','OE'),'Ü','UE'),'Ä','AE' ),'ß','SS')"; The following error occured: SQL error: [SAP AG][LIBSQLOD SO][SAP DB]General error;-1013 POS(1281) Too many order columns., SQL state S1000 in -SQLExecDirect -------------- When i use: SELECT ........... ORDER BY REPLACE(REPLACE(REPLACE(REPLACE(UPPER(NACHNAME),'Ö','O'),'Ü','U'),'Ä','A'),' ß','SS')"; ...it works fine -------------- My question: Is this a limitation of the ODBC-Driver or could this be solved by changing any configuration entry? May be there's a better way of sorting? With kind regards Horst