-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Moin,
I prefer on application site to store cahr/varchar contents mime64 encoded,
due problems with non printable/control characters in such strings:
- - often sql-statements does not work in repmcli, if such a column contains \' or \"
or \r or \n
- - dataextract and dataload does not work any more, if a \n \r is in the string
- - somewhhat script language php, perl, python, java quits on such strings also
As work arounf I use mime64 encoded strings to be stored in Sap-DB, this has the
benefits:
- - works, in any environments, due the critical chars are not disturbing anymore
this are the contras:
- - "order by" ist not usable
- - "index" is not mor sufficient
So it would be fine to have both combined.
If the SapDB kernel would know about mime64 it could be possible:
create table mime_example
(
id int default serial,
name char(40) mime64,
memo char(4096) mime64
primary key (id, name)
)
//
and this could work also:
select * from mime_example order by name
//
How about that ?
Greetings from cold, wet Germany's north
J�rgen Sauer
- --
J�rgen Sauer - AutomatiX GmbH, +49-4209-4699, [EMAIL PROTECTED] **
** Das Linux Systemhaus - Service - Support - Server - L�sungen **
** http://www.automatix.de http://www.kranautomatisierung.de **
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE+LFwmW7UKI9EqarERAqlpAJ98wK7pgzdUlA/rKSK05ZwvIiUUPQCeOKe2
oaB6zMyDc69ebcoc7O/11mU=
=wGl2
-----END PGP SIGNATURE-----
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
