May 30, 2003 at 6:48 am
Does anyone know what could cause a '£' to be replaced by another character when scripted.
I have an app, that uses a stored procedure, that is passed a parmeter of '£PP' which is then used to format the output. The app is run on a client's sever to which I have no rights to view, update, delete etc. I recently made a change to the stored procedure, scripted it and sent it to the client to run. Yesterday I was told that the sp no longer formatted correctly. When I looked at the sp on a copy of their database the '£' have been replaced with 'ú'. I'm at a loss to understand why this has happened can anyone help.
May 30, 2003 at 10:25 am
I may not have explained very well.
my sp has a parameter passed in containg the value '£PP' or '£P' this is then evaluated in the sp:
IF @params = '£PP'
BEGIN
format
END
else if @params = '£P'
BEGIN
format
END
however this now looks like
IF @params = 'úPP'
BEGIN
format
END
else if @params = 'úP'
BEGIN
format
END
therefore it no longer appears to be formatting.
My question is what would cause it to change from £ to ú, I think it might be to do with the language settings on the client's server. Any help would be greatly appreciated.
I sent over a new version of the Sp with the £ in it and when I have looked after this was recreated on their server it appears that the ú's are still there.
May 30, 2003 at 10:59 am
Usually this is a font issue (missing or non-matching type). Run a test and see if it can properly validate the right info.
June 2, 2003 at 2:50 am
Thank you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy