I am using Unicode(khmer Unicode) with SQL Server, but sql server doesn't support with unicode. What data type SQL supports with Unicode?
Thank for reply!

[Edited by lbuntha on 06-08-2006 at 01:00 PM GMT]

____________________________
ly buntha

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.