I have an ASP ADO recordstat that is querying my sql server database. The lastname it needs to retrieve is "Banos" with the "n" being the n with a tilde special latin character.

However once my recordset grabs it using objRS("name"), the name is truncated to return "Ba" though actually is #55728;#56466;>o when I print out the last 3 characters using Mid. Why are the remaining characters getting trashed?

Melissa Mussitsch

When you run the query in Query Analyzer, is the name returned correctly or is it trashed there as well?

"The one language all programmers understand is profanity."

The name is displayed correctly in Query Analyzer.
I have discovered that the value is being returned as Ba and then 3 garbage characters when displayed in HTML. If I search for the ñ
character and replace it with ñ it will display in HTML. There are so many special characters however. Isn't there an easier way around searching for every possible special character in a latin or german name?

Thanks.
Melissa

Hmm, not that I know of. When I insert data into SQL Server, I have a special function that I wrote that looks for special characters and either replaces them with their HTML equivelant, or removes them entirely depending on the character.

What you *might* be able to do is create a similar function then run the results of your query through that function to replace all of your special characters.

Sorry that I can not be of more help.

"The one language all programmers understand is profanity."

That's what I was afraid of.

But thank you!
Melissa