Re: How to get CHAR(32) in the field?

Hello Tommy,

When serializing a string in VS2005 and storing it in a xml-field in
SQL Server 2005 there is some places where a square is added to the
field. I have found this to be a space. But I would like to have this
done also when adding a record directly from an SQL-statement, but
when using CHAR(32) or NCHAR(32) only a space is added. Any ideas how
to add this square instead?

Well, I'm not sure why an seralizer would be replacing a space with a square, or what kind of square the square is, or how this is an XML question, but does this give you what you are looking for? :)

select N'this is a square: + nchar(9633)

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/


.

Loading