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

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to