Remove null characters from string in VB .NET

[alan6895]

I have an ASP .NET 2.0 page that reads tags in from files. These tags are read as an absolute length (like take everything from byte 0 to 29). The problem is that when the info in the tags is less than the length read in, the code replaces it will null characters. Then, when I store the data in SQL Server it stores the null characters with it. Strangely, if I open a record in SQL Server to edit it, it ignore the null characters, so I can't remove them. When the data is then pulled from SQL Server in Firefox or Safari, the null characters show up as ???????. IE7 doesn't do this. So, my question is, does anyone know how I can strip off the null characters from the string before I even store the data in SQL Server? Thanks!

 

[ca8msm]

What type of field are you storing it into in SQL Server?


------------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions

 

[alan6895]

I'm storing it as an nvarchar(50). I was hoping that this setting would allow me to store special characters in the data (like accented letters), but that doesn't seem to be working either...

 

[alan6895]

So after one more Google search and the discovery of the vbNullChar, I've fixed it. Now, the parameter inserted into the SQL command is run through String.Replace(vbNullChar, "") first.

 

[SiriusBlackOp]

I'm just curious if String.Trim would have cleared that up for you.

Senior Software Developer

http://www.scoutsft.com

 

[alan6895]

It may have, but then I would need an extra step of counting the letters in a string before trimming.

 

[SiriusBlackOp]

ok... I C.

Senior Software Developer

http://www.scoutsft.com