Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

™ Character in Varchar2 field

Status
Not open for further replies.

ianwin

Programmer
Jul 5, 2005
44
US
I have a product description field which I need to instert the character ™. I have a VB.Net program which allows the user to enter details into a text box and then writes the data to the database. I have recommended the user use the jeyboard shortcut alt(0153) to enter this and it displays ok, however when the data is retrieved from the database it is incorrect.

I have tried the same procedure using ® and alt(0174) which works ok.

Has anyone got any ideas?
Thanks,
-Ian
 
It's probably related to your NLS_LANG settings in server and client. A good starting point would be to find out what it's written to the database using the ASCII function.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top