Encoding SQL Server strings?

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

I need to encode varchar() types from SQL Server to ISO 8859 (western
europe). What is the best way to do this?

As an example, there are 100 rows with 10 columns each. All string types.

Thanks,
Brett
 
Brett said:
I need to encode varchar() types from SQL Server to ISO 8859 (western
europe). What is the best way to do this?

As an example, there are 100 rows with 10 columns each. All string types.
Click to expand...

I'm not entirely sure what you mean. What are you trying to do with the
data? All strings in .NET are Unicode, but if you really need to
convert them to a specific encoding (as a byte array) use
System.Text.Encoding.

See http://www.pobox.com/~skeet/csharp/unicode.html for more
information.
 
Back
Top