Display ￡ sign in SQL Server 7

Ian Yelland

Delphi Developer

Mon, 29 Nov 2004 00:53:08 GMT

Display ￡ sign in SQL Server 7

Hi,

I have a small app in D5 which reads a text file and inserts data via a
TStoredProc component thru BDE into a SQL Server 7 database. One piece of
data is a string which contains a sterling currency symbol '' (#163) going
into a varchar field.
If I run the app on one PC the symbol is inserted and displays correctly.
Run on another PC it is inserted and displays as a joined 'oe' character
(#156). I'm sure this is a configuration problem but does anyone know what
needs to be configured where for this to work correctly.

Regards
Ian Yelland.

Bob

Delphi Developer

Mon, 29 Nov 2004 01:32:28 GMT

Re:Display ￡ sign in SQL Server 7

probably a stupid question but have you checked regional settings from the
control panel ?

Bob

" Ian Yelland" <ian.yell...@proeq.co.uk> wrote in message
news:3d077d94_2@dnews...

Quote

> Hi,

> I have a small app in D5 which reads a text file and inserts data via a
> TStoredProc component thru BDE into a SQL Server 7 database. One piece of
> data is a string which contains a sterling currency symbol '' (#163)
going
> into a varchar field.
> If I run the app on one PC the symbol is inserted and displays correctly.
> Run on another PC it is inserted and displays as a joined 'oe' character
> (#156). I'm sure this is a configuration problem but does anyone know what
> needs to be configured where for this to work correctly.

> Regards
> Ian Yelland.

Ian Yellan

Delphi Developer

Mon, 29 Nov 2004 16:08:01 GMT

Re:Display ￡ sign in SQL Server 7

Given that the '' is just a character in a string, how would regional
settings affect this ?

Ian.

Quote

"Bob" <b...@bob.com> wrote in message news:3d078585_2@dnews...
> probably a stupid question but have you checked regional settings from the
> control panel ?

> Bob

> " Ian Yelland" <ian.yell...@proeq.co.uk> wrote in message
> news:3d077d94_2@dnews...
> > Hi,

> > I have a small app in D5 which reads a text file and inserts data via a
> > TStoredProc component thru BDE into a SQL Server 7 database. One piece
of
> > data is a string which contains a sterling currency symbol '' (#163)
> going
> > into a varchar field.
> > If I run the app on one PC the symbol is inserted and displays
correctly.
> > Run on another PC it is inserted and displays as a joined 'oe' character
> > (#156). I'm sure this is a configuration problem but does anyone know
what
> > needs to be configured where for this to work correctly.

> > Regards
> > Ian Yelland.

Bob

Delphi Developer

Wed, 01 Dec 2004 02:14:07 GMT

Re:Display ￡ sign in SQL Server 7

No idea, just thought it may be something for you to check ????

Bob

" Ian Yelland" <ian.yell...@proeq.co.uk> wrote in message
news:3d08533e$1_1@dnews...

Quote

> Given that the '' is just a character in a string, how would regional
> settings affect this ?

> Ian.

> "Bob" <b...@bob.com> wrote in message news:3d078585_2@dnews...
> > probably a stupid question but have you checked regional settings from
the
> > control panel ?

> > Bob

> > " Ian Yelland" <ian.yell...@proeq.co.uk> wrote in message
> > news:3d077d94_2@dnews...
> > > Hi,

> > > I have a small app in D5 which reads a text file and inserts data via
a
> > > TStoredProc component thru BDE into a SQL Server 7 database. One
piece
> of
> > > data is a string which contains a sterling currency symbol '' (#163)
> > going
> > > into a varchar field.
> > > If I run the app on one PC the symbol is inserted and displays
> correctly.
> > > Run on another PC it is inserted and displays as a joined 'oe'
character
> > > (#156). I'm sure this is a configuration problem but does anyone know
> what
> > > needs to be configured where for this to work correctly.

> > > Regards
> > > Ian Yelland.

Other Threads

1. Greek Language and ￡ sign Help !!

2. ODBC link with Access won't display ￡

3. MSSQL server and ￡ symbol problem

4. Connection between SQL Server 7.0 on win98 and SQL Server 7.0 on Win2000 advanced server

5. problem for displaying floating point value from a SQL server database

6. SQL Server Text Field Display Limited by Delphi

7. Display Date in Sql Server 2000; Delphi 6

8. SQL Server Currency display problem

9. Display the current RecNo in a DBgrid column with an SQL server dataset behind it

10. Signing On a SQL Database