Our implementation of cute editor writes the text to a sql db, if I look at the data stored in sql it seems like any line break creates some unrecognizable characters, as well as the correct <br /> or <p> tags.  When I try to use the data in sql in another app. it doesn't work out that well because of the unrecognizable characters.  

 

The sql column datatype is varchar.  

 

I have read something about Server.Encoding/Decoding, but I am fairly new to this and would need to be walked through this if that is a possible solution.

 

Any help would be much appreciated.

 

Thanks.

rob99999,

 

 

The source code of this example is included in the download package.

 

Keep me posted

Hi Adam,

Thanks for the example. 

 

After taking a look at HTML encode we added.

Rob,

 

I have no idea where those characters come from.

 

Do you try this example?

 

 

If you don't have problems with it, please try this example in you local machine.

 

Keep me posted

Hi

 

The square things are just enterprise managers way of showing CR and LF. What other apps are you trying to use the data in?

If you do a select statement in sql manager and show the results as text, does the text look properly formatted? It should do...

 

When saving and retrieving from the database I dont do any encoding/decoding. I just send a string and get a string and its all shown fine.

 

You may want to consider using NVarchar instead of Varchar because this then means you can store characters outside the standard ascii range e.g. different character sets or symbols. But these will still be shown as squares in sql manager.

 

 

Hi AndyFel,

 

Thanks much, for taking the time.

- The query results in default sql server grid don't show the boxes (as you suggested wouldn't happen), but there are spaces in between. 

so it looks like:  asd<br />  asd<br />  asd<br />  <br />

 

- The query resutls to text look like the following:

 

 

 

 

- If I remove the CR and LF boxes manually by editting the table in Ent. Manager (man. studio) the text displays perfectly when I query from sql server (no spaces) and as well in the flash application that is grabbing data from the database.

 

- I switched the column datatype to nvarchar as suggested - but no change for me here.

 

- Any info on how to remove the CR and LF boxes? or possibly any other ideas?

 

Thanks again to Adam and AndyFel for there continued help, 

 

Rob

Hi all,

 

Looks like a REPLACE did the trick for us.  

 

CEDescription.Text.Trim.Replace(vbCrLf, "").Replace(Environment.NewLine, "")

 

After looking at some sql server posts, I guess its pretty common for CR and LF to get combined and turned into some SQUARE character display in the database. 

 

Thanks to all those who helped out.  Hope this helps someone else along the way.

 

Rob 

Hi

 

Yep replace would do the trick but you have now lost all your newline formatting. So if you come to edit the html again all the text would be one one line.

 

It may be better to do the replace when you suck the data out of the DB for the flash, and leave it if you are trying to edit it again.

 

The Nvarchar column wouldnt of helped in this case, it just means you can store non standard chars and get them out again.

 

Glad its working anyway.

 

Andy