Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Question about User defined data type and 'COLLATE SQL_Latin1_General_CP1_CI_AS'

    What is 'COLLATE SQL_Latin1_General_CP1_CI_AS'? I am new to
    SQLServer, and couldn't find much information on the Web. Also,
    I am trying to understand user defined data types. For example,

    In the following example, what is '[Price_DT]' data type? and how would
    it be referenced at the time of 'INSERT'.

    CREATE TABLE [dbo].[Dist_Orders_Master_Index] (
    [SubTotal] [Price_DT] NOT NULL ,
    [Tax] [Price_DT] NOT NULL
    ) ON [PRIMARY]

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    'COLLATE SQL_Latin1_General_CP1_CI_AS' is the default collation for 1252 code page (CP1 - 1252). CI - case insensitive, AS - accent sensitive.

    Price_DT is a user-defined datatype which is based probably on datetime. In order to see the actual datatype go to Query Analyzer, Tools/Options, select Script tab and scroll down to Table Scripting Options. The second down should read "Convert specifications of user-defined data type..." Make sure it's checked. Click OK and right-mouse click on the table, select Script object to new window as Create...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts