mohsenm66
پنج شنبه 06 بهمن 1390, 18:27 عصر
من يه كوري نوشتم براي ايجاد جدول و ذخيره اطلاعات در آن . اما به جاي عبارات فارسي علامت سوال ذخيره ميشه . بايد چيكار كنم ؟
collation=SQL_Latin1_General_CP1_CI_AS
USE [mali]
GO
/****** Object: Table [dbo].
[list_menu] Script Date: 01/22/2012 11:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].
[list_menu](
[L_code] [smallint] NOT NULL,
[L_name] [nvarchar](250) NULL,
CONSTRAINT [PK_list_menu] PRIMARY KEY CLUSTERED
(
[L_code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
insert into list_menu (L_code,L_name) values (1,'سيسنم')
go
insert into list_menu (L_code,L_name) values (2,'تعاريف')
go
insert into list_menu (L_code,L_name) values (3,'شهريه')
go
insert into list_menu (L_code,L_name) values (4,'گزارش گيري')
go
collation=SQL_Latin1_General_CP1_CI_AS
USE [mali]
GO
/****** Object: Table [dbo].
[list_menu] Script Date: 01/22/2012 11:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].
[list_menu](
[L_code] [smallint] NOT NULL,
[L_name] [nvarchar](250) NULL,
CONSTRAINT [PK_list_menu] PRIMARY KEY CLUSTERED
(
[L_code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
insert into list_menu (L_code,L_name) values (1,'سيسنم')
go
insert into list_menu (L_code,L_name) values (2,'تعاريف')
go
insert into list_menu (L_code,L_name) values (3,'شهريه')
go
insert into list_menu (L_code,L_name) values (4,'گزارش گيري')
go