matvespa Posted September 4, 2010 Share Posted September 4, 2010 I need to have a unlimited varchar. Anyone knows how i can get this done. I have a VERY LONG text and having varchar as the structure require me to limit my text. However, when i put it as TEXT, there is an issue with this sign: ( ' ). This is because, when i try putting ' like in Human's there is an error in TEXT. However, it works fine in VARCHAR but there's limitation. How can i achieve this? Quote Link to comment Share on other sites More sharing options...
JasonLewis Posted September 4, 2010 Share Posted September 4, 2010 You should be escaping data before it goes into a database, using mysql_real_escape_string, so that characters such as a single quote are escaped. If you have very long text then you should be using TEXT as your column type, not VARCHAR. Just ensure you escape any data before inserting it. Quote Link to comment Share on other sites More sharing options...
matvespa Posted September 5, 2010 Author Share Posted September 5, 2010 Hey Thanks....that is just what i need! Thank you very much!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.