Bugs or features?

Jeroen Boomgaardt <[email protected]> Thu, 11 Sep 2003 22:47:05 +0200

Newsgroups	gmane.comp.db.sapdb.general
Organization	Swissclue
Message-ID	<[email protected]>

This looks like a bug to me:

SELECT MAPCHAR('bÃ¼g') FROM dual
results in the error
DBD::ODBC::db prepare failed: [SAP AG][LIBSQLOD SO][SAP DB]General error;-2010 POS(8) Assignment impossible, char value too long. (SQL-S1000)(DBD: st_prepare/SQLPrepare err=-1).
while
SELECT MAPCHAR('bÃ¼g ') FROM dual
returns 'bueg'

Not sure if this one is a bug or a feature:
If I want to find the names containing a space, I have to use
SELECT * FROM customer WHERE name LIKE '% _%'
because
SELECT * FROM customer WHERE name LIKE '% %'
returns all records...

Both issues seen with 7.3.0.40 and earlier.

Regards,

Jeroen Boomgaardt