SQL danna kattiya meheta enna...............

[WAMI7]

mama sql eka install kala.dan mata one oken network monawath nathuwa SQL eka connect karaganna.mage SQL eka EXECUTE wenne na ne.udin thiyena message eka enne

 

[dushan1234]

you create sql server compact edition database. sql server compact edition not support data type char. You can use data type nchar instead of char data type

 

[WAMI7]

you create sql server compact edition database. sql server compact edition not support data type char. You can use data type nchar instead of char data type

thank you very much.and can you please tell me what is the difference between CHAR and NCHAR . i think i heard it some where

 

[dushan1234]

A Char field is a text field of a specific length. For example, a Char(50) field takes up 50 characters of storage in most databases even if you only store 1 character in it., or even none.

A VarChar field is a text field of variable length. For example, a VarChar(50) field can be up to 50 characters but if less is stored, the length of the field is somewhat less than 50. If you only store 1 character in a VarChar, then generally only 1 character of space is taken up in storage.

The "N" in NChar and NVarChar stands for National character which means you can store unicode text. NChar and NVarChar take up twice as much storage space.

 

[K_ZONE]

A Char field is a text field of a specific length. For example, a Char(50) field takes up 50 characters of storage in most databases even if you only store 1 character in it., or even none.

A VarChar field is a text field of variable length. For example, a VarChar(50) field can be up to 50 characters but if less is stored, the length of the field is somewhat less than 50. If you only store 1 character in a VarChar, then generally only 1 character of space is taken up in storage.

The "N" in NChar and NVarChar stands for National character which means you can store unicode text. NChar and NVarChar take up twice as much storage space.

Correct !