467,910 Members | 1,644 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,910 developers. It's quick & easy.

Storing and retreiving rich text from MySQL to rich textbox

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{f0fnilf charset0
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

Sep 7 '06 #1
  • viewed: 10779
Share:
1 Reply
<to**********@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.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{f0fnilf charset0
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.
Sep 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by a_poster | last post: by
4 posts views Thread by Mark | last post: by
11 posts views Thread by ARC | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.