Stefan Groschupf wrote: > Hi, > there what is a coresponding datatype for a mysql medium-text > in a sap db > that can unicode? > Thanks! > Stefan >
As CHAR(4000) UNICODE resp. CHAR (8000) ASCII is the maximum for normal character columns, the datatype LONG with the codetype ASCII resp. UNICODE will be the one you are looking for. In SAP DB there is no difference for mediumtext/longtext and so on. LONG will be able to store up to 2GB. !! But please be aware that with LONG-datatypes there are several restrictions: no functions on it, no conditions for it (except for IS[NOT] NULL) and of course no distinct for a select-list a LONG is part of, no index for LONG. Elke _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
