Hi

I have a problem with storing rich text in MySQL.
I store rich text in MySQL (in column with type "text") which i get
from Rich Textbox control. When i do reverse processing by trying to
fill rich text back to rich techbox (i set correct property "Rtf") i
get whole text like:

{
tf1ansiansicpg1250deff0deflang1029{fonttbl{f0fnilfcharset0
Arial;}{f1fnilfcharset238 Microsoft Sans Serif;}}
viewkind4uc1pardlang1033fs16 rtyrtyrtlang1029f1fs17par
}

There must be some kind of conversion which i cannot discover ;(
Everything works ok when i store this in Access.

Any help apprecitiated. Thank in advance.

Tomi

<tomi.trescak [at] gmail.com> wrote in message
news:1157669736.047254.182120 [at] i42g2000cwa.googlegroups.com.. .
> Hi
>
> I have a problem with storing rich text in MySQL.
> I store rich text in MySQL (in column with type "text") which i get
> from Rich Textbox control. When i do reverse processing by trying to
> fill rich text back to rich techbox (i set correct property "Rtf") i
> get whole text like:
>
> {
> tf1ansiansicpg1250deff0deflang1029{fonttbl{f0fnilfcharset0
> Arial;}{f1fnilfcharset238 Microsoft Sans Serif;}}
> viewkind4uc1pardlang1033fs16 rtyrtyrtlang1029f1fs17par
> }
>
> There must be some kind of conversion which i cannot discover ;(
> Everything works ok when i store this in Access.
>
> Any help apprecitiated. Thank in advance.
>
> Tomi

Try storing it in a blob and see if you get what you expect. I believe (but
am not positive) that rich text contains binary data.