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]
