GeoffS Level: VB Lord

 Registered: 29-09-2004 Posts: 536
|
Re: UniCode with SQL Server
Hi,
Use the data types :-
nchar
Fixed-length Unicode data with a maximum length of 4,000 characters
nvarchar
Variable-length Unicode data with a maximum length of 4,000 characters
ntext
Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters.
Check here for an overview of using Unicode Data :-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_03_6voh.asp
[Edited by GeoffS on 06-08-2006 at 02:03 PM GMT]
____________________________
multi-tasking - the ability to hang more than one app. at the same time.
|