I have an application which downloads data from a SQL server on the network to a local SQl server. On downloading the data on some machines we see a problem. This problem is that the data on the server (network server) contains strings that have extended characters - for instance é, and hats over o's. On the client machine with Windows NT4.0 and a desktop version of SQL server on downloading such a string - a 'é' is now fed through as a '#' which is causing upset on the reports that are produced. On my laptop fitted with Windows 2000 and a full copy of SQL Server 7.0 the problem does not arise. On an NT 4.0 Workstation with full copy of SQL server 7.0 the problem does not occur.
Is there an option that allows 'extended' characters - this is an option I am unfamiliar with -ASCII codes and the like. Can I fix this issue ?
Can anyone point me in the right direction with this ?
Thanks in advance.
Steve.
Is there an option that allows 'extended' characters - this is an option I am unfamiliar with -ASCII codes and the like. Can I fix this issue ?
Can anyone point me in the right direction with this ?
Thanks in advance.
Steve.