unicode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tvin - 15 Mar 2006 22:36 GMT

I have a problem: I need to convert a standard string to a
unicode string and want to send this unicode-string to a
Stored Procedure in SQL-Server. How do I convert a usual
String to a unicode string? When I use a bounded field and
save it directly to the database, then it works.

Any idea?

Reply to this Message

Klaus H. Probst - 16 Mar 2006 05:12 GMT

Internally .NET strings are already Unicode. All you need to do is type the
stored procedure's parameter as nvarchar or nchar.

Signature

Klaus H. Probst, MVP
http://www.simulplex.net/

>I have a problem: I need to convert a standard string to a
> unicode string and want to send this unicode-string to a
[quoted text clipped - 3 lines]
>
> Any idea?

Reply to this Message

tvin - 16 Mar 2006 07:23 GMT

hi klaus

> Internally .NET strings are already Unicode. All you need to do is type the
> stored procedure's parameter as nvarchar or nchar.
[quoted text clipped - 6 lines]
> >
> > Any idea?

my parameter is nvarchar,but my really problem is that the "standard string"
which i brought it from utf-8 file,didn't convert correctly to unicode
string in .net

Reply to this Message

Adam May - 20 Mar 2006 00:46 GMT

Hi tvin,

Have a look at the GetBytes method of System.Text.UnicodeEncoding.

Adam

Signature

Adam May
Sydney, Australia
MCSD.Net

> hi klaus
>
[quoted text clipped - 12 lines]
> which i brought it from utf-8 file,didn't convert correctly to unicode
> string in .net

Reply to this Message

unicode

Free Magazines