Hello All,
Can anyone help me how to insert html code in mysql database coloumn and also how to change the var char to 1000, for now it is 100.
Please help me out
thanks 7 regards
Raj
digidreams
0
Newbie Poster
Recommended Answers
Jump to PostFirsty a VARCHAR cannot exceed 255 characters. You'd need to use a TEXT field type instead.
And when inserting HTML into a database I always escape it before inserting and before redisplaying it onscreeen to prevent XSS. So for a how to, just Google for XSS.
R.
All 2 Replies
blocblue
238
Posting Pro in Training
Featured Poster
Firsty a VARCHAR cannot exceed 255 characters. You'd need to use a TEXT field type instead.
And when inserting HTML into a database I always escape it before inserting and before redisplaying it onscreeen to prevent XSS. So for a how to, just Google for XSS.
R.
indianrock9
0
Newbie Poster
Hi Raj,
Click on the 'Structure' Tab of the table where you need to make the change. Then click on the Pencil icon against the field that you want to change. This will show you the field & it's assigned type, length, etc. in Edit mode. You will see the 'Length/Values' field as 100. You should be able to change it to 1000 here. Click on Save button & you should be done.
Let us know if this worked for you.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.