Connecting Tech Pros Worldwide Help | Site Map

Why I am getting Inverted quetion (?)mark?

Newbie
 
Join Date: Aug 2009
Posts: 2
#1: Aug 6 '09
Hi ,
I am facing a strange problem.I am supporting a application which is in VB and database is Oracle 9i.Now the problem is one of the production user(Say USER 1) is getting an inverted question mark instead of apostrophe in one text box(it is retreving varchar information from database) but the another user (SAY USER 2)is not facing the same issue. I had checked both the machines and only difference i got is one of them have SP3(USER 1) and the other have SP2(USER 2).

Previously my machine have SP3 and I was having the same issue.Now I had downgraded my system to SP2 from SP3 but issue is still not resolved.

Am I missing something basic here or is tere any character set issue in this?

I am giving the text appearing in different system and in database.

USER 1(sp3) text -Don¿t Make Them Think.

USER 2(sp2) text-Dont' Make Them Think.

As in Database -Don¿t Make Them Think.

In actual it should be -Dont' Make Them Think in USER 1 machine but constraint is I do not want to update data in database.

Hope I am clear

Thanks in advance
Newbie
 
Join Date: Aug 2009
Posts: 2
#2: Aug 14 '09

re: Why I am getting Inverted quetion (?)mark?


Hey ,
i solved it.It was very easy.The NLS characters set of my database was not the same which was was entered in window registry.

I changed the registry and that did the trick.
Hope this will help somwonw in future.
Reply