text: --create range partition table with nchar data type and one partition,then insert data to this table,the inserted separator field values are less than  separator value
  
  create table range_test(id int ,
  				test_char char(50),
  				test_varchar varchar(2000),
  				test_bit bit(16),
  				test_varbit bit varying(20),
  				test_nchar nchar(50),
  				test_nvarchar nchar varying(2000),
  				test_string string,
  				test_datetime timestamp, primary key(id,test_nchar))
  	PARTITION BY RANGE (test_nchar) (
  	    PARTITION p0 VALUES LESS THAN (N'ddd')
  	);
  	insert into range_test values(1,'aaa','aaa',B'1',B'1011',N'aaa',N'aaa','aaaaaaaaaa','2007-01-01 09:00:00');
  	insert into range_test values(2,'bbb','bbb',B'10',B'1100',NULL,N'bbb','bbbbbbbbbb','2007-01-01 09:00:00');
  	insert into range_test values(3,'ccc','ccc',B'11',B'1101',N'ccc',N'ccc','cccccccccc','2007-01-01 09:00:00');
  
  	select * from range_test order by 1,2,3,4,5,6,7,8;
  	select * from range_test where test_nchar is NULL;
  
  
  drop table range_test;
  