Display of ? and Hex conversion

2004-07-02 Thread Boyd E. Hemphill
All: We discovered a rather odd situation where some space characters where being displayed as ?. In tracking this down, it was determined that the server had stored the hex value A0 rather than 20 by using this query: select LocationId, LevelId, Hex(NameLn),NameLn from Location where

Re: Display of ? and Hex conversion

2004-07-02 Thread Jim Winstead
On Fri, Jul 02, 2004 at 01:52:06PM -0500, Boyd E. Hemphill wrote: We discovered a rather odd situation where some space characters where being displayed as ?. In tracking this down, it was determined that the server had stored the hex value A0 rather than 20 by using this query: 'A0' is