By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,213 Members | 1,086 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,213 IT Pros & Developers. It's quick & easy.

Storing and retreiving rich text from MySQL to rich textbox

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
<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.