473,598 Members | 3,183 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Characters Issue

384 Contributor
I have a textarea and when i add content to the DB say:
It will ad fine, but if i query that string from the DB and place it in a textarea to be edited and save it, anything after and including the & is removed, this seems to happen with & and ; characters. These are the only to i've come across so far, can't seem to figure it out!??
Mar 13 '09 #1
7 1113
1,168 Recognized Expert Top Contributor
Not 100% sure but do you have magic_quotes on? Do you strip/add slashes?Can you use html replacements?
Mar 13 '09 #2
384 Contributor
magic_quotes is turned off in the htaccess file and strip slashes is being used!?
Mar 15 '09 #3
6,050 Recognized Expert Expert
With HTML & has a special use. Change it to it's entity equivalent (&)

Mar 15 '09 #4
384 Contributor
That will just give the same problem because the two characters causing the problem are bout in it & and ;!?!
Mar 15 '09 #5
1,168 Recognized Expert Top Contributor
What is your database saving it as? If you have MyPHPAdmin or something to view your database values, see if "&" and ";" characters are being stored there. If so, then it is your database output script that we need to look at, otherwise it is the input.
Mar 16 '09 #6
384 Contributor
Ok, i've tested it and this is how it is stored:

I create a new article on the site with the & symbol and it saves to the database, it shows up in the database as & and then when i edit the article on the website it outputs the symbol & but it removes it when saving from the edit!?
Mar 16 '09 #7
1,168 Recognized Expert Top Contributor
Well I guess the obvious question is: does the edit get processed the same way as the new form? I imagine no which is why there is a difference. Can you post any differences between how those two forms are handled?
Mar 17 '09 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

by: lkrubner | last post by:
What I need to do is find out what characters in a string are not supported by the UTF-8 encoding. The problem arises when someone logs in and uses my php script to create a weblog post. They are presented with a form that has a textarea. If they type in words and then hit submit, then all is fine. But if they write their entry in WordPerfect or Microsoft Word or some such, and copy and paste it, then they might be bringing strange...
by: LRW | last post by:
I'm sorry, I don't know if this is a mySQL issue, or a Putty error, or what. So if there's a better newsgroup for this question, please let me know. I'm using Putty to SSH into our remote Linux server. On one of our mySQL databases, we have a table of users. One of the fields used to store passwords we have as type "BLOG" and we use the ENCODE/DECODE to encrypt passwords. Now, when we do a select of a row from that table, because the
by: Greg Ferris | last post by:
I have read a number of posts with techniques for limiting the max number of characters entered into a textarea, but I'm looking for some advice on how to limit the number of rows and the number of characters per row. Basically, I need to allow users to enter up to 5 rows of data with up to 40 characters per row, regardless of whether or not the user has explicitly entered any line breaks. I also need to consider where to break off each...
by: Richard | last post by:
Here is the program problem: Month with 30 days have 720 hours, and month with 31 days have 744 hours. February, with 28 days, has 672 hours. Enhance the input validation of the program code below by asking user for the month (by name), and validating that the number of hours entered is not more than the maximum number of the entire month. There is a table that display how many days in each month and their hours. It is unnecessary to...
by: Jain, Pranay Kumar | last post by:
Hello Everyone, I have written a simple app. that converts the dataset into excelspreadsheet. The App. uses the following architecture. First it generates the dataset with corresponding datatables(each datatable represents a worksheet).It uses an Xslt file to do the transformation of the xml (generate from dataset) and write the output xml into a xmltextwriter. The App converts the data into excel with almost all of the formatting
by: Satish | last post by:
Hi Gurus, Please help me in this, I have tried all options available to me. (Option 1) I am making a simple request from VB.NET client to WBI generated WSDL and passing request parameters. The response I am expecting should have some accented characters (Customer Name: Lokalcenter Åbygård), but this gets truncated and response is as follows (Customer Name: Lokalcenter bygrd). The WSDL has utf-8 character set defined.
by: Steve Grahovac | last post by:
I have been having trouble the last few days opening any ASP.NET web forms in the design view in the designer. Every time I clicked on an aspx file I got a message box with the error "Unable to open in designer. Illegal characters in path" and the file is instead opened in HTML view. I don't know what application or situation may have caused this error. I looked on the newsgroups and noticed that numerous other people were having this...
by: Rolf Barbakken | last post by:
We have a case where users who are encouraged to have good passwords with norwegian characters and other special characters cannot login to a ASP.NET 1.0 app. This problem is discussed in the following article from MSKB: http://www.kbalertz.com/kb_835388.aspx Do you know if this problem is fixed in later versions of the framework? I.e. servicepacks, 1.1 or 2.0.
by: Johhny | last post by:
Hello, I am currently trying to write some scripts to get information from the xmlrpc for redhat network. One of the issues I am having is trying to strip off the special characters in the hash that is returned. Here is an example of the information returned within the hash : ===SNIP=== {'errata_update_date': '2005-12-06', 'errata_topic': 'Updated libc-client packages that fix a buffer overflow issue are
by: prajithgg | last post by:
Hi, I am facing some problem while inserting some non English characters to DB2 server from my java application. We are not able to retrieve the same record when searched with the same non English string. The data I tried is ĂąΏΓΔπήЄЊЯҖכظٔⁿ∑┴♠☺♫שׁﭯ שׁﭯﻼ (To be frank, I dont know which language it isThis is a bug reported by one of our client) . Our observations/findings 1. On research, we noticed that the non...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.