I have developed an application with Delphi to work against a SQL Server database. If I set up a TDatabase component and point a query/datasource and DataGrid and it I view the contents of a database table. From some machines I see the correct strings - ie. 'some text with é characters' displayed in the resultant grid. From other machines with the same operating system (Windows NT 4.0 workstation) I get a situation where the 'é' is converted to a '#' (so I see 'some text with # characters' and then causes this data to be passed through the system.
I'm guessing other people have seen this issue on developing applications ?
Is there a solution ?
I have downloaded an update of the BDE (bde411en.exe) and will attempt to use this and see if this corrects the issue.
As a further note - on the machine I have the hiccup with (# in place of é) I can see the correct string data through using SQL Server Query Analyser.
Can anyone offer any advice with this issue ?
Thanks in advance.
Steve
I'm guessing other people have seen this issue on developing applications ?
Is there a solution ?
I have downloaded an update of the BDE (bde411en.exe) and will attempt to use this and see if this corrects the issue.
As a further note - on the machine I have the hiccup with (# in place of é) I can see the correct string data through using SQL Server Query Analyser.
Can anyone offer any advice with this issue ?
Thanks in advance.
Steve