Convert to Unicode in ASP 1

[msoul]

Hi,

I need to convert a string to Unicode and store it in Sql server 2000. And retrieve it from the database and display it on the screen.

How do I convert a string or text to unicode in ASP?
And do i make any changes to field datatype to store the unicode?

Thanks in advance...

 

[Sheco]

Create your tables with datatype nchar instead of char and nvarchar instead of varchar and you should be fine.

 

[msoul]

I really appreciate your reply. What would happen if i leave the database in varchar instead of nvarchar because i need the size 5000 for that field and nvarchar accepts only 4000.

Anything on converting to Unicode in ASP?

Thanks

 

[Sheco]

Right, because unicode uses 2 bytes per character.

You could use the ntext data type if nvarchar is too small but you should ask yourself why you want unicode at all?

Are you storing some text that is not in English? Do you have some Chinese or other language that required an extended characterset?

 

[msoul]

We needed to store characters other than english too, that is the reason I was planning to use Unicode to store the data.

Thanks

 

[msoul]

how do I convert to Unicode in asp?

 

[Sheco]

Have you seen this page from Microsoft?

http://www.microsoft.com/technet/pr...gies/iis/maintain/featusability/interasp.mspx