Hi,
the quotes are no problem if they are passed in a String via parameters.
The rest should in general not be stored in a varchar.
The better way for persist binary values is a binary datatype.
Then you can use the ascii values or define char or byte with
someting like '\n'.
--- Juergen ---
"Elia Morling" <eli..amiljen.se> schrieb am 01.08.04 13:44:10:
>
> Greetings,
> MySQL requires substitution of the following. I was wondering if Cayenne takes
> care of that when storing text.
>
> Elia
>
> -- \0 An ASCII 0 (NUL) character.
> -- \' A single quote (`'') character.
> -- \" A double quote (`"') character.
> -- \b A backspace character.
> -- \n A newline (linefeed) character.
> -- \r A carriage return character.
> -- \t A tab character.
> -- \z ASCII 26 (Control-Z). This character can be encoded as `\z' to allow you to work around the problem that ASCII 26 stannds
> for END-OF-FILE on Windows. (ASCII 26 will cause problems if you try to use mysql db_name < file_name.)
> -- \\ A backslash (`\') character.
> -- \% A `%' character. See note following table.
> -- \_ A `_' character. See note following table.
>
>
> ----- Original Message -----
> From: "Jürgen Saar" <Juerge..Saar.org>
> To: "Elia Morling" <eli..amiljen.se>
> Sent: Sunday, August 01, 2004 11:36 AM
> Subject: Re: SQL Escape Characters
>
>
> > Could you give me an exanple ?
> >
> > "Elia Morling" <eli..amiljen.se> schrieb am 31.07.04 14:55:45:
> > >
> > > Is there any built in support for encoding and decoding SQL escape
> > > characters? If not, is there a common library to use for this?
> > >
> > > Elia
> > >
> >
> >
> > ____________________________________________________
> > Aufnehmen, abschicken, nah sein - So einfach ist
> > WEB.DE Video-Mail: http://freemail.web.de/?mc=021200
> >
> >
> >
>
>
_______________________________________________________
WEB.DE Video-Mail - Sagen Sie mehr mit bewegten Bildern
Informationen unter: http://freemail.web.de/?mc=021199
This archive was generated by hypermail 2.0.0 : Sun Aug 01 2004 - 10:48:28 EDT