December 17, 2008 at 1:03 am
Hi Every1 ,
I have problem when i ever i store/Retrieve information from the database i am gettin some special characters .
like single quote(') is replace with ’
c the below programme name
Call in your peeps and your posse, bring out your finest bling and get ready to bounce with Vh1’s Hip Hop Hustle, showcasing some of the flyest B boys and B girls in the hood.
Could any1 tel me wat is the problem please need to sort out for asap ..
December 17, 2008 at 1:20 am
Check with the application developer.
He must have replaced all entries of single quotes with this character.
Usually programmers substitute single quotes with some other characters while writing to tables and recovert it to quote while displaying at the front end.
ASCII code for ’ is 226 and that of single quote is 39
December 17, 2008 at 1:57 am
Thnks pradeep singh for ur reply
but when i recvd output file it is displayed as below
The inspirational true story of Walter Gretzsky’s struggle to reclaim his life and reconnect with his family, after a stroke leaves him with no memory of his past.
the above programme when i copy and paste in note page it is displayed as
The inspirational true story of Walter Gretzsky's struggle to reclaim his life and reconnect with his family, after a stroke leaves him with no memory of his past.
wat wud be the problem
December 17, 2008 at 2:40 am
1. Are you querying your table to get that output?
2. What do you mean by program in this context?
3. I tried pasting Gretzsky’s to notepad and it remains as it is. ’ doesnt gets converted to '
December 17, 2008 at 3:43 am
ya i have writen a query to get the data from the DB ,so when i get an ouput file ,and read in excel file i am getin those chars
December 17, 2008 at 4:00 am
could we see the code ?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
December 17, 2008 at 4:22 am
I am QA engg n tryn to find out the routecause ,so i cant snd u the code ..
is they any way u can give me a solution that wud be apreciatable....
thnks
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply