Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
viperbyte
Posting Yak Master
132 Posts |
 Posted - 2011-08-19 : 09:23:57
|
| Hi everyone. I did a database for a vworker client and I've learned of a problem with the special character of the French language. Client says that the characters cannot be entered directly in the table through SQL Server Management Studio but he can add or edit data correctly with the special characters through his ASP front end app. I scripted the database with Visual Studio and executed the script on his db server. Here's a snippet of one table. The way I went about creating the tables was through SQL Server Management Studio. Most columns that needed to support text; I made them varchar(255). A few needed memo type. Anyway here's a snippet of the script of one table. Was I supposed to do something in creating the table that would allow it to have the French Special characters entered at the keyboard in Management Studio? Can someone please help me with this?IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblLanguages]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[tblLanguages]( [ID] [int] IDENTITY(1,1) NOT NULL, [NameEng] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [NameFra] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_tblLanguages] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON))ENDGO |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
viperbyte
Posting Yak Master
132 Posts |
Posted - 2011-08-19 : 13:52:45
|
| Thanks Tara. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Special character support