By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,705 Members | 2,017 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,705 IT Pros & Developers. It's quick & easy.

Special character problem

P: 3
I am picking records from xml file and saving them into mysql database. I am When I insert records, the special characters like ,, are being transformed into some unwanted values.
I tried to insert those values manualy by giving
insert into table_name...... this command on command line.
It works fine and store even special characters as well.
But when I Pick the record from xml and insert them into mysql it does not insert ,, etc.
Note: Data is correct in xml file, and special characters are saved in xml file properly and I can view them correctly.

I would be greatly thankful if you please suggest any solution.
Thank you.
Aug 9 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 5,821
Heya, Azam.

You posted this in the Articles section. I'll go ahead and move it to the Forum where an Expert will be more likely to find it.
Aug 9 '07 #2

Expert 5K+
P: 5,058
I would quess that this has something to do with the charsets of the XML document and the MySQL table.

If you copy special characters from a XML using ITF charset into a table using ISO charset, the original characters will be copied incorrectly.
Aug 9 '07 #3

Post your reply

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