I am using a Full version of soeditor and the text is basic html with images and text. Some of the text contains hyphens, copyright symbols, pound signs etc. They appear in design mode incorrectly and so you go into html mode and put the proper code in for then like £ or © and then when you come back to edit the html after it has been inserted into the db all of the symbol codes have been converted into their characters. So what was once £ now shows up as � and then this gets inserted into the db. When coming back to edit this code again the � becomes A� where the A is an A with a circle above it. Then on updating to the database the error grows until you have an endless number of strange characters in front of the single character that you want.
It might be that access is doing something funny with the text. Should I do something in the insert query to format the form var before insert/update? Thanks Dave At 09:30 8/12/2002 +0100, you wrote: >I think the way around creating a large field within Access is to use an OLE >field. The memo field as you state can only hold 64,000 characters. > >Which version of SO? Lite/Full?... Are you displaying and entering into the >HTML Code or Design window? > >Neil > > > >-----Original Message----- >From: Dave Phipps [mailto:[EMAIL PROTECTED]] >Sent: 12 August 2002 09:35 >To: ColdFusion User group >Subject: [ cf-dev ] Text field max size > > >Hi, > >I am inserting some text into an Access db (dev only) which will then be >moved over to a MySQL db on the prod server. I have noticed that the Memo >field in Access can only handle up to 64k of text. I have some text that >is larger than this which I need to get into the db so that migration to >the MySQL db will be easier. Is there a way to get access to accept more >than 64k in a memo field. MySQL has a LongText field which I don't think >has the same limit. > >Any ideas how to fix this or do I just have to wait until the MySQL db is >running and insert the data into that? > >I also have a question about SoEditor if anyone has come across the >following problem before. When you edit html in soeditor and then submit >the data to be inserted into the db it changes the following characters >into strange letters. So if you put £ into soeditor it ends up >looking like this A�, it changes copyrights, hyphens, apostrophes >etc. This happens once the data has gone into the db and then been read >back into soeditor. Is this Access doing some conversion or is soeditor >doing something funny? Also if I use the ascii code for the particular >character then insert into the db. When I read this back into soeditor it >converts the ascii into the character and then the next db update messes >the character up. > >Any ideas on a fix for this? > >Cheers > >Dave > > >============================================ >Phipps CF Development >Oxford, Oxfordshire. >Telephone: +44(0)7718 896696 >http://www.phipps-cf.co.uk >============================================ > > >-- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] > > >-- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] ============================================ Phipps CF Development Oxford, Oxfordshire. Telephone: +44(0)7718 896696 http://www.phipps-cf.co.uk ============================================ -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
