euro conversion problem 
Author Message
 euro conversion problem
By running this on some servers:
create table #testtbl (
euro varchar(10) null)
go
insert into #testtbl values ('?')
select * from #testtbl
drop table #testtbl
go

...I get
euro
----------
?

...but elsewhere I get
euro
----------
?

What should I be comparing? I know it is not:
default login language problem

ANSI compatibility issue

regional character translation problem

thanks

Louis



Mon, 19 Aug 2002 03:00:00 GMT
 euro conversion problem

We are seeing a discrepancy between some SQL 7 SP1 servers in how they deal
with the euro symbol, inserted and retrieved from the same client using
query analyser.

By running this on some servers:

create table #testtbl (euro varchar(10) null)
go

insert into #testtbl values ('?') -- (NB inserting the euro symbol as per
alt-0128, not ? )

select * from #testtbl

drop table #testtbl
go

...I get
euro
----------
?
(i.e. a question mark)

...but elsewhere I get
euro
----------
?
(i.e. the actual euro symbol as per alt-0128)

What should I be comparing between servers that preserve the euro symbol and
the ones that don't? I know (think) it is not a default login language
problem or an ANSI compatibility issue or a regional character translation
problem.

You may be seeing all ?'s  (question marks) instead of ? 's (euro symbols)
in this post - hence the bracketed notes. This may well be a part of the
puzzle... Perhaps somebody could explain how SQL Server stores the euro in
the first place because it is not in the character set any of my servers
use:

Character Set = 1, iso_1
    ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Characters, in Order
------------------------

  ~   ? | ? a ? ? - ? 2 3 ? ? 1 o ? ? ? ?
  ? 0 1 2 3 4 5 6 7 8 9 A=a = = ?=a ?=? ?=? ?=? ?=? B=b C
 =c ?=? D=d E=e = = = ?=? F=f G=g H=h I=i = = ?=? ?=? J
 =j K=k L=l M=m N=n ?=? O=o = = ?=? ?=? ?=? ?=? P=p Q=q R=r S
 =s ? T=t U=u = = ?=? = V=v W=w X=x Y=y Y=y ? Z=z D=e T=t

Does anybody know of some good euro docs for NT and SQL Server? (a bit scant
in BOL, msdn and technet unless you could point at an article I missed...)

thanks a million

Louis



Tue, 20 Aug 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. euro conversion problem

2. Information_schema used for EURO-conversion ?

3. need magic formula for euro conversion

4. Euro conversion ????????????????????

5. Euro conversion

6. euro conversion

7. Euro conversion...

8. Euro conversion to be stored on decimal column

9. Code page problems - pound sign, euro sign sometimes translated

10. Euro Symbol problem

11. € Euro symbol problem

12. EURO, Dual currency problems


 
Powered by phpBB® Forum Software